Skip to main content
Business Central forum
Suggested answer

"Row Linking" in Account Schedules?

editSubscribe (0) ShareShare
ReportReport
Posted on by 3,476

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

  • john.ellis Profile Picture
    john.ellis 3,476 on at
    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 Profile Picture
    MahGah 15,395 on at
    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

    pastedimage1648648762220v1.png

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,415 UG Leader on at
    RE: "Row Linking" in Account Schedules?

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

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,068 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,591 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans