Tag Archives: Sage X3 Technical blog

Identifying Your Customer in Sage X3

Customer relation  in business includes various factors to streamline the process including business partner details. And to achieve this various details about customer business and their various location and company sites , contact details, description etc. Thankfully the Sage X3 has a new function involved  under customer relations named Identify. To navigate to this screen… Read More »

How to Add a Hyperlink in Sage Enterprise Intelligence (SEI)

In this tutorial, we’ll walk through the step-by-step process of creating a hyperlink from a database in Sage Enterprise Intelligence (SEI). Steps: 1. Prepare the URL Link in Your Database Tables: Ensure that your database tables contain the necessary URL links that you want to use as hyperlinks. Fig. 1.Database Tables 2. Create a Data… Read More »

How to automatically adjust shortages of outstanding sales order with recording of stock receipts

In order to make sure effective stock allocation and order fulfillment, integrating inventory management with sales order processing in Sage X3 is necessary for automating the adjustment of shortages in outstanding sales orders. In order to manage supply shortages more efficiently overall, you can eliminate errors, cut down on manual intervention, and set up automated… Read More »

How to change the status of multiple work orders at once.

In Sage X3, a work order is a document that details the production activities required to manufacture a specific quantity of a product or item. It serves as a set of instructions for the production team, outlining the necessary tasks, resources, and timelines to complete the manufacturing process. After running MRP and checking Enterprise planning,… Read More »

Feature: Use of Supersession/Substitution product field on Product master in Sage X3

Introduction: As we know, business processes like sales, manufacturing, and logistics, require a functionality where you can substitute one product with another. In Sage X3, there is a concept of supersession product or substitute product. The name substitute refers to a product or service that consumers see as essentially the same or similar-enough to another product.… 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 grant access to the Data Models in SEI

In this blog, we’ll explore the step-by-step process to grant access to the data model in sage enterprise intelligence (SEI). This option is used to grant access to the Data Models, to groups or users. There are three different ways of adding authorization to a Data Model and you can toggle from one to the… Read More »

Dashboard Filtering in Sage Enterprise Intelligence(SEI)

One of the most valuable features within SEI is dashboard filtering, a dynamic function that allows users to customize their data views to meet specific analytical needs. Dashboard filtering in SEI for SAGE X3 provides users with the flexibility to focus on the most relevant data, thereby transforming vast datasets into actionable insights. Whether you… 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 »

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 »