As we know, Sage X3 supports multiple date formats as per the user’s requirement. The default date format in Sage X3 is set in setup–> Parameters. The developers who want to manipulate the date field value can use the date format using 4GL script. Also, there is an inbuilt string function that can be useful… Read More »
In sage X3, we have a functionality of printing various types of reports such as Order, Invoice, Payments, and Receipt etc. This report is created by using a crystal report. Crystal Report is a very powerful tool used to pull data from sage and present it in a ways you want. Sometimes in crystal report,… Read More »
There are many instances when client wants to give multiple copies of the invoices to their customers, where they must segregate multiple copies into original and duplicate. So we have given option on the report for those client where at the header part Original and Duplicate check boxes are given. So if the specific invoice… Read More »
We come across the scenario, where we will use POSTMAN software tool to examine the working of external API. Postman is a simple GUI for sending HTTP requests and viewing responses. REST services are available in Sage x3 which returns data in a JSON format. In this blog, we are going to visualize the mapping… Read More »
Sometimes, you want to delete the address of a customer or Supplier or BP which is wrong or you want to change the address or you want to delete the address for some other reason. You can follow the below steps to check if the address can be deleted. Steps: If you need to delete… Read More »
As we know, using attachment featured In Sage X3, user can attach various documents/files against any masters or transactions screen. With this feature users can attach file types like word document, Image, Text, PDF and Excel etc. The attached documents can be the reference/source documents of that particular entry. This helps all the users to… Read More »
The function “EXEC_REST_WS” is used to call an external/outgoing REST web service from ASYRESTCLI library and returns the status of the operation, the parameters used in the function are described below, Parameter 1: Code :NAME Data Type :Char Description : Name of the REST web service created. Parameter 2: Code :HTTPMETHOD Data Type :Clbfile Description … Read More »
Purchase return is normally a part of business. In which, goods are returned to the supplier if they had any defects or not according to the specifications of the buyer. In Sage X3, while creating Purchase Return we may come across an error like ‘The quantity to be returned exceeds the maximum authorized: 0 UN’.… Read More »
Sometimes, it might happen that we need to transfer a file to the FTP server. The below piece of code will transfer the file to FTP. Parameters: HSTSITE It is the FTP server address on which the files will be transferred. HSTUSR and HSTPWD It is the Username and Password of the defined FTP server.… Read More »
Sometime we may come under a situation where we have to close the sales order through code. Keyword DIVSOHCLE is used to close the sales order record. For example: Below is a sales order which we have to close through our code. Fig1: Sales order record Use the keyword as… Read More »
