I am trying to solve a problem my client is having but I am unable to do so until I know why the problem is occuring. My client is running Navision Attain 3.10A but I find I can replicate the problem with Navision Attain 3.7. How to replicate the “error” using a standard 3.7 database: Open the revaluation journal and click Functions | Calculate Inventory Value. I used item no 1100. The Revaluation Journal displayed a qty of 195 but the Item Card displayed 152. I investigated this further and discovered how the Revaluation Journal got its figure. Basically it looks at the lines in the Item Application Entry table (339). It filters out any lines where the “Output is adjusted” field is NOT checked, i.e false. In the example above, there are two lines that are false with a combined qty of 43. This is the difference I am looking for between 195 and 152. I also found out that you must run the Adjust Cost - Item Entries batch job first before running the Revaluation Journal. I did this in the hope that it would set the “Output is Adjusted” field to true for the two remaining records, but it did not. I ran it 3 times but this did not change anything. My question is this: When and how will the “Output Is Adjusted” field be set to true.I do not want to customise anything if there is no need. I would rather prefer to understand what Navision is doing and why. Can anyone shed some light on this subject? DavidT
Hi David I believe the issue you have is that transactions are not yet closed. In the Cronus example 1100 is still on a few produciton orders - once these have been fully reported - comsumption and output, and then finished the entry is flagged as fully invoiced, and then your valuation should work. This will also be the case if you are consuming an item in a bill of material but you have not yet received the purchase order for the item. I hope this helps