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?
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
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
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.
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
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.
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 Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sumit Singh 2,708
Sohail Ahmed 2,675 Super User 2025 Season 2
Jeffrey Bulanadi 2,203
