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 :
Microsoft Dynamics AX (Archived)

How to get the opening balance of the period selected in Financial Statement?

(0) ShareShare
ReportReport
Posted on by 365

We are trying to setup our Cash Flow statement using General Ledger Reports - Financial Statements. We created the required row definition. On one of our rows we have an entry for "Cash & Cash Equivalents at the beginning of the period" which is exactly the opening balance of the period selected.

When we enter the "From Date" and "To Date" in Columns tab, the rows calculating "Net" are producing correct results but the row that is calculating the "Opening" is coming out as "0". We understand that this is because of General ledger>Setup>Financial statement>Financial statement>Transactions tab's "Include opening" check box is cleared.

So, then how to get the opening balance of the period selected?

By the way, we are using AX 2009.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Deepak Agarwal Profile Picture
    8,602 on at

    WE also faced the same problem, so at last we developed our own customizes report for it, just ask your developers to check these table to develop this type of report

    1. LedgerRowDef

    2. LedgerRowDefLine

    Above table contain hierarchy structure and ledger mapping.

    If you any other help feel free to contact me.

  • danny.hc Profile Picture
    365 on at

    Thank you, Harry.

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans