I am facing error while running dual write initial sync for the entity "CDS sales order lines V2", all the dependent entities are running and has been synced successfully.
Record Id: 93172a53-791c-4336-acf3-3784a75bb5f6, ErrorMessage: Reason: Bad Request, Header x-ms-client-request-id c20a6d9e-5d4a-4d7f-bad5-3880c7fce03c, The detail cannot be updated because the parent is not editable.
I really appreciate your support if you can provide any solution for this issue.
@hdn Hello, did you ever get anywhere with this?
we are facing the same issue with sales order line for any read only SO records.
I'm facing the same issue.
The detail cannot be updated because its parent cannot be edited.
This affects roughly 95% of all rows in SalesOrderLines V2. The rows that are actually exported successfully are those that are connected to a Sales Order that still has status "Open order". If the Sales Order has status "Invoiced" then I'm getting the error.
All related dual-write solutions and tables are updated and synced successfully.
Does anyone know how to address this issue? Is there a way to turn of the validation?
Do you have only one error for a single object or is it a bunch of errors? Identify the broken record in the system and analyze it. Is it possible to delete it and then recreate it somehow?
Try to distinguish whether this is a broken record issue or something related to the whole integration.
Stop your DW mappings for orders and order lines and delete them from the target system. Then start the initial sync process again.
Verify if you have the newest version of the Dual Write solution and mappings.
Check if you have any additional custom plugins/workflows/business rules/automations working on your Order and Order Lines.
There are two (old one and new one) approaches for the dual write Quotes/Orders, verify if you correctly set only one of them - partial enablement may cause troubles.
This forum is dedicated to general Power Apps topics, it may be beneficial to you if you publish your post on relevant Supply Chain or Dynamics CE/CRM community here;)
Good luck!
WarrenBelz
146,518
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,692
Most Valuable Professional