#### Howdy, Stranger!

It looks like you're new here. Sign in or register to get started.

Options

# Item Quantity and Remaining Quantity do not match

Member Posts: 358
edited 2014-05-04
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."

• Options
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.
• Options
Member Posts: 358
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."
• Options
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).
• Options
Member Posts: 358
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."
• Options
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.