Once upon a time a customer using 3.6 had weird error messages regarding reservations and item tracking and it turned out the problem is that sometimes when you ship stock some "orphan" entries remain there. So I've written a batch job that deletes all entries of reservation and tracking type which either don't have a pair - another entry with the same number and the field Positive being different - or those that relate to nonexisting documents or journals. I think most of the cases it's a consumption journal - you post it but the reservation or order tracking stays there. As of now, we have to run this deleter batch job even at customers using versions as recent as 4.0 SP2 almost on a daily base. So it seems this problem hasn't been fixed in the last 3 years.
I wonder why don't I see much discussion about this problem here as if you don't develop a workaround like I did it makes using Navision almost impossible for a distribution or manufacturing company. So I wonder whether there is a more general solution to it or everybody was doing the same thing as me? Or is it fixed in SP3 and everybody upgraded?
Also - what do you think, should I remove Surplus entries relating to nonexisting documents as well? How does Navision calculate what's available from a given Lot - adding up the surplus entries or just looking at Item Ledger Entries? OK I could check this out but I have some other work to do and maybe some of you already investigated it, this is why I ask it.