Forms

You can use a query form to display specific information in the application.

Name	Description
Accruals Query	Shows a list of accruals according to agreement number or purchase order number
Agreement Change Log Query	Shows the modify, add, and delete actions done in the agreement tables and secondary tables used by agreements
Agreement Group Query	Shows the different agreement groups setup
Agreement Line Query	Shows the different agreement line setup
Agreement Type Query	Shows the different agreement types setup
Claim Transaction Query	Shows claim transaction records according to agreement number
Claim Type Query	Shows the different claim types setup
Currency Rate Query	Shows currency exchange rates according to exchange rate type
Debit Note Header Query	Shows debit note records according to debit note number
Division Query	Shows the different accounting entity setup according to divisions
Field Selection Priority Query	Shows field selection criteria with priority setup according to agreement number
Financial Calendar Query	Shows the M3 Calendar periods setup for each year
Item Alternate UM Query	Shows all the alternate unit of measure associated to an item.
Item Location Query	Shows the division-specific data of an item.
Item Master Query	Shows item master data
Item Table Query	Shows multiple items that are grouped using a custom table
Non-Accruing PO Receipts	Shows a list of PO receipts records which do not accrue under any agreement
Non-Accruing Purchase Orders	Shows a list of PO records which do not accrue under any agreement
Number Series Query	Shows the different number series types setup
Payment Method Query	Shows the different payment methods setup
Payment Term Query	Shows the different payment terms setup
Purchase Order Line Query	Shows a list of purchase order lines and the agreement under which it has accrued
Purchase Order Type Query	Shows a list of purchase order types
Purchase Order Type Table Query	Shows multiple purchase order types that are grouped using a custom table
Receipt Query	Shows all purchase receipt lines and indicates whether the receipts are valid to an existing agreement or not. A status also shows if the receipt has been deleted or not.
Scale Query	Shows the different scale setups
Supplier Master Query	Shows supplier master data according to supplier number or name
Supplier Rebate Agreement Query	Shows supplier rebate agreement records
Supplier Rebate Calendar Days Query	Shows each date of the year and its corresponding period number which is generated based on defined periods.
Supplier Table Query	Shows multiple suppliers grouped using a custom table
Unit of Measure Query	Shows the different unit of measure setup
Warehouse Query	Shows warehouse master data
Warehouse Table Query	Shows multiple warehouses that are grouped using a custom table