I’m bumping my head on the follwing problem in Navision 3.70b, native database.
Since last friday the Adjust Cost funcion loops on the entries of a specific item when it comes to the second level cycle.
Something similar had happened a few months ago, but then somebody had posted three shipping documents with a posting date far in the future, then had run the cost adjustment which had spread the funny date every where. Once I managed to correct all the dates on all the affected entries the problem had deasppaered.
Now doesn’t seem to be the case. Not only there are neither wrong posting dates nor other strange entries related to that item, but I’ve rescued a backup previous to the day that the problem has occurred first and restored into a new database and run the cost adjustment. The codeunit doesn’t loop, but if I try to compare the entries of the item where the loop occurs I can’t any difference. Nothing new has been posted since July 7 for the offending item!
So far, I’ve compared entries from tables 32, 337, 339, 5802. Which else might I check?
Some more infos - the item costing method is average (they do evaluate everything with the average method in this company - which is the first cause of my headaches! [:@] ); the item ledger entry types are all outputs and sales but for a single positive adjustment posted in May. There are a couple of reversed shipping documents, but they are also old things. [:(]
Might be the cause of the loop be from a different entry than the ones that can be seen on the dialog window while loop occurs?
Anybody did experience anything similar?
BTW - I should install and migrate to version 4.02 next week, but the financial users need to perform a financial statement at July 31 before the system can be stopped. [:’(]