Plus Community - for users of ACCPAC & Adagio accounting software

Welcome to the PlusCommunity forums! PlusCommunity is a gathering place for companies running Simply Accounting, ACCPAC Plus, Sage Accpac ERP (ACCPAC Advantage/ACCPAC for Windows), and Adagio Accounting.
New visitors, please click here!

Page 1 of 1 1
Topic Options
#53293 - 10/31/17 01:34 PM New POs are not showing up in Query
jnsimex
Member


Registered: 11/27/05
Posts: 368
Loc: Canada
I have a simple query that extracts PO data from PORCPH1 and POPORL.

For some reason, I do not see any current POs in the results. Our PO43344 was posted yesterday there is no record of it in the extracted data.

Any reason for this?

SELECT PORCPH1.DATE, PORCPH1.VDCODE, PORCPH1.VDNAME, PORCPH1.PONUMBER, POPORL.ITEMNO, POPORL.ITEMDESC, POPORL.VENDITEMNO, POPORL.OQORDERED, POPORL.OQRECEIVED, POPORL.OQOUTSTAND, POPORL.OQCANCELED, POPORL.EXPARRIVAL, POPORL.GLACEXPENS
FROM SIM005.dbo.POPORL POPORL, SIM005.dbo.PORCPH1 PORCPH1
WHERE POPORL.PORHSEQ = PORCPH1.PORHSEQ and PONUMBER='PO0043344'

Top
#53294 - 10/31/17 01:37 PM Re: New POs are not showing up in Query [Re: jnsimex]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7549
Loc: Location, Location
Your join is strange but it should work. Double check your data.
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53295 - 10/31/17 01:58 PM Re: New POs are not showing up in Query [Re: Jay Converse]
jnsimex
Member


Registered: 11/27/05
Posts: 368
Loc: Canada
ughh my bad, I linked the wrong table. I linked PORCPH1 instead of PORORH1.

I need more coffee.

Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: