Which field is Actual Material Cost?

Rich1704
Rich1704
in NAV Three Tier
Hello,

This is my first post so apologies for any missing information that might be needed.

I am trying to report on expected costs vs actual costs for production orders in Nav 2015. In the Nav client I have been using the Production Order Statistics. However, I am trying to build a Jet report and I am unable to locate the fields that show the expected material cost and actual material cost.

I have used the Capacity Ledger Entry table to find the Capacity Cost values - can anyone tell me which table and fields I need to link to report on the figures relating to materials consumed?

adqwzgbse7fd.png


Any help would be really appreciated, thanks.

Answers

  • kriki
    kriki
    [Topic moved from 'Navision Financials' forum to 'NAV Three Tier' forum]

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

  • sorenhinrup
    sorenhinrup
    edited 2017-08-04
    The Actual Cost for the material is a summation of records in table 5896 on "Single-Level Material Cost".

    If you want to calculate this manually, you can use item ledger entries with posting type consumption and document no = production order no.
    But this is depending on your costing methods in the item setup.

Categories