Indented bom cost baq

Kinetic ERP
, ,
1

Hi Epicor Community, has anydone a baq for indented bom cost? I’ve trying to it but did not get the same result as the bom cost report, im stuck here, appreciate if you guys can help

2

What tables are you using in your query and what is your costing method?

3

Hi @jkane we are using average costing method but from the BOM cost report I want to get the mat, subcon, labor, matburden and burden cost from part rev

here is my BAQ
MW_BOMIndented.baq (91.5 KB)

1 Like
4

Sorry, I am on v8, so can’t do anything with your BAQ.

I would need someone to confirm this, but I do not believe those get populated unless you roll your costs. @Mark_Wonsil , for some reason I think you might know the answer.

5

My understanding is the BOM Cost report is a summarization of Part Costs. It does not roll costs. Kinetic stores costs by Part (and CostID), but not by revision. You might be able to run the Costing Workbench, do the initial load with average costs, do a rollup, and store that into a different Cost ID. However, I don’t think one can pick a Cost ID when running the BOM Cost report. You could export the difference in the Cost Variance report in the Costing Workbench.

I’m not sure what the business requirement for the report is, so these are the only thoughts I have right now.

2 Likes
6

so meaning @Mark_Wonsil I can only get the cost from PartCost table right? how can I do a rollup?

7

Costing Workbench does rollups, which includes labor, overhead, and subcontracting as well.

8

@Mark_Wonsil where can I do this cost rollup?

9

Costing Workbench in Kinetic.