Viewing Material Transaction Distributions
View inventory accounting distributions. View account, currency, location, and transaction type information for transactions performed within a date range.
To view inventory transaction distributions:
2. Enter search criteria in the Find Material Transaction Distributions window to find inventory transactions.
The Material Transactions Distributions window displays transaction dates and five alternative regions: Account, Location, Type, Currency, and Comments.
Account: Displays the account, transaction value, item, revision, and the accounting type.
Location: Displays the subinventory, locator, operation sequence, and transaction ID.
Type: Displays the transaction type (such as miscellaneous issue, sales order issue, or cycle count adjustment), source type (the origin of the inventory transaction), source (such as account number), the UOM, and the primary quantity (in the item's primary UOM).
Currency: Displays currency, the transaction value (for foreign currency), and displays the conversion (exchange) rate, type (such as Spot, Corporate, or User Defined), and exchange rate date.
Comments: Displays transaction reason, transaction reference, and the general ledger batch ID (if transferred to the general ledger).
Using Query Find
Using Query Operators
Searching For Information
Performing Query-by-Example and Query Count