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

Community site session details

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

Account statement Report - Total account report shows Empty

(0) ShareShare
ReportReport
Posted on by 339

HI 

While Running the Account statement from Main Accounts for Account type Total , Its Showing Zero . 

In the balance its showing a value .

Kindly help how to generate report for main account type total.

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Account statement Report - Total account report shows Empty

    Hello Mohamed,

    Can you provide more information how you run the report?

    Check especially

    - period

    - company

    - filters applied

    Many thanks and best regards,

    Ludwig

  • shuhaib Profile Picture
    339 on at
    RE: Account statement Report - Total account report shows Empty

    0868457.Untitled.png

    For Expense Type Report is working

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Account statement Report - Total account report shows Empty

    Hello Mohamed,

    Many thanks for the update.

    I had a close look at your initial question and double checked the behavior in my machine.

    Unfortunately, I got the same result.

    That is, the main account statement report seems not working for total accounts.

    I would consider this as a bug and would like to ask you to report it to MS.

    Many thanks and best regards,

    Ludwig

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Account statement Report - Total account report shows Empty

    Hello Mohamed,

    Did you make any progress with this one and got somebody from MS 'on the line'?

    Best regards,

    Ludwig

  • Suggested answer
    SouravDam Profile Picture
    11,730 on at
    RE: Account statement Report - Total account report shows Empty

    In addition to mentioned by Ludwig; you can use Management reporter where you can set the combination of main accounts or categories to reflect the total values for that main account which it supposed to show.

    Create a report in MR and write the description of all such "Total" type accounts and set the main accounts or categories against each to show the respective total.

    Regards,
    Sourav

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Account statement Report - Total account report shows Empty

    Good hint from Sourav,

    Even if the standard SSRS account statement report from within AX is not able to give you the transactions for the total account, you can create a Management reporter report that is based on total accounts.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,004

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 582 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans