Unit cost - negative!

Y_1716Y_1716 Member Posts: 11
hi, I have a report that goes through the value entries of an item and calculates the unit cost as at the date given as a filter. The unit cost is being shown as negative because i am ending up with a negative total cost (expected) ex;

Total Cost expected : -700
Total Cost Actual : 600
Item Ledg. Entry Qty = 57

so (("Expected Cost" + Total "Actual Cost") / Total "Item Ledger Entry Quantity" ) is
((-700+600)/57)) = -1.75

Can anyone explain what could cause this negative total cost expected, please?


  • krikikriki Member, Moderator Posts: 9,096
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Sign In or Register to comment.