Inventory Valuation by location

mturner

NAV 4 SP3 - Using Average Costing

When running the inventory valuation without location filter, then all items are correct. When running the inventory valuation by location, some items have zero qty, but have a value.

The problem occurs when a transfer was made from one location to another when transferring all stock. It transfer the stock at the current ave cost value, but the stock in the location have a different value as the average and therefore a value remain in the location, but no stock.

Any suggestions how to fix this??

muksha

To avoid this you have to run the adjust cost item entries batch job on at least daily basis.

ssingla

In case of costing type as Average with multiple locations the Average Cost Calc. Type should be Item & Location & Variant in the Inventory setup. Check it.

nunomaia

When you have multiple locations and costing by Item & Location & Variant you must be careful.

When you have several locations, making locations transfers/returns can lead to open item ledger entries. Check for open item ledger entries and with jounral applies item ledger entries correctly. After that you should have correct valuation.

nunomaia

There are several topics about that issue, search this forum :-)