Unit cost - negative!

Y_1716

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?

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]