Inventory Quantity and Value Balances Report output
After you generate an Inventory Quantity and Value Balances report, you will receive an email with an attached report output in PDF file. Infor Localization Services Platform generates records based on selected parameters.
The report output shows this Header information:
Field name | Field description |
---|---|
Title of the Report | Inventory Quantity and Value Balances Report |
Accounting Entity | Selected subscription from the Homepage |
Date and Time of the Report | Date and time when report was generated |
User ID | ID of the user logged in Infor Localization Services Platform |
Data Selections | Information filtered according to selected parameters |
The opening balance for any date is calculated by accessing the latest InventoryCount records prior to that date. The count quantity is then adjusted by these transactions by all of the related transactions that follow that count, which should have the same CountSequence as the InventoryCount or a subsequent one, and that are dated prior to the date of the opening balance.
After establishing the opening balance, the subsequent transactions quantities are applied at the Warehouse/Item/[Lot] level to determine the closing balance and may be reported.
To meet the requirements of multiple countries, these report formats and sequencing should be prepared:
By Warehouse
The By Warehouse sequencing has these formats:
- Warehouse / Item Group / Item / Lot, if Item Groups option is selected
- Warehouse / Item / Lot
By Item
The By Item sequencing has these formats:
- Item Group / Item / Warehouse/ Lot, if Item Groups option is selected
- Item / Warehouse / Lot