Has anyone ever taken the Close Project error report and modified it to seek out what (on the purchase invoice) side is causing the hang-up... for example going to all related Purchase Orders to see if there are any open line statuses, checking AP to make sure all lines are matched and approved...etc?

Looking for assistance if anyone has some code that could help with the digging.

It could also be applied to production orders for subcontracted operations.

The issue is we have logistics people digging down just to find out that the true issue is a hold up in Accounts Payable. This report would allow them to only focus on those with a true logistics issue and hand the rest over to Finance.

Any help would be greatly appreciated.