Description:
In Reports Manager/Real-Time Reports, the Inventory Reconcile Summary Report and Inventory Reconcile Detail Report do not identify whether reported on-hand and allocated quantities are displayed at the Unit Issue (UI) level or the Stocking Unit Issue (Stocking UI) level. Because UI and Stocking UI may differ, users cannot reliably interpret reported quantities, which can result in significant variances in total on-hand and allocated inventory.
Additionally, the reports do not display the associated inventory value, limiting users’ ability to assess the financial impact of the reported inventory balances.
Recommended:
Enhance the Inventory Reconcile Summary Report and Inventory Reconcile Detail Report in Reports Manager/Real-Time Reports to clearly identify the unit-of-measure being reported for all reported on-hand and allocated quantities. At a minimum, each report should display whether quantities are reported in Unit Issue (UI) or Stocking Unit Issue (Stocking UI), including the applicable conversion factor when the two units differ.
Additionally, add inventory value fields (whether it be Unit Price or Stocking Unit Price) that display the extended value of on-hand and allocated inventory using the applicable unit cost and the reported unit-of-measure basis. The reports should provide clear labels for quantity, unit of issue/stocking unit of issue, unit cost, and extended inventory value to ensure users can accurately reconcile balances, understand quantity variances, and assess the associated financial impact.
Benefits:
Users that are utilizing these reports will be able to distinctly identify quantity of on hand inventory and it's value.
Frequency:
Daily
Users:
N/A
Disclaimer | Accessibility