News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Trial Balance Query in...

Microsoft Dynamics AX (Archived)

Trial Balance Query in SQL

(0) Share

Report

Report

Posted on by helen3000

150

Hi there,

Does anyone know what is the sql query for running Trial Balance in AX? I am new and need help please.

Thanks.

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (0)

helen3000 150 on at

Like (0)

Report

RE: Trial Balance Query in SQL

Hi Dominic,

Don't worry about it, now I found where it is!

Many thanks.
helen3000 150 on at

Like (0)

Report

RE: Trial Balance Query in SQL

Hi Dominic,

Thank you for your response. I am new to AX, how do I get to the Report Data Provider Model?

Helen
Suggested answer

dolee 11,279 on at

Like (0)

Report

RE: Trial Balance Query in SQL

Hi,

Similar to your question regarding Balance list, Trial Balance report also uses the Report Data Provider model. The logic for preparing Trial balance report data can be traced from \Classes\LedgerTrialBalanceDP\processReport method.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#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

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans