Small and medium business | Business Central, N...

"Row Linking" in Account Schedules?

(0) Share

Report

Posted on by john.ellis

3,482

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

All responses (3)

Answers (0)

john.ellis 3,482 on at

Like (0)

Report

RE: "Row Linking" in Account Schedules?

Thanks, Kim!

How would the column "tie" to a row containing an account and a row containing a formula?

John
Suggested answer

MahGah 15,433 on at

Like (0)

Report

RE: "Row Linking" in Account Schedules?

Add to Kim's feedback below is an example that goes back 12 months from current date. you can go forward 1Y for example
Suggested answer

Dallefeld 169 User Group Leader on at

Like (1)

Report

RE: "Row Linking" in Account Schedules?

Yes, it's part of the column definition. Using Date Comparison formulas