Customisation on Subcontracting Order Type

In Sage X3, we can create a new transaction against the previous Purchase or Sales transaction. For Example, we can create Sales Delivery against Sales Order, Purchase Receipt against Purchaser Order, Sales Invoice against Delivery or Order and so on. Similarly, we can create Purchase Order against Work Order by following the standard process. But… Read More »

Error “Non-blocking difference“ Error format ZDEPCODE K:20B in Sage X3

In Sage X3, while importing data through one of the custom import templates we came across an error of “Non-blocking difference Error format ZDEPCODE K:20B” in the log: We’ll be referencing the following screen from Sage X3 for this: Import/Export template: All -> Setup/Parameters -> Usage -> Import/Export template (GESAOE) Refer the screenshots for reference:… Read More »

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 »