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 »
If you need to retrieve data based on a more complex query than just selecting the field from a single table, you will need this feature. The SQL Query can be as much complicated as the database provider can support. This means that you could join tables, do summarization and grouping without any issues. Follow… Read More »
We have come across the situation, where we design Requestor and then we also want to add the levels to Requestor. Sage X3 has a special in-built feature to add levels in requester. New Stuff: How to determine if a mask variable can be entered or displayed? Follow the below instructions to add levels to… Read More »