web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Dynamics AX AIF Trial Balance Report

(0) ShareShare
ReportReport
Posted on by

Hello,

I am a new Partner and have been working on creating integrations using WCF.  Currently, I am trying to retrieve a trial balance report through the use of the Application Integration Framework.  I am programming in C#, currently against Dynamics AX 2012.

I was wondering if it is possible to retrieve a trial balance with existing services without using SSRS or the QueryService/MetadataService, and without any X++ programming?

What is the best approach to pull a trial balance.

*This post is locked for comments

  • Suggested answer
    Vilmos Kintera Profile Picture
    46,149 on at

    Check the LedgerTrialBalanceListPage form, it does pull the data back and displays it in the AX client.

    If you check the code, you'd notice that in fact it uses the Trial balance report's data provider class, and processes the report programmatically without generating an SSRS result. LedgerTrialBalanceListPageTmp.constructBalances is the one to take a look at.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    307,429 Super User 2026 Season 2 on at

    Hi Lee,

    Without x++ programming it would be very difficult. It would be possible to create a custom service in AX using the data provider for the trial balance. Or call the data provider fro your C# project. Note that the business connector is depreciated in the next version of AX. So a custom service within AX would be the preferred solution.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans