Hi:
I need for an Account Schedule in Business Central to pull data in a row for the current year from an account in the chart of accounts but, for next year and succeeding years, pull data for that same row based on a formula.
(Each "year" is, of course, represented through columns in the Account Schedule's Column Layout.)
Do Account Schedules have flexibility to base a row on an account in one fiscal year but have that same row pull data based on a formula for succeeding years?
Or, is this sort of report writing going to have to be done in either Power BI or Jet Reports?
Thanks!
John
