Category Archives: Sage ERP X3

Restriction on Duplicate LOT-SUBLOT creation

As everyone knows, LOT No creation for the raw materials can be done in Purchase Receipt and Miscellaneous Receipt transactions in Sage X3. In LOT No field, LOT will be generated either automatically or manually. User can enter LOT No manually. Logically, LOT No should be unique for every Product as per the LOT-SUBLOT concept.… Read More »

Using Miscellaneous Tables in Sage X3 ERP

Sage X3 has provided the developers with an extensive feature called as Miscellaneous Tables. Miscellaneous Tables are logical tables to store codes/ List of Values for e.g. Rules, Terms, Payment Methods, etc., it comes handy whenever we need to provide users with options/ dropdowns to have strict data integrity. There are 2 types of the… Read More »

Work Order REL unit update customization in Sage X3

In Sage X3, one of the client’s requirements was to have a way to quickly convert their work order REL unit (release product unit) from stocking to packing unit for the header product. To provide them with a business solution for the above requirement we developed a new screen and a button on the Work… Read More »

Sage X3 Dashboard: Sales by Product Category

In industries, Dashboard plays a very important role for users which provides summarized data of organizations, transactions, and masters. Likewise, we received a requirement to create a dashboard that provides sales amounts by product category. For that requirement, we were requested to display the top 10 greater amounts of sales by category, and then at… Read More »

Loading Chart customization in Sage X3

In Sage X3, one of the client’s requirements was to have a screen that’ll be used for the purpose of tracking Sales Invoice contents based on QR code label before the final process of Loading the goods in delivery transports, hence we’ve given it the name Loading Chart.Furthermore, the customization provides a business solution in… Read More »

Valuation price null not authorized

In Sage X3, we recently faced an issue while processing a purchase order/Miscellaneous Receipt, “Valuation price null not authorized” which prevented the user from creating a purchase order. On debugging we found that this message can occur when the Valuation method found in the Common data->Products-> Product-site-> Cost is Standard cost, but it does not… Read More »