News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Each Month of a Fiscal...

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

Answered

Each Month of a Fiscal Year

(0) Share

Report

Report

Posted on by JE-29041340-0

378

Hi:

Does FY[1] mean January, FY[2} mean February, FY[3} mean March, etc.?

If not, please explain.

Thanks!

John

Categories:

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

YUN ZHU 77,981 Super User 2025 Season 1 on at

Like (1)

Report

Each Month of a Fiscal Year

Hi, this is the meaning of Fiscal year, here is the MS official document, hopefully it will give you some help as well.

FY: Fiscal year. For example, FY[1..3] denotes the first quarter of the current fiscal year.

https://learn.microsoft.com/en-us/dynamics365/business-central/bi-how-work-account-schedule?wt.mc_id=DX-MVP-5004336#comparing-accounting-periods-using-period-formulas

Thanks.

ZHU
Verified answer

Valentin Castravet 26,349 Super User 2025 Season 1 on at

Like (1)

Report

Each Month of a Fiscal Year

Yes you are correct if you are using it in Financial Reporting (old Account Schedules Page) -> Column Layout -> Comparison Period Formula Field.

Take a look at this website as its very helpful for Financial Reporting date formulas. It was created in the Dynamics NAV days but the formulas still apply - Account Schedule Formulas | Dynamics NAV Financials

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,375 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans