Category Archives: Tips

Pegging history in Sage X3

The “Pegging History” tool allows the history elements to be shown both upstream (what does the order cover?) and downstream (what covers the order?) from a “pivotal” order. In the second grid, under the multi-level option, the list of coverages is suggested if the selected “pivot” is of the required type. The “Pegging History” functionality… Read More »

How to update the fields in the signature history table for a custom workflow.

In Sage X3, workflows are used to automate and streamline business processes by defining a sequence of tasks that need to be performed in a specific order. These tasks can involve approvals, reviews, or other actions necessary for the completion of a business process. Workflows in Sage X3 help organizations enforce consistency, reduce manual intervention,… Read More »

How to flow dimension in Work Order’s GL/journal entry in Sage X3

In Sage X3,dimension types are analysis codes that can be used to track costs, revenue, and quantities. In various case, user wants to flow the dimension data to the SI/PI/WO transactions and its GL entries. So, to achieve this setup and functionality. Kindly follow below steps. Below is the setup and working of the GL… Read More »

Importance of X3 Installation and how to solve error if encountered on Folder Validation 

The Installation of Sage x3 ERP system involves several steps to ensure a smooth and successful implementation.   Which has multiple important steps that are, Implement a regular maintenance schedule to ensure the Sage X3 system remains up-to-date and secure. Stay informed about software updates and implement them as necessary. Remember that Sage X3 Installations… Read More »

Creation of Shipping Calendar to display on dashboard

To create a Shipping calendar we will use X3 calendar functionality.The shipping calendar will help us with delivery tracking. Specially it will be helpful for sales and warehouse teams. For creation of “Shipping calendar” we are going to use SORDER and BPCARRIER table’s. Step 1: Go to Setup>Usage>Reports>Graphical query tool. Create new query Fig: Graphical… Read More »

How to export flat files in Sage X3

Introduction: Sage X3 provides the functionality of creating\updating the transactions using an Import/Export template. We can use import/export templates quite often for importing huge data with ease. We need to setup some parameters in order to export data in a particular format. We came across a scenario where users need to export data in a flat… Read More »

How to perform automatic and multiple assignments using the assignments function

In Sage X3, assignment rules are used to define how transactions, such as sales orders or purchase orders, are automatically assigned to specific resources or entities. These rules are part of the Resource Planning module, which helps in optimizing resource utilization and improving efficiency in managing various business processes.Assigning orders (needs and resources) among one… Read More »

How to restrict the data for specific user or group in SEI

This is a process that involves setting up permissions and access controls within the Sage Enterprise Intelligence software. This process ensures that each user or group of users can only access the data that is relevant to their roles or tasks. It involves various steps such as granting or restricting access to reports, limiting access… Read More »

Allocation Methods for Efficient Work Order Management

In Sage X3, a work order is a document that is used to plan and track the production of items in a manufacturing or production environment. Work orders are an essential part of the manufacturing process that can be the “Manual,” “Global,” and “Detailed” allocation methods are options you can choose when allocating materials to… Read More »