Dynamics AX AIF Trial Balance Report

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (2)

Answers (1)

Verified answer

André Arnaud de Cal... 291,228 Super User 2024 Season 2 on at

Like (2)

Report

RE: Dynamics AX AIF Trial Balance Report

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.
Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report

RE: Dynamics AX AIF Trial Balance Report

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.