
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)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.