Item Ledger Entries with corrupt data

afarr

Our client has some items where the total Quantity (of all Item Ledger Entries) is different from the total Remaining Quantity.

This means that the data got corrupted at some point, possibly due to "bugs in older cost adjustment routines", as suggested in this post:
http://www.mibuso.com/forum/viewtopic.php?t=22087

The Applies-to Entry field is 0 in all records (except one), which makes things more difficult.
Can the Item Ledger Entries still be corrected?

Any help is much appreciated. (Our client is using Nav 3.70 B.)

Alastair Farrugia

ara3n

I believe you can fix it. The first problem will be identifying what entries is wrong.
To do this, you have to write a report that will look at ILE and Item application and find the entry where qty applied qty is incorrect. you have do your own item application process to find entry.

cernst

There is a tool called costing error detection that detects differens errors in item ledger entries, item application etc. I'm not sure that this tool can be found on the partnersource or not. This tool is applicable on attain versions.