I would like to attempt to make my own WIP report. In the RDD I see that the WIP report is based on table TWip, which I can’t find in the BAQ designer. I do see three WIP tables in the BAQ designer: PartWip, PartWipTran, and WipRpt. All three tables are empty (0 records) when I query in BAQ.
Where can I find WIP data to generate my own report?
Thanks!
Nate
The “tables” listed in native RDD’s aren’t necessarily in the DB - even ones with matching names. They are often temporary datasets created by the underlying code of the RDD.
And FWIW - I think the WIP report is essentially a summary of the part transactions, by job. Various parttrans will move costs into WIP (like STK-MTL, PUR-MTL), and others move costs out (like MFG-CUS, MFG-STK).
At least on the material side of things. No idea how labor transactions affect the WIP report.
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.
@NateS Most of it is in JobAsmbl. I had to make a dashboard last week that tied out to the stock wip report. Here is my BAQ.
COMP01-WorkInProcess sample.baq (37.4 KB)
@NateS Were you able to create a BAQ of the WIP Report? I’m working on the same problem now and would appreciate any lessons learned.
I did create a couple of WIP BAQs. But I am not sure if they ever were used in a practical way. The WIPbyDept looks at the number of labor hours spent on completed operations, multiplies it by the labor rate, and gives you some totals. It also has columns for material and subcontract costs. I am not sure if this is exactly WIP, but I think it was close enough for our estimations.
The other BAQ was an attempt to estimate the remaining value on the job and the next operation. I think we were looking for jobs that were almost complete that we could pull in to complete a month. It looks at the remaining quantity left to ship against the sales order and multiplies it by the unit price.
Be cautious with the data and don’t let it mislead you. I am no expert in this stuff. Good luck!
WIPbyDept-InventoryValue.baq (134.6 KB)
WIPbyDept.baq (107.4 KB)