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.
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 item table header setup
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
Receipt Query	Shows all purchase receipt lines and indicates whether the receipts are valid to an existing agreement 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 Group Query	Shows the different agreement groups setup
Supplier Rebate Agreement Type Query	Shows the different agreement types setup
Supplier Rebate Agreement Query	Shows supplier rebate agreement records
Supplier Rebate Calendar Days	Shows each date of the year and its corresponding period number which is generated based on the periods defined in the M3 Financial Calendar
Supplier Table Query	Shows supplier table header setup
Unit of Measure Query	Shows the different unit of measure setup
Warehouse Query	Shows warehouse master data
Warehouse Table Query	Shows warehouse table header setup