Category Archives: Sage X3

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 »

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 »

Templates in Sage Enterprise Intelligence

Sage Enterprise Intelligence is an intuitive business intelligence solution integrated with the Sage business management system that helps business users spend less time analyzing and reporting, making faster, more informed decisions. It provides all users with a simple solution for self-sufficient access and analysis of data, eliminating the need for disparate tools and expertise and… 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 »

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 »

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 »