Tag Archives: Query tool

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 »

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 »

HOW TO MATCH OPEN ITEMS IN SAGE X3

Sage X3 uses an automatic matching process when posting open items which are applied to other open items. For example a payment made for some invoices is posted. During this posting process the details are loaded into a temporary table called MTCBATCH. Within this table the documents are matched together, open item entries are marked… Read More »

How to perform file Import/Export function using Batch Processing

Batch processing is a method of queued up transaction executed without manual intervention on the regular interval. The batch server is a background process that launches programs or system commands. A queue of tasks is processed by the server, executing and logging the results of each task. we come across the scenario where file based import… Read More »