Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Account Schedule Column Layout

Posted on by 27

Hi

I am creating Account Schedule report and I have doubt how to use formulas in column Comparison Period Formula in Column Type setup. I have a report where I don't know what should I put in Actual PY Period 4, and Actual YTD 2022. Anybody helps me with formulas of these dates? 

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 68,341 Super User 2024 Season 2 on at
    RE: Account Schedule Column Layout

    Hi, hope the following can give you some hints.

    Abbreviation Description
    P Period.
    LP Last period of a fiscal year, half-year, or quarter.
    CP Current period of a fiscal year, half-year, or quarter. Use CP in formulas to set the period that starts or ends the formula. For example, FY[1..CP] denotes the time from the beginning of the current fiscal year to the current period.
    FY Fiscal year. For example, FY[1..3] denotes the first quarter of the current fiscal year.

    Examples of formulas:

    Formula Description
    <Blank> Current period.
    -1P Previous period.
    -1FY[1..LP] Entire previous fiscal year.
    -1FY Current period in previous fiscal year.
    -1FY[1..3] First quarter of previous fiscal year.
    -1FY[1..CP] From the beginning of the previous fiscal year to the current period in the previous fiscal year, including both periods.
    -1FY[CP..LP] From the current period in previous fiscal year to the last period of the previous fiscal year, including both periods.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,246 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,041 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans