Category Archives: Miscellaneous Tables

Automatic Packaging configuration at Product Site level

When the packaging capacity isn’t configured at the site level and there are multiple products involved in Sales Order Packaging, the process of manually setting up automatic packaging for each product can be incredibly time-consuming. To streamline this and prevent the need for manual automatic packing at the packaging level, Sage X3 offers a feature… Read More »

Adding controls to fields in Sage X3

One more feature of Sage X3 that frequently gets overlooked is the capability of adding controls to a specific field within the system without requiring knowledge of the 4GL language, which is Sage X3’s exclusive coding language. After realizing that they were continuously using the control action to add custom logic to standard or custom… Read More »

How to add a field in data model designer in SEI

In this blog, we’ll explore the step-by-step process of creating data models, linking tables, adding fields. Once the tables have been added and linked, fields can be added to the Data Model. Click on the  to open the Fields. Right-click on the Field to access to these options: Fig. 1. Add column Note: Fields can… Read More »

What is License Plate Numbering in Sage X3

In logistics and supply chain management, internal containers refer to the various types of packaging or storage units used to transport and store goods within a facility or during transportation. These containers can include pallets, boxes, packs, big bags, barrels, bins, and others. Assigning unique identifiers, such as license plate numbers, to these internal containers… Read More »

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

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 Restrict Single Delivery Creation from Multiple Orders in Sage X3

Sage X3 offers functionality allowing the consolidation of multiple orders into a single delivery. If your business process requires limiting such entries to prevent confusion during invoice report printing, follow the steps below: While creating Order there exist an option of Invoicing Mode, with choices including 1/Order, 1/Shipment, and 1/Invoice. Choose the ‘1/Order’ option. Users… Read More »

How to Use Conditional Formatting in Sage X3

Introduction When you look at raw data, it can be hard to understand what it all means because it’s just a bunch of numbers or information. It’s difficult to see patterns or trends when the data is in this simple form. One tool that helps with visualizing data is called conditional formatting. This tool makes… Read More »

How to make use of Sage X3 dashboard to display data from other tables

Retrieving data from a single table for the Sage X3 dashboard is straightforward. However, if you require data from multiple tables or linked tables, attempting to add a field from those tables triggers an error message: “Standard Query ‘QUERY_CODE’: Links not possible.” In our recent blog post, we’ve provided a clear solution to address this… Read More »

How do I add a new report to a function?

In Sage X3, you can add a new report to a function on the different objects screen. When the standard reports are not sufficient, we use an existing report and customize it according to our requirements. We can also add the validations on report printing. For example, On the screen, the user wants to print… Read More »

HOW TO FILTER DATA ON DASHBOARD IN SAGE X3

In Sage X3, the term “Dashboard” typically refers to a user interface feature that visually represents the relevant data. These dashboards are customizable and can be tailored to suit the specific needs of users or departments within an organization. Sage X3 dashboards allow users to monitor various aspects of their business in real time, such… Read More »