Item Quantity and Remaining Quantity do not match

slmaluwa
slmaluwa Member Posts: 366
edited 2014-05-04 in NAV/Navision Classic Client
We have an installation which 6 or 7 years old (that much data). On random check on Item Ledger Entry table, we find few items Sum of Quantity and Sum of Remaining Quantity per location DO NOT match.
I am asked to find a list of mismatched transactions. I know the list of items to check and the location.

How can I run a trace (which transaction applied to which?) inventory movement of an item?

TIA
"A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."

Comments

  • JMA
    JMA Member Posts: 10
    In most cases you don't need to run such a trace. Just check all the Item Ledger Entries for your item list and compare, if there are entries with Open=False, but "Remaining Quantity" <> 0. The latter should be set to 0 then. Also the reverse check for Open=True and "Remaining Quantity" = 0 can be a hint, but then you have to check the menu item "Applied Entries" for such an entry to gain further information.
  • slmaluwa
    slmaluwa Member Posts: 366
    I found only 3 lines for the first case (Remaining Qty <> 0 and Open = FALSE).
    and non for Qty - 0 and Open=TRUE
    Is it safe to make it 0 for the first case ?

    Strangely, these three items are were not in the list of items with SUM(Quantity) and SUM(Remaining Qty) not matching list. Now, i am confused and desperately need a way to find what has gone wrong?
    Will Item Application Entry table be of an help here?
    "A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."
  • SiSt
    SiSt Member Posts: 46
    How do you have calculated the sum of the Quantity and Remaining Quantity?
    If you used the CALCSUMS funtion of NAV try to calculate the sum by using an SQL statement or a simple REPEAT ... UNTIL NEXT loop.
    If you get different results via CALCSUMS and one of the other methods there is a problem with the SIFT index and you'll have to recreate the keys (and correct the data manually).
    Simon Stoye
    http://www.sist.biz/en/ [en] | http://www.sist.biz [de]
  • slmaluwa
    slmaluwa Member Posts: 366
    We used a SQL query to calculate as there are millions of records in ILE.
    "A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."
  • bbrown
    bbrown Member Posts: 3,268
    You can also validate the "remaining qty" value via table 339 "Item Application Entry".
    There are no bugs - only undocumented features.

Categories