Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
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








Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables