web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Is there a report or a...

Microsoft Dynamics GP (Archived)

Is there a report or a query to show the Tax Details ID with the corresponding GL Account?

(0) Share

Report

Report

Posted on by Community Member

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Suggested answer

Rick Hollis 495 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

thanks Rick, that was exactly what I was looking for!

Was this reply helpful? Yes No

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!

Ask A Community Pro

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans