In Sage X3, we know that users can create the PO order, PO receipt, PO return and PO invoice transactions against vendors/suppliers using purchase module. So in PO module, whenever user created the receipt from particular purchase order or returning some qty using purchase return screen, then Qty on hand or stock Qty got affected.… Read More: Add Pending Qty column in PO Receipt screen in Sage… »
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: How to Call an API Through POSTMAN Tool and Map… »
A sales invoice is an accounting document that records a business transaction. Sales invoices provide the business with a record of the services they’ve provided to a customer. When you post an invoice or credit note, the value of each invoice line posts to the nominal account specified for the item. But sometimes we get errors while posting sales invoices due… Read More: How To Solve ‘Non-Existent Account’ Error While Posting a Sales… »
In Sage X3, we may come across a situation where we need to prevent printing of a report and we can achieve this using code. Steps to follow : To prevent printing of a report we need to create a specific processing script for the report and put the following code in the file. The… Read More: How to prevent the printing of a report programmatically »
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: Customer or Supplier address deletion »
In Sage X3, using auto numbering feature we can generate document numbers for most of the transaction and masters like Purchase or Sales document numbers or Customer or Supplier numbers etc. But there is no provision to generate account code automatically so we did an add-on customization where Account code gets generated automatically on the… Read More: Generation of Account Code on the basis of Group, Sub-Group… »
At first, we will see, what is an Open PO Amount? After creating GRN/Receipt against Purchase Order, remaining amount of PO i.e. (Total PO Amount including Tax – Total Receipt/GRN Amount including tax) is the Open PO Amount. That means Open PO Amount will be calculated until that PO is open. If PO is closed,… Read More: How to get an Open PO Amount using inquiry screens… »
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: Calculating number of attachments in Sage X3 »
As we all know, generally after adding fields in screens, we globally validate window of that screen and we are able to see the new added field in that screen. But in inquiry screens, it is little different. In this we will see how we add new field in inquiry screen and how we can… Read More: How to solve if new field added in inquiry screen… »
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: The narration of function and its parameter used to call… »
