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:
Screenshot of the Products V2 map:
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.
Hi Carlo,
Thanks again. Is there a way I can call you please or talk to you?
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)
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?
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.
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.
Also, you mentioned you had to adjust some mappings in the released product v2 mapping. What are those adjustments please?
Thanks in advance
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?
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,818 Super User 2024 Season 2
Martin Dráb 229,147 Most Valuable Professional
nmaenpaa 101,156