Microsoft Dynamics AX

Forums

Home » Microsoft Dynamics AX » Microsoft Dynamics AX Forum
Related Search Results

Copy, Set, Delete, Get Product Categories and Attributes in AX 2012 X++

by
on 22 Mar 2013
  • 0 comments

Get Product Attribute Values in AX 2012 - Let's Code!

by
on 14 Jan 2013
  • 0 comments

AX2012 Which way to create relations

by
on 14 Jun 2012
  • Not Answered
Troubleshooting an Issue?

Our support engineers have assembled the top recommended solutions for you.

Microsoft Dynamics AX 2012

CRM Connector in Microsoft Dynamics AX 2012

Financials Management in Microsoft Dynamics AX 2012

Upgrading to Microsoft Dynamics AX 2012


Microsoft Dynamics AX 2009

Application Object Server (AOS)

Enterprise Portal and Role Centers

Inventory Costing in Microsoft Dynamics AX 2009 

 Invoice Settlements/Discounts/Reversals

 SSRS and SSAS Integration

 Workflow

Add existing product category, product attribute and product attribute value to a product with x++

This question is not answered
EduardoAndres
Posted by
on 20 Jan 2013 1:15 PM

Hi there!

I'm having some issues trying to "set" an existing Category Hierarchy, Category, Product Attribute and Product attribute value in X++ at the moment I create a new ecoResProduct record.

I have the product created and released to AX, I just need to set these values automatically. In addition, I also know how to get these values (http://axwonders.blogspot.com/2013/01/get-product-attribute-values-in-ax-2012.html) but I just can't set them at run time.

I have tried to insert independent pieces of records to the following tables:

EcoResValue (The recId of the existing attribute value, Instance Rel Type and Rel type)

EcoResValueAttribute (Value = the EcoResValue Rec Id and a fix attribute and the rec id of he InventTable rel type)

The above does not work and somehow the data is not reflected in the view EcoResProductAttribute value, which I think is th responsible for displaying the correct relationship of categories and product attributes.

Is anyone doing this? If so, would it be possible to get some sample code for it?

Thanks a lot!

 
All Replies
  • FH-Inway
    Posted by
    on 21 Jan 2013 4:38 AM

    Hi,

    you could take a look at form EcoResAttributeValue and the logic in the methods there, especially createValue und attributeChanged to get an idea how to create these records.

    Other than that I assume your problem is with the attribute values and you are able to create the other records to associate a category from a category hierarchy to a product and associate product attributes. Please also note that not all category hierarchy roles support product attributes.

    Best regards

    FH
  • EduardoAndres
    Posted by
    on 21 Jan 2013 10:11 AM

    Thanks for the reply. I have looked at those methods and basically what they do is "add" a new value to a category and/or product attribute, but theydo not create the relationship between product and attributes that I'm looking for.

    Thanks again.
  • FH-Inway
    Posted by
    on 25 Jan 2013 4:10 AM

    Hi,

    please note that you can only add values to an attribute, not a category. To create a relationship between a product and an attribute, you would first have to create a relationship in table EcoResProductCategory between the product and a category and then a relationship between the category and the attribute in table EcoResCategoryAttribute.

    Take into consideration that method init of data source EcoResCategory in form EcoResAttributValue filters the available attributes to those of procurement (and retail, if you have installed Feature Pack) category hierarchies.

    Best regards

    FH