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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Financial reports: Unable to export at transaction level

(0) ShareShare
ReportReport
Posted on by 149

Hello,

Screenshots from my report are attached below. I cannot work out why I am not able to export at a transaction level (button is greyed out). The report is working fine at a summary and account level.

Any help would be highly appreciated.

Thank you.

0160.Capture-1.PNG

3884.Capture-2.PNG

2870.Capture-3.PNG

0143.Capture-4.PNG

I have the same question (0)
  • Suggested answer
    saurabh bharti Profile Picture
    15,039 Moderator on at

    Hi,

    Can you check following:

    1.  Are you able to generate standard reports given in for financial reports at transaction level?

    2. Are you able to drill down to transaction level on screen after running the report?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Dynamics Hampshire,

    Can you enable all of the first three parameters in your first screenprint and then try exporting again?

    Best regards,

    Ludwig

  • DynamicsHampshire Profile Picture
    149 on at

    Hi Ludwig,

    Apologies if I was not clear in my post. The 3rd option is greyed out. I cannot enable it. The first 2 are fine but cannot enable the 3rd.

    Best regards,

  • DynamicsHampshire Profile Picture
    149 on at

    Hi Saurabh,

    Thanks for trying to help. Valid questions from your side.

    For question 1, it is Yes. This problem does not exist for standard reports.

    For question 2, the drill down to transaction level is working but not at the report level, only by directly going into account transactions. The drill down to transactions while remaining within FR as well as the export transactions option is disabled for this specific report.

    This is very weird.

    Regards,

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi,

    Can you regenerate the report and ensure that the parameter 'financial, account & transactions' is selected when generating the report. If this is the case you should be able to export all levels to Excel.

    Best regards,

    Ludwig

  • DynamicsHampshire Profile Picture
    149 on at

    Hi Ludwig,

    Please see screenshot 2 in my first post. Unless I am mistaken, that is set correctly. It is still not working.

    Best regards,

  • Suggested answer
    Rahul Mohta Profile Picture
    21,032 on at

    as Ludwig and others suggested, the original report design must include the level of financial, account & transactions and then one can download the transaction level details

  • DynamicsHampshire Profile Picture
    149 on at

    Hi,

    Please see screenshot 2 in my original post and tell me if I am doing anything wrong.

    Thank you.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi DynamicsHampshire,

    Can you please try recreating the report just to make sure that the report was run with the correct parameters?

    It should only take a couple of seconds until the report is reprocessed.

    Best regards,

    Ludwig

  • DynamicsHampshire Profile Picture
    149 on at

    Hi Ludwig,

    Thank you for trying to help. I recreated the report, row and column definition. No change. Still cannot export to transaction level.

    Very strange. It is like something has changed in the settings to disable this functionality.

    Regards,

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 646 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans