Share
ReportI 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
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
All responses (
Answers (
495