Item Unit Cost at a certain date

Ash_7777
Ash_7777 Member Posts: 5
in NAV Three Tier
Good day!
I need a way to calculate the Unit Cost of an item at a certain date in a report.The date will be chosen in the request page.All I was able to found is the last Unit Cost in the Item card.
The NAV version is 2013R2

Answers

  • Ash_7777
    Ash_7777 Member Posts: 5
    anyone please!!!
  • BorisK
    BorisK Member Posts: 45
    Build your Report on Value Entries and calculate Unit Cost at any point by the following formula:
    (Total "Expected Cost" + Total "Actual Cost") / Total "Item Ledger Entry Quantity"
  • Ash_7777
    Ash_7777 Member Posts: 5
    BorisK wrote: »
    Build your Report on Value Entries and calculate Unit Cost at any point by the following formula:
    (Total "Expected Cost" + Total "Actual Cost") / Total "Item Ledger Entry Quantity"

    I tried this before but I found that the result of (Total "Expected Cost" + Total "Actual Cost") / Total "Item Ledger Entry Quantity" is sometimes different from the unit cost in the item card when I try the today date. I think it has something to do with costing method or and the entry type.
  • BorisK
    BorisK Member Posts: 45
    Possibly, but that could be due to the fact that "Adjust Cost - Item Entries" hasn't been run. This formula is used by NAV for calculating Unit Cost (see function UpdateUnitCost() in C5804).
  • Ash_7777
    Ash_7777 Member Posts: 5
    BorisK wrote: »
    Possibly, but that could be due to the fact that "Adjust Cost - Item Entries" hasn't been run. This formula is used by NAV for calculating Unit Cost (see function UpdateUnitCost() in C5804).

    I did run the "Adjust Cost - Item Entries" and it still different for some items. Not only that but if I check the Average cost calc. overview page the last unit cost is different from the one on the item card. There is a lot of transfer entries in those items maybe that change the unit cost calculation in some way.
  • Y_1716
    Y_1716 Member Posts: 11
    edited 2017-07-11
    hi, I have a report that does this (get unit cost as at a date passed as filter) but the unit cost becomes negative! I am using the value entries and 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
    ((-720+600)/57)) = -2.1

    Can anyone explain what could cause this negative total cost expected, please?
  • Ash_7777
    Ash_7777 Member Posts: 5
    Y_1716 wrote: »
    hi, I have a report that does this but the unit cost becomes negative! I am using the value entries and 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
    ((-720+600)/57)) = -2.1

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

    If your goal is to just calculate the last unit cost then you can get it from the item table without any calculation. But if you want the unit cost at a certain date you have the same problem as me.
  • BorisK
    BorisK Member Posts: 45
    edited 2017-07-11
    deleted
  • kriki
    kriki Member, Moderator Posts: 9,121
    [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!

  • BorisK
    BorisK Member Posts: 45
    Y_1716 wrote: »
    hi, I have a report that does this (get unit cost as at a date passed as filter) but the unit cost becomes negative! I am using the value entries and 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
    ((-720+600)/57)) = -2.1

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

    Not sure, expected cost shouldn't normally go negative.
    Have you run Adjust Cost - Item Entries?
    If it's a purchase Item - could it be that some of the Purchase Receipts only partially invoiced?

Categories