We have come across the requirement where you need to call Third Party REST services from Sage X3. This can be achieved with the below steps. Create a REST API inside Sage X3 with the using the REST URL and the authentication credentials under Administration | Administration | Rest Web Services. Here, Name is the… Read More »
There might be a situation where we would need to read a file and extract a variable length amount from a line. So, consider an example string/file line- “abcdef1122,52pqr”. Here the amount which we need to extract is “1122,52”. Refer the below code snippet- Here, First, we find the position of “,” and store it… Read More »
In post versions of Sage X3 when we complete the installation, all the applications menus can be seen directly after login but EM 12 the process is bit different. When you create a solution and create an endpoint for the first time you can access the folder but to enable the menus in the application… Read More »
In Sage Enterprise Management, we may come across a scenario where we want the same data line while doing duplication of any transaction but the line is getting blank. This functionality can be achieved by the following steps: Navigate to: Common data → Products → Products → After sales tab Check product type and service… Read More »
In Sage Enterprise Management, as you know we have a special function to print the reports. To print a report, we need to enter the values in report parameters. In case, there are multiple parameters and you want to print the report for same parameters in future then instead of entering all the parameter values… Read More »
Sometimes while creating/writing to a file we might need to write values from a field in a grid but through a table and not by looping through the grid and the values would be written sequentially in a fixed number of fields in a single line in the file and assigning blank values to the… Read More »
You may come across the situation where you have printed the report while creation of any transaction. Consider an example for the same i.e we need to print the report “BONCDE2” while creating a purchase order to do so we have to go to the entry transaction of the purchase order and check Auto Print… Read More »
In Sage Enterprise Management (Sage X3), we may come across a scenario where we have lot managed product and everything but not we get blank data in the traceability screen. This functionality can be achieved by the following steps: Navigate to: Common Data → Products → products → Controls tab For displaying product in the… Read More »
In Sage Enterprise Management (Sage X3) we may need to copy the file from one folder to another folder. We will do it by using .bat process. Syntax: Subprog MoveFile(PATH1,PATH2) Value Char PATH1 Value Char PATH2 Local integer RETURN_VALUE RETURN_VALUE=Delfile(filpath(“TMP”,””,””,””,””,adxmac(0))+’\Copy.bat’) Local Char WRET(250) (0..4) Openo filpath(“TMP”,””,””,””,””,adxmac(0))+’\Copy.bat’ Using [FACS] WRET(0)=”copy “+PATH1+” “+PATH2 Wrseq WRET(0) Using [FACS]… Read More »
We have come across the requirement where excel data needs to be refreshed on the basis of Sage X3 data. This can be achieved with the below steps. We will need Sage addin available in the Microsoft Excel, this addin will link the data with Sage X3 database. If you will have Sage Addin available, this… Read More »
