Category Archives: Integration

Supplier Invoice Number validation on Purchase Invoice Screen

In Sage X3, Supplier Document Number Field is available on purchase invoice screen in management tab. It is a mandatory field which means while creating entry we can’t skip this field. We have to enter data in this field then only we can proceed further. We had a requirement from client that data entered in… Read More »

Data flow from Payment screen to Journal entry on Posting using Automatic Journal

In Sage X3, Users can create Payments based on Purchase invoices and can see specific data being flowed from invoice screens to the respective payment screens. But what if the user wants specific data to be flowed from Payment to the Journal entry during posting of the payment. In this blog, we’ll see how to… Read More »

PO Quantity Validation on Order Pre-receipt screen

In Sage X3, Order pre-receipt transaction is made before we received the goods and make the GRN. During Order Pre-Receipt transaction, user select the respective Purchase Order number from the left list and data gets populated in the lines tab with the Order number and their respective details on the screen. Recently, we got the… Read More »

How to get total transaction amount of supplier for current fiscal year

In Sage X3, only posted transactions will be considered for accounting effects. Here in this blog we had a requirment from a client that , there should be a field on the header of purchase invoice screen, in which total transaction amount of the Supplier should be displayed for current fiscal year according to the… Read More »

Validation on Purchase Invoice screen

As we know in Purchase Invoice screen, Supplier Document No and Supplier Invoice Date fields are mandatory. In Sage X3, while creating Purchase Invoice transaction, user can enter same No and Date for different invoice numbers. But one of our client requested to add a validation for the Purchase Invoice where, if the Supplier, Supplier Invoice… Read More »

How to enable “Accounting Cancellation” option on Purchase Invoice Screen

As per the standard functionality of Sage X3, Accounting Document (Journal) will be created immediately once the invoice is posted and “Accounting Cancellation” button automatically gets enabled. And any user can click on this button and reverse the posted invoice transaction. But sometimes, that accounting cancellation option remains disable even after posting the invoice. As… Read More »

Quarantine Label in Sage X3

Labeling is one of the influential parts of the packaging of the product. The label includes the information of inventory/product and which helps the customer to communicate with the company and greatest advantage identify the product and provide necessary information for the same. There are different kinds of labels such as Rejection, Approved, etc. which… Read More »