WIP Report BAQ

[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…