web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Cannot create a record in Fiscal calendar period (FiscalCalendarPeriod). The record already exists.

(0) ShareShare
ReportReport
Posted on by 5

We need to add fiscal year 2025 to an existing fiscal calendar. But Fiscal calendar period 2025 cannot be created.

The following error message is shown:

"Cannot create a record in Fiscal calendar period (FiscalCalendarPeriod). Period name: Period 0, 1/1/2025.
The record already exists."

We checked and this fiscal year is not existing yet. Please see the screenshots below.

pastedimage1677650216418v1.png

pastedimage1677650228184v2.png

pastedimage1677650280047v3.png

I have the same question (0)
  • Verified answer
    DAnny3211 Profile Picture
    11,407 Super User 2026 Season 1 on at

    hi

    The error message "Cannot create a record in Fiscal calendar period (FiscalCalendarPeriod). The record already exists." indicates that there is already a record in the FiscalCalendarPeriod table with the same combination of fiscal year, period type, and period number that you are trying to create.

    To resolve this issue, you need to identify the existing record in the FiscalCalendarPeriod table that is causing the conflict. Here are the steps to do this:

    Open the AOT (Application Object Tree) in Dynamics AX.

    Navigate to the Data Dictionary > Tables node.

    Find the FiscalCalendarPeriod table in the list of tables and open it.

    Use the Find function to search for the record that is causing the conflict. You can search by fields such as Calendar, FiscalYear, PeriodType, and PeriodNumber to narrow down the search.

    Once you've identified the existing record, compare its details to the record you were trying to create to determine if there are any differences that may be causing the conflict.

    If necessary, update the record you were trying to create with the correct details and save it again.

    It's also possible that the error message is caused by a synchronization issue. In this case, try synchronizing the table to ensure that all records are up to date.

    Daniele

  • Linh_Nguyen Profile Picture
    5 on at

    Hi Danielle, thanks for the answer!

    As you said, the problem was the Period name field. I don't know why, but the default period name format (Period 0, Period 1, Period 2, etc) was counted as already exists, so the user had to change it to a different format (for example, 2024-00 instead of Period 0). After we change all values in Period name field, we were able to create the next fiscal year 2025.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 509 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 375

#3
Adis Profile Picture

Adis 268 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans