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 too.

1 Like