Skip to main content

Notifications

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

  • Linh_Nguyen Profile Picture
    5 on at
    RE: Cannot create a record in Fiscal calendar period (FiscalCalendarPeriod). The record already exists.

    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.

  • Verified answer
    DAnny3211 Profile Picture
    9,274 Moderator on at
    RE: Cannot create a record in Fiscal calendar period (FiscalCalendarPeriod). The record already exists.

    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

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,302 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,108 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans