Attempting to connect Part and PartCost tables in a BAQ?
There are table relations based on these two tables. Whats the solution?
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.
Where is the CostID located?
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)
You’re going to have to calculate the part cost based on the cost method (which I believe can vary by plant).
Erp.Part to Erp.PartCost where PartNum = PartNum
Display Field (AvgMaterialCost, StdMaterialCost, LastMaterial Cost) depending on your company setup.
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? If so, how would that be setup?