While converting a Quote into an Order in D365 CE Sales, I was receiving an error message that went like:
Dual Write core application error-Dual Write core application error-Unable to write to Finance and Operations apps due to following error(s): {"Write failed for entity CDS sales order lines V2 with unknown exception - Inventory dimension Site is mandatory and must consequently be specified.\nUpdate has been canceled."} Please rectify your data and try again. If issue persists after multiple retries, please contact your system administrator.
Since dual write is seamless integration and data synchronization across D365CE and D365FO and as the default shipping site and warehouse is required while creating the Order in F&O, we need to ensure that the value is populated prior to creating the Sakes Order.
Solution
While encountering an error can be frustrating, the good news is that there is a solution.
In this case, the remedy involves performing relationship mapping between the Quote and Order entities. Relationship mapping essentially defines how data is transferred between related entities.
Steps:
- Open the solution in D365 Sales App. Ensure you've added the following components:
- Quote and Order tables
- 1:N relationship between Quote and Order
- Open the relationship and click on Relationship Mapping
- Add a new Map and select Default Shipping Site and Default Shipping Warehouse.
- Now try to convert the Quote into an Order.
It should be smooth sailing now.
Hope that helps!
