To read values from a csv file using a separator and writing the required values in a new file, follow the below steps- Open the directory where the csv file is located Specify the separator(e.g. “;”) and new line(e.g. “chr$(10)”) Read the values from a file Store the required values in variables Close the directory,… Read More »
In the sales module, sometimes we need to create the back to back order for a customer but customer credit limit exceeded. In this scenario, sage enterprises allow creating the back to back order by using the parameter set up. Follow the below steps. Navigate To: Parameters>General parameters>Parameters values>Sales>Order management rule>Back-to-back if > Credit Limit (DIRORDCTL)… Read More »
As you know, Sage Enterprise Management provides its own select, update statements like SQL. For efficiency, we can use SQL queries in Sage X3. Sage X3 provides special function to execute SQL statements/ commands. The special function is Execsql. It is used to launch a SQL request that does not require the return of information,… Read More »
In Sage Enterprise Management, we may come across a scenario where a user wants to enter dimensions value in the payment screen, but the system is not allowing it. This functionality can be achieved by the following steps: Navigate to: AP/AR accounting → Payments → Payment/Receipt entry Now select any payment type, let us take… Read More »
In Sage Enterprise Management sales module, sometimes we need to update or change the price of shipment as per newly changed shipment date or delivery date. Sage X3 has provided the parameter where you can set the order delivery price search “Yes” or “No”. Navigate To: Sales > Shipment management rules Parameter SDHRECPRI=”Yes” Sage X3… Read More »
In Sage Enterprise Management, we may come across a scenario where the user wants to hide a field from line level but not from popup screen in any screen. This functionality can be achieved by the following steps: Navigate to: Sales → Quotes → quotes In the below screenshot, we can see a field name… Read More »
Sage X3 People has a standard functionality to track the salary changes over a period of time. The function allows seeing the salary trend over a period of time which helps to keep a track of salary for any employee Navigate to Development → Local Menu-messages To set up salary tracking using standard functionality, below are the… Read More »
You may come across the situation, where you need to read the description from the miscellaneous table. One of the possible ways to do is as below: If !clalev ([ZAT]) : Local File ATEXTRA[ZAT] : Endif For [ZAT] WHERE CODFIC=’ATABDIV’ AND IDENT1=’32’ AND ZONE=’LNGDES’ AND LANGUE=GLANGUE infbox num$(TEXTE) next The TEXTE will return you the… Read More »
In Sage Enterprise Management People, we need to define Tax Year Start and Tax Year End after the “Year End Process”. Follow below steps: Navigate to: Setup → General Parameter → Parameter values → PAY Payroll-General Parameters → DAT In TAXSTRDAT enter the Tax Year Start date and in TAXENDDAT enter Tax Year End date.… Read More »
In Sage Enterprise Management, we may come across a scenario where we need to check to perform compulsory technical sheet analysis before production. For such a case Sage X3 provides an inbuilt technical sheet control functionality. Navigate to: Setup → General Parameter → Parameter values In the technical sheet control → Set, Yes with blocking. Now… Read More »
