WIP report at the end of Dec 2023 for job 543. Looks like there is a total of $241K in WIP. They are looking for tie outs to this with BOMs and WIP. I’m struggling to get anything to tie out. We have a 2024 Cost roll, that causes a problem. If I look at my Cost Roll file I see part number SKP-100 Old Cost was $325K, New Cost is $298K. If I pull a BOM today it shows a cost of $300K. Not sure why it would change. If I dump an Indented BOM into CSV in order to try to compare what parts were issue vs not issued at the end of 2023. I can’t figure out how to add the individual parts up to get to the total of $300K. I get something much higher. If I don’t include Level 1s assuming that was a roll up assembly of individual parts, then my cost is too low.
I am happy to toss some ideas out. I was just working on this the past couple days so I am also asking questions and feeling my way though. PartWip stores all the WIP part data. It’s then a matter of what do we try to join it to to tie out to the Financial WIP Report value.
I know there’s an answer or at least something to get us very close. But I don’t yet have it. Maybe there’s something to do with the part itself in the BOM that has an estimated cost
I’m on premise. I wonder if I were to run the WIP report and archive it so that I could view it in SQL Management Studio and then review the table of parts it has. It would likely have the cost of each line item that you’d then be able to try to explain on certain examples why the cost is X vs Y. If you’re on premise, you can try that. If not, I think I will give it a shot a little later.
Look at the parttran table for transfers into and out of the job, it may provide more insights as it captures the cost at the moment the transfer occurred.