Item Quantity and Remaining Quantity do not match

slmaluwa

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

JMA

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

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?

SiSt

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).

slmaluwa

We used a SQL query to calculate as there are millions of records in ILE.

bbrown

You can also validate the "remaining qty" value via table 339 "Item Application Entry".