Skip to main content

Notifications

Microsoft Dynamics AX forum
Answered

Beginning balance of year in management reporter

Posted on by Microsoft Employee

Hi all

How to define the beginning balance in row modifier in management reporter? It seems the  Account modifier 'BB' is the beginning balance of the period which is selected?

Thanks!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Beginning balance of year in management reporter

    Hi Jane

    Did you get this right?

    I also require the BB of the Year to repeat itself for each column.

    Regards

    Charne

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Beginning balance of year in management reporter

    Hi Ludwig,

    I did not test successfully. Maybe I described it not so clearly. In periods covered of columns, I select 'PERIODIC' from Jan to Dec. But one row, it need to  be displayed the balance amount of this year in each column from Jan to Dec, that means, this row display the same number.

    Thank you!

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Beginning balance of year in management reporter

    Hi Jane.Gu,

    In the row modifier you can specify a YTD period coverage.

    However, you don't have the start and end date and no period dependent print-options.

    You consequently need to do some additional testing to see whether this can be achieved through the row setup.

    Regarding your second question: Yes, you can manually enter a number simply by adding it in column D 'related formulas/rows/units'. This number can then be used for further calculations.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Beginning balance of year in management reporter

    Hi Ludwig,

    Can I set up in row modifier by 'YTD'?  It seems also can work.

    And another question, can I define a row which can be filled in number manually each period?

    Thanks!

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Beginning balance of year in management reporter

    Hi Jane.Gu,

    I see.

    So, in your case the ending balance of May as of 31 May 2017 is different from the June balance as of 1st June, right because of the postings made on 1st June, right?

    Is it possible that you incorporate the periods selection into your column design?

    I think that you can filter your data in the way you want by working with

    - the periods covered field

    - the print control functionality

    - the start and end dates  

    Below a screenprint that highlights those fields.

    6153.mr3.png

    The screenprint above does not exactly match your example but it hopefully gives you an idea what settings to work with to get your intended result.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Beginning balance of year in management reporter

    Dear Ludwig,

    I have tested it, if I selected the period as '5', the result was the beginning balance of the June, not the ending balance of the May.

    Thank you!

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Beginning balance of year in management reporter

    Hi Jane,

    If you setup your rows with an account modifier /BB and provided that your column definition refers to the period, you should be able to get the result you expect.

    mrJane1.png

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Beginning balance of year in management reporter

    Hi Ludwig,

    YES, row 110 is the same with 111, and row 112 and row 113 is same.

    Thanks

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Beginning balance of year in management reporter

    Hi Jane.Gu,

    What is the exact difference between row 110 and 111?

    And row 112 and row 113?

    For me, they look the same.

    Can you explain a bit?

    Many thanks,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Beginning balance of year in management reporter

    Dear Ludwig,

    The report likes below:

    ROW Column 1            Column 2                     Column 3

    110        Period Jan amount   Period Feb amount     Period Mar amount

    111        Period Jan amount   Period Feb amount     Period Mar amount

    112        Ending Jan balance   Ending Feb balance     Ending Mar balance

    113        Ending Jan balance   Ending Feb balance     Ending Mar balance

    Thanks!

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,682 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,000 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans