Attempting to connect Part and PartCost tables in a BAQ? There are table relations based on these two tables. Whats the solution?

Erp.Part to Erp.PartCost where PartNum = PartNum Display Field (AvgMaterialCost, StdMaterialCost, LastMaterial Cost) depending on your company setup. [ErpPart] [PartCost]

The tricky part is your CostID in PartCost. You just hardcode your ID (or prompt for it). If you only have one CostID in your system, it’s usually ‘1’. Mark W.

Found it. How do I use the Site CostID in a query?

add a table criteria for PartCost PartCost.CostId = 1 (use your cost ID)

I figured that out as well thanks

Make the Part to PartClass join an OUTER one, as Part.ClassID can be blank. And with PartBin being an INNER join, only parts with QOH’s will be included.

I would like to add the AvgLaborCost, AvgBurdenCost, AvgMaterialCost, AvgSubContCost, AvgMtlBurCost fields from PartCost to the Order Entry detail screen based on the part ordered. When I try to customize the form, there is no EpiBinding to PartCost. Is there an easy way to do add them in? FKV maybe…

Part and PartCost

Epicor ERP 10

ckrusen (Calvin Krusen) February 25, 2019, 5:10pm 6

You’re going to have to calculate the part cost based on the cost method (which I believe can vary by plant).

Topic		Replies	Views
Best way to get part cost for specific PartBin Epicor ERP 10 baq	4	1145	December 23, 2019
Cost of part Epicor ERP 10	19	11372	August 1, 2017
How to join PartCosts to InvcDtl to get a part's many different costs for a report Epicor ERP 10 baq-part-costs	2	819	July 22, 2019
AvgTotUnitCost Table Epicor ERP 10 baq	4	399	February 25, 2021
BAQ for BOM cost Epicor ERP 10	5	1722	September 12, 2018

Part and PartCost

Related topics