Tag Archives: Sage X3 Functional Blog

Multi-Company Period Opening(TRTPERMC)

Do you resent the opening periods for each and every organization when the new year begins? Do you avoid opening for only one month at a time due to the work required? If you have many companies, it can be tiresome and time-consuming. Do you want a faster way to open periods? To tackle this… Read More »

How to Setup Up User Security for Sales Order and Pick Tickets

To prevent the customer care agent from creating a pick ticket from the sales order screen, follow these instructions to set up your functional profile for them.A button that displays the order’s life is located in the right upper panel of the sales order screen. These are known as validation links or buttons. Fig 1:… 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 »

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 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 to ship the product again after creating the customer return in Sage X3

This function is used to record the customer returns following a delivery or a supplier return in the case of inter-site or inter-company transfers. Once the return is carried out, the stock will be moved if necessary and it will be possible to print a return note and if required to enter a credit memo… Read More »