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

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
AbrahamA 3/1/2013 2:06:07 PM

Query to find mismatched PO vendors

How would I write a sql script to find it the vendor id is different between 2 po tables?  Need to find this – POP10110 shows a different Vendorid for one PO than the vendor id in POP10100.  I know there is one, but want to find if there are any more…..I think it is easy, but my brain won’t go there. 


Version: GP 2010
Section: 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