web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Help Needed: Variant e...
Microsoft Dynamics AX (Archived)

Help Needed: Variant entity of Data Import Export Module

(1) ShareShare
ReportReport
Posted on by fatihgork 3,817

Hello everyone,

Sorry for the low quality screenshots, it is because of the file upload limit.

Long story short:

How to use the Variant entity in DIEF module?

There is a mandatory field named RetailVariantId. I can not make it auto generated, or give AX the next number in number sequence manually. (I found a thread about RetailVariantID here, thanks to Pavel C. Ondreicsik but, this information could not solve the issue I am facing with.)

Either way it tells me:

8510.1.gif

This is the staging-target mapping:



5857.2.gif

Entity structure:


4300.3.gif

 

The actual long story :) 

I am trying to do a complete run of importing products by using the standart DIEF module.

First I tried to create a product master with using the Product Master entity but, AX kept giving me errors about number sequences, I worked on it pretty hard. Could not solve the issue, so I tried my chance on Product entity and succeeded. 

Now I have a released product master with no released variants (No existing InventDimCombination for this item)

So, now I am trying to define variants with using the variant entity. And struggling with the problem written at the beginning of this post.

Environment

Application version: AX 2012 R3 CU8.

With no development at all. This environment is brand new.

Thanks.

*This post is locked for comments

I have the same question (0)
  • fatihgork Profile Picture
    fatihgork 3,817 on at

    Hello all,

    I have solved this issue.

    I will post the solution here soon.

  • Verified answer
    fatihgork Profile Picture
    fatihgork 3,817 on at

    Hello all,

    I delayed my reply because I wanted to make sure it works in all areas that I can test it.

    When you click auto generate for RetailVariantID field, and hit the "view staging data" button in processing group, it gives an error saying the number sequence does not exist.

    But if you ignore this exception and go ahead, get your data into staging and get it to the target you will see it inserts records without any exception.

    So it should just be ignored because it actually gets the next number from the right number sequence.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
GL-01081504-0 Profile Picture

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans