News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Add Product category H...

Finance | Project Operations, Human Resources, ...

Suggested answer

Add Product category Hierarchy to form

(0) Share

Report

Report

Posted on by AhmedSaeed

379

Hi,

i need to lookup product Hierarchy in a new form field

All responses Img

All responses (2)

Answers Img

Answers (0)

AhmedSaeed 379 on at

Like (0)

Report

RE: Add Product category Hierarchy to form

Hi , i solved the problem by add a new control (Reference Group ) and override Lookup Reference

method and add the below code :

public Common lookupReference()

{

Common ret;

EcoResCategory ecoResCategoryLocal;

EcoResCategoryHierarchy categoryHierarchy ;//= EcoResCategoryHierarchy::find(ecoResProductCategory.CategoryHierarchy);

select firstonly categoryHierarchy;

ret = EcoResCategory::lookupCategoryHierarchy(this,

categoryHierarchy);

if (ret.TableId == tableNum(EcoResCategory))

{

ecoResCategoryLocal = ret.data();

// update the current Category hierarchy if selected category belongs to another hierarchy.

if (ecoResCategoryLocal.RecId &&

ecoResCategoryLocal.CategoryHierarchy != ecoResCategoryLocal.CategoryHierarchy)

{

ecoResCategoryLocal.CategoryHierarchy = ecoResCategoryLocal.CategoryHierarchy;

}

}

return ret;

}
Suggested answer

DynamicsAXAbdu 205 on at

Like (1)

Report

RE: Add Product category Hierarchy to form

Hi Ahmed,

Here is an example for you. Maybe you use this as reference and create your own code

https://axfactory.wordpress.com/2015/06/14/product-category-hierarchyproduct-categories-tree-lookup-in-ssrs-report-dialog-ax2012/

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2

Martin Dráb 231,991 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans