Tag Archives: Sage X3 Technical blog

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 get notification if an user deletes a Sales order in Sage X3

In Sage X3, notifications are typically used to alert users about certain events or actions within the system. These notifications can be configured to appear in various parts of the system, such as the user’s dashboard, or they can be sent via email.Notifications in Sage X3 provide a flexible and configurable way to keep users… Read More »

Positive pay file generation functionality in Sage X3

Positive pay is a banking service designed to mitigate check fraud risks. Customers of the bank provide a file containing account numbers, check numbers, and corresponding dollar amounts for each check. If a check is presented for payment, but is not listed in this file, the bank will refrain from processing the payment and will… 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 »

Transport Note Feature In Sage X3

In some situations, companies need to transfer products from one place to another that are not part of the normal distribution flow. For example, shipping a computer that needs to be repaired or shipping marketing materials to a conference or tradeshow. The Transport Note feature in Sage X3 tracks goods that are shipped and/or delivered… Read More »

Automate sending reports on emails in Sage x3

Workflow in Sage X3 allows you to automate steps such as sending emails with attachments etc. Sage X3’s workflow function allows you to create a process that sends an email when certain conditions are met, such as fulfilling/satisfying the condition or triggering an event. This email may include attachments, such as documents or reports generated… Read More »

Carry-forward of commitments functionality in sage X3

Carrying forward commitments in Sage X3 typically refers to the process of transferring or rolling over outstanding commitments from one accounting period to the next. Commitments often represent planned or anticipated expenses that have not been realized or invoiced yet. The commitment carryforward feature transfers commitments associated with a sales order from the final period… Read More »

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 »

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 »