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

"Row Linking" in Account Schedules?

(0) Share

Report

Posted on by john.ellis

3,510

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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Dallefeld 211 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

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 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

Was this reply helpful? Yes No
john.ellis 3,510 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

Was this reply helpful? Yes No