Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,606
YUN ZHU 931 Super User 2025 Season 2
Jainam M. Kothari 773 Super User 2025 Season 2