Category Archives: Sage ERP X3

Creation of Bar Charts and adding it to Dashboard

In industries Dashboard plays a very important role for users which provides summarized data of organizations, transactions and masters. Sage X3 has features to show dashboard data into graphical charts like bar chart, Pie chart, line chart & different types of chart. One of our clients has a requirement to represent the data on the… Read More »

Exporting Real Time – SEI Data Models Using Excel Add-In

We all understand and know the importance of analyzing the daily/archived business data (from all different working styles & scenarios e.g., Sales, Purchase, Delivery, Warehouse, Payroll, etc.) which just not only helps to understand the current situation & performance of your business, but also helps to gain great, useful & valuable insights so that one… Read More »

How to perform CRUD operations using classes and representations in Sage X3 V12

Introduction: Sage X3 provides various features with user friendly screens and their amazing functionalities. The screens can be of various types such object based, function action based, inquiry screens , etc. For performing create, read, update and delete operations on a table, we need to have a screen for entering those data but what if… Read More »

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 »

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 »

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 »

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 »

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 »