Override a lookup form in which I want to filter data based on a condition.

(3) Share

Report

Posted on by RB-13021145-0

I have a lookup form in dynamics 365 finance and operation with name InventItemIdLookupPurchase and this lookup form is for field "item id" in the form purchtable , so this lookup from contains 4 column item id, item name, product name and item group , so my requirement is I have to apply a range in my purchtable form in which items with item group "project" will not show in the lookup form.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (0)

Layan Jwei 8,023 Super User 2025 Season 2 on at

Like (0)

Report

Override a lookup form in which I want to filter data based on a condition.

Hi,

You will need to override the lookup method by code and add range for item group.

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,168 Super User 2025 Season 2 on at

Like (0)

Report

Override a lookup form in which I want to filter data based on a condition.

Hi,

The InventItemIdLookupPurchase form already has the required fields in the view InventTableExpanded and this table has all the required fields you mentioned. In the OnLookup event of the Itemid, you can add your required code and filter by Item group id.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 298,087 Super User 2025 Season 2 on at

Like (0)

Report

Override a lookup form in which I want to filter data based on a condition.

Hi,

You can override the lookup with your own lookup like explained by Peter Ramer in his blog: How To Override An Existing Lookup Method: Chain Of Command - Dynamics 365 Musings

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

Like (0)

Report

Override a lookup form in which I want to filter data based on a condition.

I don't understand the requirement. Why do you want to apply a range to PurchTable form if the form where you want to filter records is InventItemIdLookupPurchase?

Was this reply helpful? Yes No
Mohamed Amine Mahmoudi 26,304 Super User 2025 Season 2 on at

Like (0)

Report

Override a lookup form in which I want to filter data based on a condition.

Moved from FastTrack for Dynamics 365 form

Was this reply helpful? Yes No