We are working on a CDS/DI project where we are moving products and product varians (Details) from D365FO to D365CE.

We are finding it very hard to do a lookup on a related entity.
1. task: We transfer Products, which is all good

2. task: We transfer Products Varians + a product number, to the related product. But we cant map this product number directly into to the Product Lookup field on the Product Varians entity. Does anybody know how to do a DBLookup (Scribe term) on the target side (D365CE)?