Dynamics Community Forum Thread Details

Data not populating in Retail Supplemental Hierarchy

Hi all,i am adding data through import in Supplemental retail hierarchy under products using this code(main part written here),
although the data inserted in EcoResProductCategory Table,but is not showing in Grid(Screenshot Attached),dont know why,also you people know,product,
product variant etc are reference group field in RetailGroupMemberLine Table.I dont know much about reference group field,as far as i know i am 
inserting data in EcoResProductCategory Table,should show data in grid in RetailGroupMemberLine due to relation.Any one please guide me why is data
not coming in grid.

EcoResProductCategory   newEcoResProductCategory;
    EcoResProductCategory   selectedEcoResProductCategory;

    select firstonly RecId from selectedEcoResProductCategory
        where selectedEcoResProductCategory.CategoryHierarchy == _ecoResCategory.CategoryHierarchy
            && selectedEcoResProductCategory.Product == _ecoResProduct.RecId;

    if (selectedEcoResProductCategory.RecId == 0)
    {
        newEcoResProductCategory = null;
        newEcoResProductCategory.initValue();
        newEcoResProductCategory.Category           = _ecoResCategory.RecId;
        newEcoResProductCategory.CategoryHierarchy  = _ecoResCategory.CategoryHierarchy;
        newEcoResProductCategory.Product            = _ecoResProduct.RecId;
        newEcoResProductCategory.insert();
    }
    else
    {
        error (strFmt("@RET260198",
                    EcoResProduct::find(_ecoResProduct.RecId).productName(),
                    EcoResCategoryHierarchy::find(_ecoResCategory.CategoryHierarchy).Name));
    }

Quick Links