Inventory Valuation Report, Unit Cost = 0, when Remaining Qty. <= .5

Inventory Valuation Report, Unit Cost = 0, when Remaining Qty. <= .5

This question has suggested answer(s)

NAV 2009 R2, Version US Dynamics NAV 6.0 SP1 (6.00.33046).

When printing the Inventory Valuation Report from RTC, I've found that Unit Cost will = 0 when Remaining Qty. <=.5.

When looking at the report layout, I see this Report Property Code;

Public Function CalcUnitCost(Inventory as decimal, Remaining as integer)

     if Remaining = 0 then

         return 0

     end if

     return Inventory/ Remaining

End Function

I could change Remainin from "as integer" to "as decimal".  Any reasons why this change might not be desirable?

All Replies
  • Hi,

    I think this is safe enough. You could get unreasonably high cost amouts when your Remaining is near zero, though. Which would be a quesion of choosing the right base unit of measure.

    with best regards

    Jens