If you really want to make a report, the PartTran table should be what you need. Summarize the transactions based on the JobNum. This will let you see costs added to jobs (STK-MTL, PUR-MTL, etc…) and costs removed from the job (MFG-STK, MFG-CUS, etc…).
one caveat … you’ll need to adjust the sign of the ExtCost based on the trantype
For the WIP balance I am just taking the actual job cost and subtracting the extended cost of the receipts/shipments. If you have job activities including adjustments, non-conformance entries, etc. this probably need to be adjusted accordingly. Comparing it to your existing WIP report will let you know how accurate it will be in your environment. You will also need to add a filter for closed jobs. Currently, this shows all non-closed jobs.
Thanks, Ross. I appreciate it. I’ve got something like this, but not all fields. This will help. I’m still baffled as to why the MFG-VAR transactions that have not posted, won’t show up. If I post the MFG-VAR, they appear. Just very strange.
It is because in this floating inventory cost model they are all generated on-the-fly via posting rules during the INV/WIP Reconciliation process. You can examine these to see how they are generated in the COSandWIP GL Transaction Type Maintenance.
I have created a query to look for mfg variances of jobs that are closed but not yet posted thru month end “Capture”. But my query is looking for only Std costed parts only, so if you’re using a different costing method than Std, then you might have to tweak the query.
The dates prompted in the query are ranges of job closing “From and To”.