DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
cthury 1/23/2018 12:10:32 PM

Duplicates in GP 2013

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

Version: GP 2013
Section: Dynamics GP, SQL Scripts