Category Archives: Miscellaneous Tables

License Plate Numbers in Sage X3

Step1. How to create and set up the various license plate numbers? Sequence number creation Open: Setup > General parameters > Sequence number definition > Structures Before creating the license plate number, you must create a sequence number. This sequence number can include up to 18 characters. Fig 1. Sequence Number Link the Sequence code… Read More »

How can we add new fields to the Inquiries screen without using standard lecture code

In Sage X3, the inquiries screen refers to a user interface where users can view and analyze data stored in the system. This screen typically provides a way for users to query and retrieve information about various aspects of the business, such as sales orders, purchase orders, inventory levels, customer information, supplier information, and financial… Read More »

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 »