Category Archives: Integration

How to default Validity date to certain days from Date of creation for Sales Quote module

In Sage X3, Users can create Sales Quotes for keeping a track of which customer has placed their quotes for the products. When these quotes are created from the screen then the date of creation is defaulted to current date, there is another field in the Management tab of the screen called Validity date which… Read More »

Validation on Gross/Net Price and Qty fields in Sales/Purchase Invoice Transactions

As we all know, while creating any transaction in Sage X3, we can enter quantity and price manually in detail line as per the requirement. But one of our client wanted to restrict the creation of the Sales/Purchase Invoice Transactions if the user is trying to enter ‘0’ in Gross/Net Price and Quantity fields. Even… Read More »

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 »