Category Archives: Integration

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 »

How to disable the Tax3 field of Sales Order screen if the customer is not TCS Applicable

There was a requirement from the user to add a check box on Customer master as “TCS Applicable” and “Tax Level 3” field of detail line on the Sales Order screen should be activated only when the “TCS Applicable” check box for any customer is ticked, otherwise it should be disabled. To achieve the above… Read More »

How to solve error “Non – blocking difference Incorrect date ACCDAT 20210210” while importing data through template

In Sage X3, We can import data to the table through an Import/Export template feature. Here we can create Import/Export template with table fields which we have to update or enter in the table and import the text file which contain data and after successfully import of text file, table get affected. Through Import/Export template… Read More »

Supplier Invoice Date validation on Purchase Invoice screen

As we all know in Purchase Invoice screen, Supplier Invoice Date field is mandatory. In Sage X3, while creating Purchase Invoice transaction, it displays current date by default in the Supplier Invoice Date as well as in the Accounting date fields. But one of our client requested to add a validation for the dates where,… Read More »