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 :
Small and medium business | Business Central, N...
Suggested Answer

Dimension Set ID already exists error

(4) ShareShare
ReportReport
Posted on by 8

We are repeatedly encountering an error related to Dimension Set Entries in Microsoft Dynamics 365 Business Central Version 25 (On-Premises).

The error message “Dimension Set ID already exists” occurs in the following scenarios:

  • When uploading data through Configuration Packages.

  • When manually entering dimensions in the Purchase Journal, the system does not allow us to enter the dimensions and displays the same error.

We are unable to identify the root cause of this issue. Any suggestions or insights into resolving this issue would be greatly appreciated.

 

  • Suggested answer
    Nyakinyua Profile Picture
    139 on at

    This indicates a conflict where the system attempts to create dimension set entry combination that already exist. What would help is to know the origin of the error, which action generates the error. If it is the standard process?, which page is it, if it is from a custom page or a configuration import. 
    Steps you can check.
    Check for duplicate, dimension value combinations should be unique.
    Based on the source of error you can also,
    Review the import logic, if it is custom or configuration file, avoid using the same entry id.
    If it is custom process, always make sure the database is synchronized to get the latest version of tables used.
    Lastly, you can review the dimension set id for any orphaned data or duplicate data existing in the table.
     

  • AndrewThomas81 Profile Picture
    3,289 Super User 2026 Season 2 on at

    Is this when entering a journal via the UI, config pack, or edit in excel?

     

    Kind Regards 

      

    Andrew Thomas FCCA MCP 

    YouTube - Use Business Central 

    LinkedIn 

     

    If you found my answer useful, please mark it as verified  

  • Suggested answer
    OussamaSabbouh Profile Picture
    20,851 Super User 2026 Season 2 on at

    Hello,
    This is not a normal dimension setup error. Business Central generates the Dimension Set ID automatically: table 480 Dimension Set Entry stores the combinations, while table 481 Dimension Set Tree Node searches/creates them and its Dimension Set ID is AutoIncrement. Since the same error also occurs during manual journal entry, I would suspect an inconsistency between tables 480/481 or the SQL identity/AutoIncrement value, possibly introduced during an upgrade, migration, direct SQL change, or importing system-generated Dimension Set IDs. First, make sure your Configuration Package does not import tables 480/481 or manually populate Dimension Set ID; let BC generate it from the dimension values. Because this is on-premises, take a database backup and have your technical partner compare tables 480/481 and verify the identity value for table 481 against the existing IDs. Do not delete or renumber dimension-set records directly in SQL, because Microsoft explicitly states these tables shouldn't be changed; if inconsistency is confirmed, repair it first in a copy of the database or raise it with Microsoft support.

    Regards,
    Oussama Sabbouh

  • CU12101249-0 Profile Picture
    2 on at

    I have seen a similar issue caused by inconsistency between Dimension Set Entry (Table 480) and Dimension Set Tree Node (Table 481).

    Business Central uses Table 481 as a search tree when GetDimensionSetID determines whether a dimension combination already exists. If the tree contains invalid/orphaned nodes, BC may return or attempt to create an incorrect Dimension Set ID, resulting in the “Dimension Set ID already exists” error.

  • Suggested answer
    Yash_Mistry Profile Picture
    648 Super User 2026 Season 2 on at

    Hello @BT-09100741-0 ,

    The error is related to something triggering the same dimensions to be inserted into the table again.

    Since you are using a Configuration Package, could you please check whether the records you are inserting, either directly or indirectly, are affecting the Dimension Set Entry table?

    Also, as you mentioned that the same error occurs when assigning dimensions in the Purchase Journal, I would recommend copying the complete error details and sharing them here. The call stack can help identify what is triggering the error and provide more insight into the root cause.

    If this answer was helpful, please mark it as Verified.

    Thanks,  
    Yash Mistry

  • Suggested answer
    YUN ZHU Profile Picture
    104,121 Super User 2026 Season 2 on at

    Please check the data in Table 480 'Dimension Set Entry' to see if there are any conflicts with the data you need to import. You will need to modify one of them before you can proceed with the import.

    More details:

    https://learn.microsoft.com/en-us/dynamics365/business-central/design-details-dimension-set-entries-overview?wt.mc_id=DX-MVP-5004336

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 645 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 432 Super User 2026 Season 2

#3
Teagen Boll Profile Picture

Teagen Boll 248 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans