Production order pool filtering based on Finished Goods

(2) Share

Report

Posted on by faiz7049

2,430

Hi Experts,

Customer requirement to filter pool lookup based on Production order finished goods ItemId. Like if Finished itemId group is "301" then only pool shows PET in lookup.

Should I have to create Table include field PoolId,ItemGroup extended data type. How to filter pool lookup based on Finished goods itemid selection while creating Production order.

Thanks,

Faiz

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

André Arnaud de Cal... 304,711 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Faiz,

Firstly, indeed you need a table with a relation between item groups and production pools. Then you can create an override for the lookup. You can probably get some help on how to do this by reading the next blog: AX / D365FO – How to: Add a Lookup Form to a Control in X++ – AX / Dynamics 365 For Finance and Operations blog

Was this reply helpful? Yes No
faiz7049 2,430 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

I have created a table with fields ItemGroup and Pool. Now I need to know how to pass queryBuildRange.value('FGPET') when corresponding ItemId selected in production control.

Thanks,

Faiz

Was this reply helpful? Yes No
faiz7049 2,430 on at

Like (0)

Report
Copy link

Link copied!

Hi Experts,

I want to filter in lookup from Table SFA_Production_Pool based on field Identification_ItemId on form ProdTableCreate.
Problem is how to get itemgroupid from field Identification_ItemId.

Thanks,

Faiz

Was this reply helpful? Yes No
faiz7049 2,430 on at

Like (0)

Report
Copy link

Link copied!

Hi Experts,

The Form is ProdTableCreate and Control Name is Identification_ItemId . I am trying to get ItemId from Control Name Identification_ItemId.

Could you please help me.

Thanks,

Faiz

Was this reply helpful? Yes No
Verified answer

faiz7049 2,430 on at

Like (0)

Report
Copy link

Link copied!
Thank you Working with below code.

FormDataSource prodFormDataSource = formRun.dataSource(tableStr(ProdTable));

Was this reply helpful? Yes No