Beginning balance of year in management reporter

(0) Share

Report

Posted on by Community Member

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!

*This post is locked for comments

All responses (17)

Answers (7)

Community Member on at

Like (0)

Report

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 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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.

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 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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.

Best regards,

Ludwig
Community Member on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 on at

Like (0)

Report

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!