You’re offline. This is a read only version of the page.
I need to pull a list of all of our Tax Detail ID's and cross reference the GL accounts in order to make sure they are all set up accurately.
*This post is locked for comments
thanks Rick, that was exactly what I was looking for!
I believe this will work:
Select A.TAXDTLID as 'Tax Detail ID'
,A.TXDTLDSC as 'Description'
,B.ACTNUMST as 'GL Account'
From TX00201 A
Inner join GL00105 B
on B.ACTINDX = A.ACTINDX
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (