If I wanted to replicate the COS/MFG-VAR value on my WIP report in a BAQ what would I need to utilize. We are a standard cost make to stock environment with single-level job assembly sequences. I assume it is a calculation of our standard to actual but I am missing what on the job filter I need to simulate it. I thought it would be based on jobs complete but not closed in jobhead and then using TLACost-TLECosts
Jobhead.JobFirm = True
Jobhead.WipCleared = False
This should give you all the jobs in WIP. As far as calculations go, it could get tricky. If you’re on std cost, the TLECost may not always be correct (ex. if you change the method on the job, but the std cost is different then it would use the std cost not estimated cost (TLECost).
I usually do a subquery using PartTran table:
PartTran.TranType in [‘MFG-CUS’, ‘MFG-STK’, ‘MFG-WIP’]
This should give me the costs relieved from WIP based on the costing method. i subtract this cost from TLACosts to get my WIP value.
Thank you for response, sorry it took awhile before I could try it but that did give me the value I want in most instances. I’m guessing it has to do with the changing of costs on the job so the estimates are different. I’m gonna keep plugging away on them