web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Dual-Write Update of currency in F&O order not reflecting in D365 Sales order, lines

(3) ShareShare
ReportReport
Posted on by 170
Subject: Dual-Write Currency syncing issues between F&O Sales order, lines & Dynamics 365 Sales order, lines: Update of currency in F&O order not reflecting in D365 Sales order, lines
 
Hi Guys,
 
Need your help. I have a requirement that when sales order is created in F&O and lines are added. It successfully sync b/w F&O and D365 sales. The currency is also mapped correctly. However when I change currency in F&O header (through F&O sales order form). Currency changes in F&O but in D365 sales (/ Dataverse) it don't change and nothing happen in sales. However if other fields (added in dual-write mapping) changed in F&O it reflects back in dynamics sales. 
 
Please advise which tables are necessary to accomplish above. Also I am wondering are there any other fields in F&O order and lines which need to be added in dual-write mapping to achieve above. We are mostly using default mapping of Dual-write for SO and SO lines tables. Currency field is there in mapping.
 
Note: We have synced the currency table. We haven't sync any other currency table like exchange rate etc.
 
Please provide help, highly appreciated.
 
Thanks
 
Ali
Categories:
I have the same question (0)
  • JessonCoock Profile Picture
    26 on at
    Check if the Currency Code field in both F&O and D365 Sales (Dataverse) is properly mapped in Dual-Write. Ensure that the related Currency Exchange Rate table is also synced, as it might be needed for correct currency updates.
  • Ali Hamza Profile Picture
    170 on at
     
    Sure, I will give it a try and will share the results here. Thanks for your suggestion. 
     
    Thanks
    Regards
    Ali

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Martin Dráb Profile Picture

Martin Dráb 45 Most Valuable Professional

#2
iampranjal Profile Picture

iampranjal 36

#3
Satyam Prakash Profile Picture

Satyam Prakash 31

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans