Inventory Valuation report showing the valuation by Lot Number

Customize the Inventory Valuation report and add a column to show the valuation per lot number, but don’t see this column available. Answer: The reason why you aren’t seeing any column to show the valuation per lot number is because it is a current system limitation, thus a standard behavior in the system. This is… Continue reading Inventory Valuation report showing the valuation by Lot Number

Average Cost is Zero in Inventory Valuation Report

When Multi-Location Inventory (MLI) feature is enabled, the Average Cost is displayed only for the item’s preferred location. If there is no preferred location defined for an item, the average cost and last purchase price displayed on the report is blank or zero. It is currently the enhancement (Enhancement 156866) As an alternate solution, you may set a Preferred Location on the… Continue reading Average Cost is Zero in Inventory Valuation Report