You’re offline. This is a read only version of the page.
12
Hi everyone,
I’m facing an issue with Dual-write between CRM and F&O (Finance and Operations).
Scenario:
Entity: SalesOrderHeaderV2
Field: TOTALDISCOUNTPERCENTAGE mapped to CRM field Order Discount (%)
Dual-write is bidirectional. and tried one way from CRM to F&O
Problem:
Orders created in CRM with discount % (e.g., 10%) arrive in F&O, but TOTALDISCOUNTPERCENTAGE shows 0.
The field is editable in the entity (Editable = Auto) and I can manually change it in F&O without issue.
Dual-write sync runs successfully, no errors in Execution history.
If I change the mapping to One-way (CRM → F&O), the field still does not update.
Other discounts applied via Trade agreements or Amount fields in F&O are reflected correctly; the problem is specifically with the % coming from CRM.
What I tried:
Verified SalesOrderHeaderV2 entity mappings.
Checked that the field is editable in F&O.
Manual edits in F&O work.
Exporting via Data management shows DiscPercent = 0 for these orders.
Question:
Has anyone successfully synced the TOTALDISCOUNTPERCENTAGE from CRM to F&O Sales orders?
Do I need a custom X++ Extension to allow writing this field directly?
Any recommended best practices for syncing discount % from CRM to F&O via Dual-write?
This is a common scenario is you will use bi-directional dual write.
You may need to write code on entity. When data is created from CRM or Dataverse using Dual Write and you don't have code in entity, the system defaults data/login from standard FNO code.
Please try to put debugger here in salesTable method initFromSalesTable code ( this.DiscPerecent = salesTable.DiscPercent)
Check wether data is getting wiped out here.
#1
Sohaib Cheema
878
User Group Leader
#2
André Arnaud de Cal...
681
Super User 2025 Season 2
#3
Martin Dráb
496
Most Valuable Professional
Share
Report
All responses (
Answers (
