Acquisitions order entity
Find information about the Acquisitions order entity in Amlib OpenReports.
Orders by supplier
- Access the Report Designer TAB
- Select New from the buttons
- The Edit Report Window will display
- Enter a Report Title in the Report Title section. For the sample “Orders by Supplier”
- Enter a Group since we want to find it later easily – for example Acquisitions
- Enter a Sub Group – for example Orders
- Choose Report Type from the Drop-down options (Table is default):
- Table – set out in rows and columns (select for the sample)
- Select Orientation
- Landscape (select for the sample)
- Ignore Show sql
- Show details: For this sample Report enter
- All: Enter the Top value required – for example 10
- Show Sub totals: Have this ticked if subtotals are required
- Show total: Have this ticked if main totals are required
- Tick Private: leave this unticked.
- Show header on first page: For our sample tick this one if required
- Show header on next pages: This is your choice. But for now leave this unticked
Display Fields
- Select the Acquisitions Orders Entity
- Select required Data Field/s from the Entity and drag and drop to Display – in our sample, we included Order Number, Order Header Summary, Order Header Status and Order Header Local Cost. It depends on which Data Fields are to be displayed
- It is possible to change the Money fields for Order Header Local Cost. to show as Dollars By changing the Format to $ <space>0.00 ($ 0.00). Ensure that the Function is set to Sum if using Subtotals and Totals. We also changed the Header to just Cost
Group Fields
We selected Supplier as the Group Field to add the Totals for each Order Header by Supplier
Filter
Drag and drop Supplier to the Filters Column. To get All Suppliers it is possible to leave the Filter blank or Choose Supplier not empty. It is also possible to add an Order Date Placed to get Orders placed in a Date range or just the most recent Orders
Order
It is useful to have an Order and often depends what the Group – for example Supplier, Order Number
Preview
Select Preview to view the Report
It is also possible to get Order Line details for several or one Order Number