We have enabled dual write sync between F&O and CRM. For the sales orders, we use a table map CDS Sales Order Header < - > Order. Currently, we are planning on enabling the Intercompany feature, and came across one issue when confirming an sales quotation and converting it into an sales order.
Namely, if it is a IC sales order, then both the sales order and the intercompany order are getting synced to CRM from F&O, which is not our use case (we need only the sales order).
We have extended the mapping in Dual write with the IntercompanyOrder field from the SalesTable (NoYes enum), and added it in the query as: INTERCOPMANYORDER == NoYes::No , but this still havent prevented the sync of the IC orders. I can see that the field is correctly mapped in the table map (it is synced correctly from F&O), but the query doesn't really work, at least not On Create.
Is there any way to do this through Dual write at all? It would really reduce the amount of unnecessary data being synced.
Thanks
