Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Can we have additonal months and quarters in a fiscal calendar?

Posted on by 10

We have a requirement to extend the current fiscal year to 18 months from the standard 12 months previously setup. Historically our fiscal years run from July to June

We want to extend the current year by 6 months out to 03/01/2012 split into 18 months and 6 quarters.

Having researched, I believe the only way to adjust the years is to take the following actions (due the the fact we have already transacted in this financial year):

  • Create a new Financial Calendar
  • Replicate all the accounting years to date to match the current Financial Calendar
  • For the current year, in the new calendar, specify the same start date but make the end date the new desired date (03/01/2021)
  • In the Ledger setup switch the assigned financial calendar to the newly created calendar
  • Recalculate Ledger Period.

Please confirm this is the correct process and if there are any likely issues we will find as a result of recalculating the ledgers?

Queries:

When trialling this process in our test environment I found that despite having 18 periods, if it only possible to allocate the months and quarters based on the assumption that there is always 12 months and 4 quarters in a year. So we end up with multiple periods assigned to month 12 and quarter 4.

We ideally want to extend the months and quarters out to have month 13 to 18 and quarters 5 & 6.

Is this possible?

If not how would you recommend proceeding? Should we instead keep this year as a 12 month year an introduce a 6 month year to bridge the gap from July 2020 to December 2020.

  • Darren Crisp Profile Picture
    Darren Crisp 10 on at
    RE: Can we have additonal months and quarters in a fiscal calendar?

    Thanks again - If we create a 6 month bridging year then I assume we have to run through year end processes? Would we than have issue reporting on the year as 18 months becuase as far as AX is concerned they are 2 separate years?

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Can we have additonal months and quarters in a fiscal calendar?

    Hello Darren,

    Creating a new calendar from scratch and reassigning them (plus updating the period status) is probably the fastest and easiest option.

    Best regards,

    Ludwig

  • Darren Crisp Profile Picture
    Darren Crisp 10 on at
    RE: Can we have additonal months and quarters in a fiscal calendar?

    Many thanks for confirming Ludwig. Am I correct that if I do want to change the end dat of the current accounting year I have to recreate a new calendar from scratch and assign the new calendar in the ledger?

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Can we have additonal months and quarters in a fiscal calendar?

    Hello Daren,

    As you mentioned, a 'year' or group of account periods can only span 12 month.

    If you need a bridging year then you have to create a separate 'year' that spans the missing 6 months.

    That's how this is commonly handled.

    Best regards,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans