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 »
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 »
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 »
In Sage X3, we may come across a situation where we need to create query tool by adding fields from the table also while adding field we may get the below error as shown in fig 3. Step1 :- To create query tool Go To -> Set up -> Usage -> Reports -> Query tools.… Read More »