Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Import issue product v...
Finance forum
Under review by Community Managers

Under review

Thank you for your post! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Import issue product variants with custom dimensions

Posted on by
Hi all,
 
Hope somebody could give an idea regarding a problem in D365fo that I am facing for weeks now.
 
In our team we have developed custom product dimensions in exactly the same manner as the standard ones.
Now we want to import product variants using Data Management framework. At first I tried to extend the data entity 'Product variants V2', however due to private methods in the existing data entity, I had to copy the data entity into another model and rename some stuff like entity name, staging table name, etc. 
Now while testing this /extended/ data entity, the import of the standard dimension values like product size works well, however custom product dimension values are not being imported, resulting in an import error like /Value provided for product dimension 'Brand' is invalid/. 

This error is generated on table method 'defaultFieldRetailWeight()' of table 'EcoResProductVariantBrand'. (Set up in the same way as e.g. 'EcoResProductVariantColor')
When the process enters this function the table buffer should already have been supplied with a record, but in my case it has not. I can see the entity record contains the correct data. Also the field mapping seems to be done correctly as far as I can judge. At some point the data transfer is done from the staging table c.q. entity record to the datasource buffer and something goes wrong here for the newly created product dimensions, but I have not found yet what exactly fails. All product dimensions have been added to all relevant methods. Product dimension fields are added to the relevant table groups. I can create product variants without problems using the product variants form. The export function for product variants runs fine, including the custom fields... Only the import via Data Management Framework is giving me this error.
 
I hope this describes my problem a bit. 

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... 291,602 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,340 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans