Category Archives: Sage ERP X3

Restriction when Requirement quantity is not equal to Quantity tracked

In Sage X3, Recently we had a requirement from one of our client, Requirement Quantity on the work order screen should be equal to the “Quantity tracked” on the production tracking screen then only the system will allow the user to create the Production tracking or else it will generate a pop-up and will restrict… Read More: Restriction when Requirement quantity is not equal to Quantity tracked »

Excise Module in Sage X3

With Sage X3, get your Alcohol & Distilleries manufacturing business “up and running” without running around! “State-Wise Excise Duty applied on the Products, other required charges applied on the Products, Management of bottle quantity per case, VAT, CST, TCS management”. Get it all here. Because to manage alcohol & distillery needs, we did a customization… Read More: Excise Module in Sage X3 »

OLAP Manager in Sage Enterprise Intelligence (SEI)

On-Line Analytical Processing (OLAP) is a kind of software that allows users to access and analyse business data stored in several, and sometimes extremely large, data bases. The definition and setup of OLAP data are multidimensional, which means the information may be compared in a variety of ways. Data cubes and data warehousing are two… Read More: OLAP Manager in Sage Enterprise Intelligence (SEI) »

Triggering windows and passing data from main window in Sage X3

In Sage X3, sometimes it requires us to link a pop-window from a button and display information based on a particular record. To achieve this requirement, let us take you through a simple and effective process provided by Sage X3 as shown: We’ll be referencing the following screen from Sage X3 for this: Product Master:… Read More: Triggering windows and passing data from main window in Sage… »

Workflow Monitor allows any user to sign for Approval

In Sage X3, we recently faced an issue where in all of our signature workflows, any user could accept other users’ approval from the workflow monitor even though they are not assigned any level and they are not the approval. To solve this issue we have 2 options as mentioned below. Option 1:Access to the… Read More: Workflow Monitor allows any user to sign for Approval »

How to create single Purchase Suggestion with multiple Sales Orders in Sage X3

MRP (Material requirements planning) is a production planning, scheduling and inventory control system used to manage manufacturing processes. We may follow below steps to make Purchase Suggestions in Sage X3. MRP setup on Product. Sales Order. MRP Processing. Enterprise planning. Step1: MRP setup on products: Navigate to : Common Data -> Products -> product site… Read More: How to create single Purchase Suggestion with multiple Sales Orders… »

TCS18 and NTC18 Taxes – set to update automatically at Lines

In Sage X3, we apply taxes in the Lines tab for products in Tax 1 and Tax 2 fields manually on the basis of the Tax Rule selected in the Management Tab. And if we want to apply TCS then in Tax 3 field, we can enter TCS tax code. But one of our client… Read More: TCS18 and NTC18 Taxes – set to update automatically at… »

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 as… Read More: Customisation on Subcontracting Order Type »

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: Error “Non-blocking difference“ Error format ZDEPCODE K:20B in Sage X3 »