Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

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

(1) ShareShare
ReportReport
Posted on by 57
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:
  • Ali Hamza Profile Picture
    Ali Hamza 57 on at
    Dual-Write Update of currency in F&O order not reflecting in D365 Sales order, lines
     
    Sure, I will give it a try and will share the results here. Thanks for your suggestion. 
     
    Thanks
    Regards
    Ali
  • JessonCoock Profile Picture
    JessonCoock 22 on at
    Dual-Write Update of currency in F&O order not reflecting in D365 Sales order, lines
    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.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans