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
pritzlb 8/12/2019 7:19:35 PM

Joining the PO Distributions to the PO LineNumber

I have a query that brings back all of the Purchase Order Distributions and gives me all of the data I need -- except I cannot join POP30390 to the POP10110  or POP30110 through tables like POP30390, etc.  I have the PONUMBER field but cannot find how I get the LineNumber for the PO.  Shouldn't I be able to?  Thanks much.


select rcpt_ln_hist.PONUMBER, rcpt_hist.POPRCTNM, rcpt_ln_hist.RCPTLNNM, rcpt_ln_hist.VNDITNUM
, pm_dist_hist.DEBITAMT, pm_dist_hist.CRDTAMNT
from POP30390 pm_dist_hist -- 87734
inner join GL00100 mstr
on pm_dist_hist.ACTINDX = mstr.ACTINDX
inner join POP30310 rcpt_ln_hist -- 46265
on pm_dist_hist.POPRCTNM = rcpt_ln_hist.POPRCTNM -- there is a small cartesian here
inner join POP30300 rcpt_hist
on rcpt_ln_hist.POPRCTNM = rcpt_hist.POPRCTNM


Version: GP 2015
Section: Dynamics GP

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