Microsoft Dynamics 365 Business Central sync error: The record in table Dimension Value already exists. Identification fields and values: Dimension Code='BUSINESS GROUP',Code='XXXXX'

Why the sync error occurs

This error occurs when a department or class is trying to sync from Cashflow360 to Microsoft Dynamics 365 Business Central (MSDBC), but the class or department ID already exists in MSDBC.

How to fix the sync error

Change the department or class ID in Cashflow360.

  1. Select Settings
  2. Select Classifications under Accounting
  3. Select Departments or Classes
  4. Select the department or class named in the error
  5. Enter a unique ID, and select Save
  6. Sync again