How to get an Open PO Amount using inquiry screens in Sage X3

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… »

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: Calculating number of attachments in Sage X3 »

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: How to solve if new field added in inquiry screen… »

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: The narration of function and its parameter used to call… »

How to delete Purchase Invoice in SageX3

Introduction: A Purchase Invoice is a bill which we receive from Suppliers against which we need to make the payment. In Sage X3, we may find difficulty on deleting Purchase Invoice which are already posted and not posted. There is a functionality in Sage X3 with which we can delete purchase invoice. Navigate to: Purchasing… Read More: How to delete Purchase Invoice in SageX3 »

How to control payment sign (Expenditure or Revenue)

In sage X3, under Payment entry type we can define characteristics and the methods for different payment transactions. We can also control the sign of payment to be Revenue, expense or we can keep it as unspecified and differentiate that value based on our payment entry. Path: All>Setup>A/P-A/R accounting>Payment entry type Also in payment attribute,… Read More: How to control payment sign (Expenditure or Revenue) »