Procurement category tree look up

(1) Share

Report

Posted on by RSX

204

Hi,

The requirement is to get the tree look up procurement category which is available in prodtable form into my custom form.
I have added the int64 field and have given relation with ecorescategory.recid.
I have written in form datasource's field methods: resolvereference() and lookupreference().
I have followed similar to: https://www.youtube.com/watch?v=abf4IGAVVm0

But I'm unable to see tree look up and it just displays normal look up of record id. what am I missing here?

I have the same question (0)

All responses (10)

Answers (2)

Martin Dráb 237,990 Most Valuable Professional on at

Like (0)

Report

When you say "which is available in prodtable form", which form control in ProdTable form do you mean?

Was this reply helpful? Yes No
RSX 204 on at

Like (0)

Report

Hi,
My bad, it is in purchtable form, Field name is "Procurement category", control : PurchLine_ProcurementCategory

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,990 Most Valuable Professional on at

Like (1)

Report

To see how it's implemented for ProcurementCategory in PurchTable form, expand PurchLine data source, then ProcurementCategory field and open lookupReference() method. There you'll see a call of EcoResCategory::lookupCategoryHierarchyRole(), which is what you'll need.

Was this reply helpful? Yes No
RSX 204 on at

Like (0)

Report
I've written the methods as following, still unable to get the tree look up.
public Common resolveReference(FormReferenceControl _formReferenceControl) { Common ret; ret = EcoResCategory::resolveCategoryHierarchyRole(_formReferenceControl,EcoResCategoryNamedHierarchyRole::Procurement); return ret; } public Common lookupReference(FormReferenceControl _formReferenceControl) { Common ret; ret = EcoResCategory::lookupCategoryHierarchyRole(_formReferenceControl, EcoResCategoryNamedHierarchyRole::Procurement); return ret; }

Was this reply helpful? Yes No
Martin Dráb 237,990 Most Valuable Professional on at

Like (1)

Report

Is your control a reference group? Or Int64Edit?

Was this reply helpful? Yes No
RSX 204 on at

Like (0)

Report

It is an Int64 Edt.

Was this reply helpful? Yes No
Verified answer

RSX 204 on at

Like (0)

Report

Hi Martin,

I removed the int64 control and used reference group and it works well now.

Thank you.

Was this reply helpful? Yes No
Martin Dráb 237,990 Most Valuable Professional on at

Like (0)

Report

Good to hear that problem is resolved. Please don't forget to verify the answer (mark the reply or replies that form the answer).

Was this reply helpful? Yes No
RSX 204 on at

Like (0)

Report

Hi
I've tried to verify the answer. But the page just keeps loading and doesn't mark it. I've tried it for 2 days. Still its not getting marked.

Was this reply helpful? Yes No
Martin Dráb 237,990 Most Valuable Professional on at

Like (1)

Report

Unfortunately, there is a bug that apparently hasn't been fixed yet. :-(

Was this reply helpful? Yes No

Join the conversation

Community site session details

Procurement category tree look up

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Procurement category tree look up

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates