Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Account Statement not showing monthly totals

Posted on by 557

Hello!

We are trying to take a statement of a ledger account in AX 2009 using the native "Account Statement" report in the form Chart of Accounts.

We have the option to print it out with total by month using Specification : Month and Posting Layer: Total as shown below.

Ledger-Statement-Screen.jpg

It used to return the statement with a month wise total as shown below. (This is a print out taken in 2017).

Ledger-Statement-2.jpg

Now it returns a statement with all transactions month wise instead of the total. (Shown below).

Ledger-3.jpg

The same with all ledger accounts. Is there any reason why this could have happened? Or are we missing something.

How can we get a statement with totals month wise.

  • oldman.logan Profile Picture
    oldman.logan 557 on at
    RE: Account Statement not showing monthly totals

    2021.Trans.jpg

    Here's a clearer screenshot for your reference.

  • oldman.logan Profile Picture
    oldman.logan 557 on at
    RE: Account Statement not showing monthly totals

    Thank you Dr. Ludwig for your reply. We have the option to use "Period Balances" to bring the balances per month for ledger account and then print it via auto-report or export the form to excel. However we greatly prefer the original account statement and it looks authentic when presented to the auditors as opposed to the auto-report which we then have to format.

    May I ask, how selecting the "posting layer = total" works in the system, where is this total actually taken in the report and where can we make modifications if we want to?

    The report is "LedgerTransStatement" and below is a screenshot for the generated design with the fields.

    What I am looking for is to locate where selecting posting layer as "total" translates to in the report.

    3755.Report.jpg

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Account Statement not showing monthly totals

    Good Morning,

    It seems strange that things worked ok in the past (2017) but do not work the same (2018).

    Have you tried resetting your usage data to ensure that no 'hidden' filter or setting causes this outcome?

    As an alternative, have you opened the ledger account in the chart of account and used the buttons on the right.

    In aX2009 there is a specific button that shows you the monthly balances of an account in an online form.

    Maybe that is an alternative if the report does not give you the expected result.

    Best regards,

    Ludwig

  • oldman.logan Profile Picture
    oldman.logan 557 on at
    RE: Account Statement not showing monthly totals

    Anyone having any idea about this issue? :) Thanks in advance!

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans