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.

Note: If a Warehouse/Item/[Lot] has no prior InventoryCount, then all transactions prior to the date of the balance are accumulated, with the starting balance assumed to be zero.

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