Inventory value per location when Costing Method is Average

Melissa

Hi All,
I'm NAV beginner and need your help
Now I use NAV2009 R2 and look for the way how to see the inventory value per location when the setting of Costing Method is "Average".
Could you give me any help?

Alex_Chow

Inventory Valuation. You can break it down by Location Code.

Make sure your Average Cost Calc. Type field on the Inventory Setup is set to Item & Location & Variant.

Melissa

Thanks you Alex :P !
It seems good, but I want to see the list of inventory value per location.
Is there any good idea?

Alex_Chow

You can also put a filter on the Location Filter on the report.

You can also create a new report to display the inventory by location. In the classic client, it was easy enough, but not sure about the reporting environment in 2013...

You can also play with the Inventory to G/L Reconciliation page (5845). This will give you a faster glimpse of your inventory value filtered by location.

Melissa

Hi Alex
I decided to create new report and thank you for your nice advice.