Report: Inventory Valuation - WIP

seckpin

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!

Theo_Kersten

I think we are having a similar problem with report 1001: When an item receipt is posted on 01-11-2005, and the corresponding purchase invoice is posted on 31-10-2005, this report does not list this item purchase per 31-10-2005.
Is this a same kind of problem as you had, and did commenting out the code resolve it?