NAV / BC - Inventory Valuation Report shows value when stock is zero

• There are two solutions.
• Solution 1
• Change average cost calculation in inventory setup to Item,Location,Variant 
• However, this will start tracking separate costs per location
• Solution 2
• https://www.navug.com/communities/community-home/digestviewer/viewthread?GroupId=49&MID=1095
• 1) Bring the inventory to zero. Physical inventory journal works well. (Lets say your using Jan 1, 2014 for your posting date)
• 2) Run the adjust cost.
• 3) Run inventory valuation.
• 4) Add 1 of your item back into stock at the opposite amount of what your inventory valuation is. If you have -0.05 as your inventory valuation make sure you add one at 0.05. Make sure your posting date is one day offset from your physical inventory date. (Use Jan 2, 2014 for your posting date).
• 5) Run the adjust cost routine and inventory valuation report.
• 6) You should have 1 in stock at 0 dollars.
• 7) Adjust your inventory out again on a different date (Use Jan 3, 2014) with a cost of zero.
• 8) Run adjust cost and inventory valuation. You should have zero on hand and zero dollar value.
• 9) Adjust your inventory back into the system at the correct quantity and dollar value. Once again use a different date. (Jan 4, 2014)
• You have to be very careful with the dates. If any transactions are posted for the items you are adjusting inside the date period you are using you will have to run this entire routine again.