Inventory Turnover report output
After you generate an Inventory Turnover 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 Turnover Report |
Organization | 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 |
You can use this report to print the opening or closing balances and transaction details of the movements for the selected dates. It can be in detail or summary format.
The current 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 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:
GL Account Report
This report is sequenced by GL Account and has this format:
GL Account / TransDateTime
Item Reports
Item reports has these sequences and formats:
- Sequenced By Warehouse (Summary and Detail)
- WH / Item Group / Item / TransDateTime, if Item Groups is selected
- WH / Item / TransDate
- Not Sequenced By Warehouse (Summary and Detail)
- Item Group / Item / TransDateTime, if Item Groups is selected
- Item / TransDate