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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Product Master and configuration

(0) ShareShare
ReportReport
Posted on by 575

Hi Experts,

                     I am facing an issue we know that we can have configuration only forproduct subtype of product master for item but in my client environment they are having configuration for product.I believe that they have changed the item of product master in to product  which table they have updated ?

Product subtype field is an display method any help will be appreciated.

Please tell me the difference between Product and product master and configuration

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Sefa Duman Profile Picture
    1,167 on at

    Hi Micheal,

    There are lots of tables for products in AX 2012. The item data model underwent extensive normalization. AX uses new EcoRes... tables for product management. And most of these tables are inhereted from the other one. The base table is EcoResProduct. The items that's subtype is product master, is stored in EcoResProductMaster table. And the variants of this products are stored in EcoResDistinctProductVariant table.

    The items that's subtype is product is stored in EcoResDistinctProduct table. There is no "product subtype" field in any table. The "Product subtype" field indicates which type of record you're looking at (method EcoResProduct.productSubtype) - This just returns the type based on the value of the instanceRelationType, which determines the specific record type within the table hierarchy.

    Actually, it is not possible to change product subtype. You have to check these tables:

    -EcoResProductMaster

    -EcoResDistinctProductVariant

    -EcoResDistinctProduct

    For more details you can read this whitepaper:

    technet.microsoft.com/.../hh272877.aspx

    Best regards,

    Sefa Duman.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 10

#2
Harisgillani Profile Picture

Harisgillani 4

#2
dserp Profile Picture

dserp 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Liquid error: parsing "/blogs/post/?postid=%27nvOpzp;%20AND%201=1%20OR%20(%3C%27%22%3EiKO))," - Too many )'s.