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 145

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

  • jvermette09 Profile Picture
    77 on at
    RE: Financial reports: Unable to export at transaction level

    Hey Did you ever figure out the issue here? I have the same problem

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Financial reports: Unable to export at transaction level

    Hi DynamicsHampshire,

    Do you have a different demo/test machine where you could replicate the issue?

    Are you operating the very latest D365FO version?

    Best regards,

    Ludwig

  • Suggested answer
    saurabh bharti Profile Picture
    15,033 Super User 2025 Season 1 on at
    RE: Financial reports: Unable to export at transaction level

    HI,

    Please try to have atleeast one column as "Periodic" in column definition and try,

  • MATTGUO Profile Picture
    22,319 Moderator on at
    RE: Financial reports: Unable to export at transaction level

    Please try to change the YTD as PERIODIC, it should work.

    Or add a new column with the PERIODIC period covered.

    pastedimage1595473440794v1.png

  • DynamicsHampshire Profile Picture
    145 on at
    RE: Financial reports: Unable to export at transaction level

    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,

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Financial reports: Unable to export at transaction level

    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
    145 on at
    RE: Financial reports: Unable to export at transaction level

    Hi,

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

    Thank you.

  • Suggested answer
    Rahul Mohta Profile Picture
    21,014 on at
    RE: Financial reports: Unable to export at transaction level

    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
    145 on at
    RE: Financial reports: Unable to export at transaction level

    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
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Financial reports: Unable to export at transaction level

    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

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,430 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,043 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans