Dynamics Community Forum Thread Details

Filter Item Numbers in Purchase Requisition Based on Selected Mgf_Code

In the Released Products form, a new field named Mgf_Code has been added to the header section. The values for this field will be selected manually for each item number.

In the Purchase Requisition form, while creating a new purchase requisition, the Mgf_Code must be selected from a dropdown. Based on the selected Mgf_Code, when choosing an item number in the line section, the item number dropdown should display only those item IDs that are associated with the selected Mgf_Code.

Note: Mgf_code field is a customized field and data is manually given in custom form.

1. This is my custom form, where Mgf_Code records will be created.

2. In the Released products form, for every Item, the Mgf_Code is being selected from the dropdown.

3. For now, Mgf_Code ( MGF-01 ) has been mapped to these two Item Id's.

4. So now In Purchase Requisitions form, while we create new record, we select the Mgf_Code here.

5. After creating, in the Purchase Requisitions lines, when we add new line, the Item number dropdown should display only the Item Id's which is mapped to Mgf_Code.

( In our scenario, MGF-01 is mapped to Item Id AABT0001 and AABZ0001. So in the dropdown only these two Item Id's should appear. )