215
For a report I am working on, I need to see GL20000.DSCRIPTN with a query that is pulling info from AAG30000, AAG30001, and AAG30002. What columns can I use to join these tables?
Thanks in advance for your help!
*This post is locked for comments
Hi Med - I'm trying to do the same thing. Could you share your results? Thanks!
Hello, Med -
How about the below
For your joins?
AAG30000.JRNENTRY = GL20000.JRNENTRY AND
AAG30000.RCTRXSEQ = GL20000.RCTRXSEQ AND
AAG30000.aaGLHdrID = AAG30001.aaGLHdrID AND
AAG30001.SEQNUMBER =GL20000.SEQNUMBER AND
AAG30001.aaGLHdrID =AAG30002.aaGLHdrID AND
AAG30001.aaGLDistID =AAG30002.aaGLDistID
Best of luck
Thank you for the info. I had reviewed this article prior to posting this question. The article does not join the AA tables with the GL20000 table.
I need the JE distribution references with the AA info. The problem here is that the JE distribution reference is being captured on the GL tables and the users are not using the AA distribution reference in the JE. So I am tasked with stitching these tables together at the distribution level. Any other suggestions?
Hello Medardo:
Mr. Saadi a true AA savant has some ideas here:-
http://mahmoudsaadi.blogspot.com/2014/03/general-ledger-journals-with-analytical.html
Best of luck
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (