I am trying to let our AP Team know about duplicate documents before an upload into GP-2013 is attempted. This will save time with our accounting team to capture these duplicates early in the process.
What GP tables will I need to query, for both PO (POP tables?) and NonPO (PM tables?) documents? And these GP documents may be paid, posted, or not posted.
A stored procedure is preferred. But am willing to look at other alternatives.
If you need more info, let me know.
Thanks,
Chris