Skip to main content

Notifications

Supply Chain Management forum
Unanswered

Dual write: Products from D365 Sales to F&O

Posted on by 35

Hello everyone,

for our client, the architecture of the solution that we are going to implement requires to export the products from D365 Sales to F&O.

To do that, I customized the standard "Released products V2" map, changing the synch direction for all the fields (by standard is F&O > Dataverse, I set the opposite), and I created a whole new map, connecting the F&O entity "Products V2" with the "Global products" table of D365 Sales.

The two maps are running OK, I did not receive any validation errors from F&O, and yet I am creating products in D365 Sales (successfully, no errors are given), but nothing happens in F&O, as if the data is not exchanged and the maps are not "feeded".

Has any of you had experience in such way of integration?
Am I missing something from the Dual Write maps standpoint?

Screenshot from the Released products map:

pastedimage1633420465220v1.png

Screenshot of the Products V2 map:

pastedimage1633420507716v2.png

  • Biswa88 Profile Picture
    Biswa88 50 on at
    RE: Dual write: Products from D365 Sales to F&O

    Hi Carlo,

    We are still unable to move any product data from CE to F&O. We have followed exactly the same mapping for the data entities you suggested, but we are nit yet successful. Could you please suggest any remediation? we disconnected and reestablished the link in dual write, but no joy. Could you please help where it can go wrong or what diagnosis we need to do.

    Thanks.

  • Biswa88 Profile Picture
    Biswa88 50 on at
    RE: Dual write: Products from D365 Sales to F&O

    Hi Carlo,

    Thanks again. Is there a way I can call you please or talk to you?

  • Gian Carlo Profile Picture
    Gian Carlo 35 on at
    RE: Dual write: Products from D365 Sales to F&O

    Hello Biswa88,

    Take a look at the integration keys setup, specifically for the "global product" table.

    The integration key you need is the "productnumber" only, not the company, because products are "cross-company" (in the screenshot below the names are in french because, i guess, our dataverse instance has french as predefined language; "produit mondial" = global product)

    pastedimage1639647886792v1.png

  • Biswa88 Profile Picture
    Biswa88 50 on at
    RE: Dual write: Products from D365 Sales to F&O

    Hi Carlo,

    we are still unable to bring any product data from CE (dataverse), even if we followed the 2 mappings and started a new map for product v2 from scratch. we did not get any mapping error nor anything in the activity log, all good there. The map run successfully but no data imported.

    So I suspect we are looking at the wrong tables in CE/dataverse to source the product data. We first tried the msdyn_globalproducts table- no mapping error, but no product import. However, when we tried to source from the products table, we got a mapping error of 'integration key'. I understand the product number in the products table of data verse is the concatenation of company and product number, but we don't have a field/column to map in the F&O side for the company name in the product v2 entity.

    Could you please help? What can be the challenge here?

  • Biswa88 Profile Picture
    Biswa88 50 on at
    RE: Dual write: Products from D365 Sales to F&O

    Thank you again. We will also have simple service items, so I am expecting similar mappings. Let me try and get back to you.

    Thanks.

  • Gian Carlo Profile Picture
    Gian Carlo 35 on at
    RE: Dual write: Products from D365 Sales to F&O

    Products_2B00_ReleasedProductsDualWriteMaps.docx

    Please find attached the maps that we are using. Note that our business scenario is quite simple, all the products that we are importing from Dynamics Sales are service items and they all share basic properties such as Item model group, Item group, storage dimension group, tracking dimension group: this is why we have so many defaults value in both maps.

  • Biswa88 Profile Picture
    Biswa88 50 on at
    RE: Dual write: Products from D365 Sales to F&O

    Also, you mentioned you had to adjust some mappings in the released product v2 mapping. What are those adjustments please?

    Thanks in advance

  • Biswa88 Profile Picture
    Biswa88 50 on at
    RE: Dual write: Products from D365 Sales to F&O

    Thank you for the quick response. We will try with 2 maps and update here. Also, do we need to carry out any other checks or steps such as any configurations etc. in F&O?

  • Gian Carlo Profile Picture
    Gian Carlo 35 on at
    RE: Dual write: Products from D365 Sales to F&O

    Hello Biswa88,

    I used two maps because as you know, to create a released product in F&O, you must first create the product: the first map (entity F&O = Products V2, entity Dataverse = Global products) is responsible for the creation of the product, while the second map (entity F&O = Released product V2, entity Dataverse = Shared products) creates the released product.

    That said, I honestly do not know how the Released product creation entity in F&O works.

    If the standard logic behind that entity creates the Product before creating the Released product itself, it would make sense to try and use just one map, otherwise my suggestion is to use two maps, one for the products, one for the released products

  • Biswa88 Profile Picture
    Biswa88 50 on at
    RE: Dual write: Products from D365 Sales to F&O

    Hello Carlo,

    Thanks for sharing your experience here, really helpful.

    we are trying to synch product data from D365 sales to D365 F&O. We used only one mapping 'Released product creation v2' , ran the map, but no product synchronized though 365 sales has good number of valid products. We even did not get any errors. From your post above, do we need to create two different maps and use those - Products V2 and released products v2? Is there any reason for that?

    Thanks in advance.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans