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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Management reporter - opening balance for fiscal year

(1) ShareShare
ReportReport
Posted on by 3,005

How is it possible to omit the Opening transactions for the balance accounts by type of "Opening" in a column? So I only get posted transactions.

NB: I don't want to make a non-printing column for fiscal year opening and then need to subtract "current month" for every month of the year with the opening in order to get posted transactions.

Thanks.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi,

    You should be able to exclude the opening transactions through the account modifier feature.

    Please see the following screenshot.

    8547.mr1.png

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    Hi Ludwig,

    I am also having this problem and don't see how the account modifier helps this?  Could you please explain further?  I more or less am trying to mimic a trial balance, having a beginning balance column, debit column, credit column, and closing balance.  Issue is for the debits column it is continuing to pull the beginning balance in as well which is not what I want.  Suggestions?

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Good Morning Waltonce12,

    Is it possible that you create a new thread?

    This one is more than a year old and it might be based on a different system/version.

    When doing that can you let us know your AX/365FO version?

    It would also be great if you could share some screenprints that show what has been setup and tested so far .

    Many thanks,

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 16

#2
GiacomoRovai Profile Picture

GiacomoRovai 4

#3
Douglas Noel Profile Picture

Douglas Noel 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans