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

(0) Share

Report

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)

All responses (2)

Answers (0)

Judy Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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:

Customize table and column mappings - Finance & Operations | Dynamics 365 | Microsoft Learn

Best Regards,

Judy

Was this reply helpful? Yes No
JP-05040630-0 12 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No