
Hi everyone,
I am facing a persistent issue when trying to create a new product in Dynamics 365 Finance and Operations (F&O) synced via Dual-write to Dataverse/CRM.
Initially, I received the error shown in the attached file "Create New Item Error.jpg":
Request failed with status code PreconditionFailed and CDS error code: 0x80060892 response message: Entity Key Item Number and Company violated. A record with the same value for Company, item Number already exists.
(Note: The Item Number and Product ID are completely new and do not exist in either system).
Troubleshooting steps taken so far:
Stopped all related product maps, performed a Refresh tables, and restarted them in the correct sequential order (Distinct products -> CDS released distinct products -> DV Released distinct products -> DV Released products).
Checked unit configurations: The Units (uoms) map is running, and the units (like Pcs) are fully configured and matched in both F&O and CRM. Also verified that Unit conversions and Product specific unit conversions maps are active.
Modified the mapping of DV Released distinct products by unmapping the ITEMNUMBER field. This shifted the error to: BadRequest (0x80043b06): The specified product ID conflicts with the product ID of an existing record.
Reverted back to the Standard Version of the maps, ensuring all standard fields are intact, but the 0x80043b06 or 0x80060892 conflicts keep reoccurring on any newly generated GUID/Item Number.
My questions:
Since the data is unique and all relevant Unit and Product dimension maps are running on standard mappings, is this a known bug regarding Entity Keys or caching on the Dataverse side?
Does this require a full clean-up/re-indexing of the Integration Keys from the Power Apps/CRM side, or is there something missing in F&O?
Any guidance on how to resolve this synchronization conflict would be highly appreciated.