We are trying to find where the PartRevCost information lives so we can make a BAQ or Dashboard. Can anyone point me in the right direction?
You’re looking for the summary buckets? These should be in the PartRev table I believe. Look for fields that are named something like TLMaterialCost, LLMaterialCost etc. These are your top level and lower level (sub assemblies) cost buckets. Add the top level and lower level matching fields together and I think you’ll get what you’re after.
Hi Chad,
Close but not quite. What we are looking for is the Total Cost lines. When I add the TL and LL I get the current Std Cost. What we are trying to make is a BAQ to show the effect of any engineering changes for cost before a cost roll process is performed.
You don’t have a different cost on a Rev A vs Rev B or you made the engineering changes in the original Revision?
If both Revisions are still checked out, does ECOPartRev may have the same costing fields? I’d have to look and see as I’m not sure.
I’ve done BAQ’s comparing PartCost to CostPart before. PartCost is your current cost and CostPart stores the Cost Rollup BEFORE it posts. It’s gone once you post it though as I recall, so you have to make sure no one posts it until your analysis is complete. This is certainly a brute force approach.