How to filter D365 Modules by current company ?

(0) Share

Report

Posted on by Awaxx

229

Hi guys,

I got a table containing all modules going from parent module to childs items and their path.

I got the region code property field coming from this modules and other field like path, labeldid and so on.

Then i wanna use this table in a tree control but i wanna display only modules corresponding to current company like USMF.

My actual issue is to obtain the right modules only, cause i made a filter on region code field but some items are empty or some region code are shared between many items that i dont need.

Could you teach me a way to do it correctly ?

Thanksfully.

I have the same question (0)

All responses (18)

Answers (0)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Mack,

Are you using a standard table or have you created a custom table that contains data of all the modules?

Was this reply helpful? Yes No
André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Hi Mack,

What exactly is your definition of a module, parent module and child items? Is the parent module e.g. Accounts payable and Accounts receivable and a module Inquiries or Setup? Is a child item a menu item?

Was this reply helpful? Yes No
Awaxx 229 on at

Like (0)

Report

Hi Gunjan Bhattachayya

I'm using a custom table where i took all modules from the AOT with all parent nodes and child items.

Thanksfully.

Was this reply helpful? Yes No
Awaxx 229 on at

Like (0)

Report

Hi Andre Arnaud de Calavon

My definition of a Module is like :

Menu AOT Tree

Module (Parent) Accounts payable

Child Node ------------------------->Vendors

Child item ------------------------------------> all vendors

and so on ....

Maybe i'm wrong with the words, but it's my own understanding.

Thanksfully.

Was this reply helpful? Yes No
Awaxx 229 on at

Like (0)

Report

Nothing ??? No one to help ???

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

Like (0)

Report

So you're actually talking about a menu, right?

Can you elaborate your problem, please? You said: "My actual issue is to obtain the right modules only, cause i made a filter on region code field but some items are empty or some region code are shared between many items that i dont need."

But what do you mean by "some items are empty"? That they don't have a region code? It's a actually very simple case - they're used for all regions and therefore you won't filter them.

And of course that one region code can be used on many menu items. If it wasn't the case, it would mean that each country can have just a single country-specific menu item. What exactly do you mean by saying that you don't need them?

Was this reply helpful? Yes No
Awaxx 229 on at

Like (0)

Report
Hi goshoom

What i mean is that i wanna only collect the menu which appear on D365 when i set up the company on USMF. Actually its not the case.

To filter we used selection like this

(menusLocal.CountryRegionCodes == '') || (menusLocal.CountryRegionCodes != '' && strContains(menusLocal.CountryRegionCodes, SysCountryRegionCode::countryInfo(curext())))

Thanksfully.

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

Like (0)

Report

Can you tell us more about your problem, please?

For which menu item doesn't your code behave as expected and which of your codition fails to do the intended job?

By the way, are you talking about what system administrators see (or there are actually security restrictions applied_ and didn't you forget to take configuration keys into account?

Was this reply helpful? Yes No
Awaxx 229 on at

Like (0)

Report

I wanna get that result with all modules on USMF company

And for now i got that one in my form

So it's missing many menus like 'account payable' 'general ledger' ... and i got some menus that i don't need like 'landed cost' 'mixed reality' ....

The condition i wrote before seems to not get all the menus i need and i didnt understand why or how to do it differently.

Thank you goshoom for your time.

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

Like (0)

Report

Do you even get menusLocal for these menus?

I think that the problem is in your logic for getting the list of menus. Unfortunately you've never mention how you do it, therefore it's impossible for us to find the bug in the logic. You'll need to add the missing information.

Was this reply helpful? Yes No