this is done with Account Schedules (Financial Reports) using relative period formulas, not fixed years. The column is defined with a Comparison Period Formula (for example last full year), so when the user changes the Date Filter, Business Central recalculates both the amounts and the year shown in the column header automatically. To show the entire previous year, you configure the column as Net Change and use a relative formula like last fiscal year (e.g. -1FY or equivalent based on your fiscal setup). You never hard-code the year — it’s fully dynamic.
Regards,
Oussama Sabbouh
Was this reply helpful?YesNo
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.
571
Share
Report
All responses (
Answers (
