We are using Navision 3.70 (SG version) without hotfixes. The Inventory Valuation - WIP report seems to be giving strange figures under the second column from the right (As of xx/xx/xx). I checked the code and noticed the following for the DataItem Value Entry:
Value Entry - OnPostDataItem()
IF ValueOfWIP + ValueOfMatConsump + ValueOfCap <> -ValueOfOutput THEN BEGIN
ValueOfWIP := ValueOfWIP - ValueOfInvOutput1 + ValueOfExpOutput1;
ValueOfOutput := ValueOfExpOutput2;
END;
I also noticed that the variables ValueOfInvOutput1 and ValueOfExpOutput1 are only assigned with values for records with Posting Date < Starting Date specified by the user. So if the user leaves the Starting Date blank, these values are all zero. As for ValueOfExpOutput2, the value assigned is always the expected cost even when the actual cost has already been posted. Any idea what is the rationale behind this code? Would it be correct to comment out this code entirely? Thank you!