Add Pending Qty column in PO Receipt screen in Sage X3

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 »

How to Call an API Through POSTMAN Tool and Map With X3 Fields

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 Solve ‘Non-Existent Account’ Error While Posting a Sales Invoice

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 »

Calculating number of attachments in Sage X3

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 »

How to solve if new field added in inquiry screen and still not visible after global validation of window.

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 »

The narration of function and its parameter used to call an external/outgoing REST web service from ASYRRESTCLI library

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 »