Scenario
The Overall Average Cost in the Item Record (Purchasing/Inventory Tab > Item/Cost Detail Section) which is Total Average Cost across all locations is not the same with the available Average Cost Fields in the Current Inventory Snapshot report.
Solution
The main purpose of the Current Inventory Snapshot report is to provide a snapshot of real-time inventory data and to monitor inventory levels and determine ordering schedules on a per location basis.
There are two (2) Average Cost Fields that can be shown in the Current Inventory Snapshot report once it is customized. They are located under the Inventory Item Folder and Quantity on Hand Folder in the Customized Edit View of the report.
Average Cost Field under the Inventory Item Folder - pertains to the Location Average Cost (Total Inventory Value / Qty on Hand (Base units)) of the Preferred Location set in the Item Record.
Average Cost Field under the Quantity To Order Folder - pertains to the Location Average Cost (Total Inventory Value / Qty on Hand (Base units)) in the Location in the Column.
The field Average Cost for the whole inventory (not on a per location basis) is not yet available as additional field in Current Inventory Snapshot report.