Announcements
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.
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.
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
André Arnaud de Cal...
293,302
Super User 2025 Season 1
Martin Dráb
232,108
Most Valuable Professional
nmaenpaa
101,156
Moderator