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
Hi Jane
Did you get this right?
I also require the BB of the Year to repeat itself for each column.
Regards
Charne
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!
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
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!
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
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!
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
Hi Ludwig,
YES, row 110 is the same with 111, and row 112 and row 113 is same.
Thanks
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
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!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (