Dual write: Couldn't resolve the guid for the field: msdyn_globalproduct.msdyn_productnumber.

(1) Share

Report

Posted on by ..

1,965

Hi,

In FO, When running initial sync in dual write for this entity: "Released products V2 (msdyn_sharedproductdetails)"

I got this error:
Couldn't resolve the guid for the field: msdyn_globalproduct.msdyn_productnumber. The lookup value was not found: XXXXX. Lookup parententity: msdyn_globalproducts

And indeed this product exists in "released products" menu item in FO, but if i go to table "Global Products" in Power apps, then i don't find this value. But how I'm going to sync this value from FO - CE? There is no global product entity in FO.

The only entity in FO dual write that contains the word "product" is this one

And when I try to create a released product manually from FO, i get this error:
Unable to write data to entity msdyn_sharedproductdetails.Unable to lookup msdyn_globalproducts with values {gfhgf}.Writes to msdyn_sharedproductdetails failed

I have the same question (1)

All responses (2)

Answers (0)

Suggested answer

Komi Siabi 13,093 Most Valuable Professional on at

Like (0)

Report

There is indeed a corresponding FO entity for Global product. That's the All product.

Run initial sync for the mapping and ensure it is in running state.
See below on Dual write form.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,807 Most Valuable Professional on at

Like (0)

Report

F&O contains data entities for products (EcoResProduct table), not just released products (InventTable). For example, there is EcoResProductV2Entity.

Was this reply helpful? Yes No