Summary Trial Balance Report

(0) Share

Report

Posted on by Tanmay Upgade

290

Hi Experts,

I'm modifying Summary trial balance report by adding fields in report ie. Debit, credit and Amount in transaction currency.

I checked LedgerTrialBalanceDP in which business logic is flowing now I want the value of Debit credit and Amount in transaction currency. Path - General ledger>> Common >> Trial balance and by clicking "By Currency" button in which data is displayed.

Can anyone help me how to get this values in report.

Thanks

Tanmay

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (2)

André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

Hi Tanmay,

You need to extend the temporary table used by the report/data provider. Then you can do additional logic to get the transaction currency amounts from the balances table.

Was this reply helpful? Yes No
Tanmay Upgade 290 on at

Like (0)

Report

Hi Andre,

In which method I should write logic in DP class so that while generating report this fields are shown with its respective values.

Thanks

Was this reply helpful? Yes No
André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

Hi Tanmay,

There is a method which inserts the data in the temporary table. I don't know the methods by mind. You can do a quick 'reverse engineering' yourself to find the method name. It would be the best, performance wise, to do it all in one query. Possibly you can also look at development options in Dynamics 365 to be a bit more future compliant for extension based development.

Another question: Did you try to create a similar report using Management Reporter already?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Tanmay U,

Why are you putting much work into this?

I would recommend that you use the management reporter where the setup and configuration of reports is much easier.

Have you considered using the management reporter?

Best regards,

Ludwig

Was this reply helpful? Yes No
Tanmay Upgade 290 on at

Like (0)

Report

Hi Experts,

How can I make this report using Management Reporter in AX 2012 . Can anyone give any references links or steps about this.

Thanks

Tanmay

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Tanmay,

You can open the Management Reporter in GL. Simply open the reports section and the first menu item you see ('Management Reporter') should allow you to open it.

You can find additional information on the Management Reporter here: docs.microsoft.com/.../dn435963(v=technet.10)

Also check out the dynamics learning portal and some community blogs for additional information.

Best regards,

Ludwig

Was this reply helpful? Yes No
Tanmay Upgade 290 on at

Like (0)

Report

Hi Ludwig,

I tried generating Summary trial balance report using MR. Here I added one field Amount in transaction currency So while generating report using MR I want to display Amount in transaction currency field in EUR in same report. Default transaction are in USD.

Thanks

Tanmay

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Tanmay,

In the COA you can define how the amounts are translated into other currencies.

Please have a look at that configuration and select the method you need.

In addition, have a look at the column definition and the currency setup made there.

Those two settings define what you see in your report.

Please check the following site:

docs.microsoft.com/.../column-definitions-financial-reports

Best regards,

Ludwig

Was this reply helpful? Yes No
Tanmay Upgade 290 on at

Like (0)

Report

Hi,

I changed the column definition of summary trial balance - default and added the debit and credit and transaction amount in currency,In Currency display I entered reporting currency EUR. I couldn't fount any currency change in debit and credit in Euro.

Can anyone help me in solving this.

Thanks

Tanmay

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Do you have a currency conversion specified for your main accounts?

In addition, when you run the report did you select the 'include all reporting currencies' parameter that can be found right below the company name drop down box?

Best regards,

Ludwig

Was this reply helpful? Yes No