You’re offline. This is a read only version of the page.
Hello:
Per my query below, I have tried getting the PM30200.OCDATE to appear. But, it is shoing NULLs.
I have tried a million ways to Sunday to get the DOCDATE to show. But, this has beaten me.
Please help me fix this!
Thanks! Much appreciated! Sorry about the crudity of the copy and paste. All I know is that I have a deadline to turn this around and this turned out to be harder than I thought.
John
Select distinct ACTNUMST, ACTDESCR, DEBITAMT, b.DOCDATE
from GL20000 a
left outer join PM30200 b on a.TRXDATE = b.PSTGDATE and a.ORMSTRID = b.VENDORID and a.ORCTRNUM = b.VCHRNMBR and a.ORGNTSRC = b.TRXSORCE and a.ORDOCNUM = b.DOCNUMBR and a.ORTRXTYP = b.DOCTYPE
join GL00105 c on a.ACTINDX = c.ACTINDX
join GL00100 d on a.ACTINDX = d.ACTINDX
--join PM30300 e on e.VCHRNMBR = b.VCHRNMBR
--join POP30300 f on VNDDOCNM = e.APTODCNM
--join POP10500 g on g.POPRCTNM = f.POPRCTNM
--join POP10100 h on g.PONUMBER = h.PONUMBER
--join POP10110 i on i.PONUMBER = h.PONUMBER
Where d.ACTNUMBR_4 in ('604', '605')
and a.TRXDATE between '1/1/2018' and '04/04/2018'
John
*This post is locked for comments
The bottom line is that I cannot get the GL20000 and PM30200 tables to successfully link. Please help.
Thank you!
John
Thank you!
I wish you the best of luck in your endeavors, as well!
John
No, there are too many NULLs for all of them to be voids. There's no true pattern, in any sense of the word.
Thanks, for your input, however.
John Ellis, MCP
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,219
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (