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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / How to manage dual-syn...
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

How to manage dual-sync when data is saved to multiples tables from staging table

(0) ShareShare
ReportReport
Posted on by Community member

We don't have rights to make any changes in Finance and Operations (F&O), Is it possible to manipulate the data of tables??

Scenario :- we have to sync the dataverse table with F&O where we have line table. It's data is divided into three tables i.e. line table, transaction table and line week. We have setup the mapping of Lines and transaction table but unable to map for the Lineweek table as it is not showing in F&O.

Please help me regarding this

I tried to map Line and transaction table and run these tables simultaneously but there are some field in which data is not populated.

I have the same question (0)
  • Judy Profile Picture
    Judy Microsoft Employee on at
    Hi,
     
    Can you check the table mappings for Line, Transaction, and Lineweek tables. Ensure that the mappings are correctly set up and that the fields are properly mapped between Dataverse and F&O.
    The reference Document:
     
     
    Best Regards,
    Judy
  • JP-05040630-0 Profile Picture
    JP-05040630-0 12 on at
    Since I do not know the exact data you are trying to sync. @Judy in the thread is on the right track and there are a lot of resourses about DualWrite on Microsoft Learn. 

    When you set up DualWrite you are syncing Entities and not tables between Finance and Operations and Dataverse. In order to sync an entity from Dataverse/CRM to Finance and Operations, there needs to be an entity on the Finance and Operations side where the data lands when syncing. If the "Line Week" is a custom entity in CRM/Dataverse you will need to build it in Finance and Operations.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
Pallavi Phade Profile Picture

Pallavi Phade 102 Super User 2026 Season 1

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 55 Super User 2026 Season 1

#3
ManoVerse Profile Picture

ManoVerse 53 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!
Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans