Job Material Cost Calculations - JobAsmbl vs JobMtl Tables

Epicor ERP 10
, ,
1

Can someone help me understand the appropriate way to calculate JobMtl costs?

I’m working with a BAQ to compare estimates and actuals on a job and believed that the estimated material costs should be captured in the JobAsmbl table by calculating JobAsmbl.LLEMaterialCost + JobAsmbl.TLEMaterialCost. This lines up with the Job Details > Assemblies > Costs screen of Job Tracker, and some of the summaries in the Production Detail Report.
image

However, the Raw Materials transactions in the Production Detail Report appear to be calculating the estimate as JobMtl.RequiredQty * JobMtl.EstUnitCost, which is giving me a totally different value. (In the case of the example above, I’m getting $112,465.76 - more than 30% more).

Can anyone help me understand why these values are different? Is one way “right” or “wrong”?

In case this is also a factor: we use Standard Costing.

2

We are lot fifo and my job tracker matches the prod detail report. In the schema the TLE fields do not mention Cost method, but the EstMtlUnitCost does.

EstMtlUnitCost The estimated material unit cost component for the assembly quantity (JobAsmbl.PullQty) that will be pulled from inventory. Use the appropriate cost found in the Part file as a default. That is, select the cost fields based on Part.CostMethod. Then crossfoot the labor, burden and material into the EstUnitCost field. This field is a subcomponent of EstUnitCost where: EstUnitCost = EstMtlUnitCost + EstLbrUnitCost + EstBurunitCost + EstSubUnitCost.