Announcements
No record found.
I am used to working with Management Reporter and being able to have multiple lines of column headers but I can't find a way in Account Schedules. Also, to pull in so real time data (i.e. month)
Looking to do the following
Am I missing something?
In BC, Account Schedules are used in conjunction with Column Layouts. Account Schedules define the lines and totalling while Column Layouts define what is printed. You can mix and match or define one Column Layout to each Account Schedule.
You example is easy in Column Layouts.
I understand how account schedules and column layouts and mix/match
What I am looking for is multiple lines of an individual column like
As of 3/21/2022
B
2022
That as the 3 label lines for column 10 for example
Oh, you only have the Column Header to use for the Columns and it's not multiple lines.
3/31/22 (A) 7/31/20 (B) VARIANCE (A-B)
You would have to shorten your Column Header like the above example.
Hi, for the Period Formulas, hope the following helps.
https://docs.microsoft.com/en-ca/dynamics365/business-central/bi-how-work-account-schedule#comparing-accounting-periods-using-period-formulas
Thanks.
ZHU
Hi There
I am adding 2 links here refer how you could create an additional column and then do reporting based on that
Is that what you need?
dynamicsnavfinancials.com/.../
archerpoint.com/.../
Regards
Vinita
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 748 Super User 2026 Season 2
YUN ZHU 354 Super User 2026 Season 2
AndrewThomas81 351 Super User 2026 Season 2
