SBX - Search With Button

SBX - Forum Post Title

Product Variant Creations Error. (EcoResProduct)

Microsoft Dynamics AX Forum

KHAWAJA MUHAMMAD BILAL asked a question on 14 Sep 2018 1:40 AM
My Badges

Question Status

Verified

Dear Experts,

We are facing an error at creation of product variant "Cannot create a record in products(EcoResProduct). The Record already exist".

Suppose:

This is already available variant

Configuration

Size

Color

Style

LAB TEST REPORT (METAL/FERROUS)

8.5" X 11"

(WHITE,YELLOW)

DUPLICATE PAPER 50

and we want this new variant just style changes

Configuration

Size

Color

Style

LAB TEST REPORT (METAL/FERROUS)

8.5" X 11"

(WHITE,YELLOW)

DUPLICATE PAPER 50 , IMPORTED PAPER 70 GRM

This is image of error:

Reply
Rustem Galiamov responded on 14 Sep 2018 3:05 AM
My Badges
Suggested Answer

In EcoResProduct table DisplayProductNumberIdx is unique index which contain only DisplayProductNumber field. Check the DisplayProductNumber of new product variant and existing product variant.

Reply
KHAWAJA MUHAMMAD BILAL responded on 14 Sep 2018 7:57 AM
My Badges
Verified Answer

Well Done Team,

Issue Resolved,

Issue was that "EcoResProduct" table EDT length was 70. When we were creating same variants below 70 characters error was occurring. We have increase characters length up to 200 then issue resolved. 

Table Image:

Reply
KHAWAJA MUHAMMAD BILAL responded on 14 Sep 2018 7:57 AM
My Badges
Verified Answer

Well Done Team,

Issue Resolved,

Issue was that "EcoResProduct" table EDT length was 70. When we were creating same variants below 70 characters error was occurring. We have increase characters length up to 200 then issue resolved. 

Table Image:

Reply
Rustem Galiamov responded on 14 Sep 2018 3:05 AM
My Badges
Suggested Answer

In EcoResProduct table DisplayProductNumberIdx is unique index which contain only DisplayProductNumber field. Check the DisplayProductNumber of new product variant and existing product variant.

Reply

SBX - Two Col Forum

SBX - Migrated JS