Create Graphical Requestor in Sage Enterprise ManagementV9
If we want to see sales order details which are still open, then just go to the graphical requestor. Here we can directly add tables from Sage Enterprise Management data source by click on “Add table” option and fields can be selected.
The following steps are describing how to create graphical requestors in Sage Enterprise Management V9. Go to graphical requestor function under:
Setup à Usage à Reports à Graphical query tool
Click on new button and provide the new code and click on “Add table” option, here we can add formulas and function using coding part by click on “add new expression field” option as shown in following screen. Once selected it will list X3 tables. If required, we can change the relation (link). Sales order tables are given below.
If we want create link between tables manually, then we can add Link in expression field.
Sometime it is required to display data in graphical format, in this case we can select graph option in graph tab.
Once it is done in development then validate the requestor by click on validate button as shown below and click on Run button to execute.
Result in table and graphical format on same page has been shown below, as we selected Graph and Character option in Graph tab in creation part.
Latest posts by Panni (see all)
- How to Check Numberof Records in the Table in Sage Enterprise Management (Formerly Sage X3) - December 12, 2018
- How to fix Unauthorised Journal on Invoice type Error in Sage Enterprise Management (Formerly X3) - October 31, 2018
- How to Change Length of Data Type in Sage Enterprise Management (Formerly Sage X3) - October 17, 2018