Our Procurement Manager who runs the Inspection Processing for PO Receipts would like to have a report she can run to see what was inspected and processed through on any given day. The only way I could think of was to look at the PartTran table to see when it has left inspection, but this would not work for purchase/make direct parts as there would be no part history. I can’t see any way to do this but i’m being pushed for a solution, does anyone have any ideas? Even if I could get a report to run at the end of the day and sent to her, I think that would suffice.
The table erp.RcvDtl has inspection data on each receipt line, including who inspected it and when. RcvDtl also, naturally, has the receipt date so you can run metrics on throughput. X% cleared same day, Y% within 3 days, etc.
Also, PartTran still has transactions for parts entering and leaving inspection. I’m not sure what you mean by “no part history”. You can always tie to PONum or SO and cross reference order dates to see just how long your org takes to get something processed.
1 Like
@jtownsend is on the right path for this report. RcvDtl has fields that make it almost designed for this. It is missing received time if you want to get down to hours and minutes, but that is in PartTran.
1 Like