WIP Report BAQ

[EdWCler (Eddie Cler)]

I am looking to build a WIP report BAQ that can be joined with other tables. What I specifically see is the JobNumber with the Labor Burden, Material, Sub, and MtlBurden cost components along with the ToDate, ToInventory/ToJob, COS/MFG-VAR, and WIP categories. I can get the ToDate from the JobAsmbl Table, but am not sure how to split it out from there. Does this information exist in a table somewhere, or does it need to be calculated somehow?

[gpayne (Greg Payne)]

Most of it is in summed into JobAsmbl then you need to remove what has been shipped or issued to finished goods.

My baq is uploaded to the thread below. It is not perfect, but within 2K on 5M.

New WIP Report - Where's the data?

I think you need a module like Advanced Material Management to use the PartWip table. If you do not have that there is a quick and dirty way to figure out wip. Sum up all your PUR-MTL and STK-MTL transactions to the job by part number and multiply the component count by the percent of job remaining. This will show the materials remaining in the job. Not perfect but close enough for most purposes. PartTran also has the cost moved into the job so if you’re going after costing you can roll that up…