Inventory Valuation by location

mturner
mturner Member Posts: 8
edited 2007-03-14 in NAV/Navision Classic Client
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??

Answers

  • muksha
    muksha Member Posts: 274
    To avoid this you have to run the adjust cost item entries batch job on at least daily basis.
    Mukesh Sharma
  • ssingla
    ssingla Member Posts: 2,973
    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.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • nunomaia
    nunomaia Member Posts: 1,153
    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.
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • nunomaia
    nunomaia Member Posts: 1,153
    There are several topics about that issue, search this forum :-)
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/

Categories