Which field is Actual Material Cost?

Rich1704

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?




Any help would be really appreciated, thanks.

kriki

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

sorenhinrup

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.