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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Dual Write - Products
Finance | Project Operations, Human Resources, ...
Unanswered

Dual Write - Products

(0) ShareShare
ReportReport
Posted on by Phil Matthews

Good morning,

I'm having some trouble synchronizing Products from CRM to FO using dual write and vice versa. What I would actually like is to create products in CRM and sync to FO, but I cannot get the sync to work either way.

I've tried using the following maps:

  • All products (msdyn_globalproducts) - completes the initial sync from FO to CRM with 289 Upserts and no errors, but no products are listed in CRM. Map enters the running state and does not sync any new products.
  • CDS Released distinct products (products) - Initial sync runs, but does not transfer any products regardless of which is the master. Mapping runs, but doesn't do anything when running.
  • Released Products V2 (msdyn_globalproducts) - Initial sync runs, but does not transfer any products regardless of which is the master. Mapping runs, but doesn't do anything when running.

Does anyone have this working and are able to advise which entity maps they used, or failing that, advise of which entities I should link in a custom map please?

  • Needles.one Profile Picture
    Needles.one on at
    RE: Dual Write - Products

    Hi Phil,

    I just managed to sync products in my Tier 1 environment from F&O to CRM by syncing according to white papers here learn.microsoft.com/.../product-mapping in the following order: CDS released distinct products > Released products V2 > All products. Give it a try.

  • Phil Matthews Profile Picture
    Phil Matthews on at
    RE: Dual Write - Products

    Hi, thank you for your response. I've enabled the mappings in the order that you've suggested and can now sync released products from FO to CRM, but not from CRM to FO.

  • Needles.one Profile Picture
    Needles.one on at
    RE: Dual Write - Products

    That's correct, Phil. Straight from the official documentation:

    The dual-write table maps for products have been designed to flow data one-way only, in near-real time from finance and operations apps to Dataverse. However, the product infrastructure has been made open to make it bi-directional if required. Although you can customize it, it's at your own risk, as Microsoft does not recommend this approach.

  • Phil Matthews Profile Picture
    Phil Matthews on at
    RE: Dual Write - Products

    Thank you. As the EcoResReleasedDistinctProductCDSEntity entity is read only, I would assume that best practice is to create a custom map from Released Products V2 to Products or something along those lines?

  • Needles.one Profile Picture
    Needles.one on at
    RE: Dual Write - Products

    Yes, you can find more details about dual-write customization best practices here learn.microsoft.com/.../custom-best-practices

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans