Dynamics Community Forum Thread Details

Filter StandardDialog with Previous Page's Record Field.

I have a list page lets call is Approved Entries.

On this list page there is an Action called Make Order.

When a user clicks on a Line in the Approved Entries list page and click on the Action Make Order, I open a StandardDialog Page that shows the list of all the Purchase Order to select from. Once the user selects the Document No. of the PO the PO is updated with the Line selected by user at Approved Entries list page.

Here is the code;

  IF updateexisting.RunModal() = Action::OK THEN
                        updateexisting."Update Order Lines"(Rec);
                    CurrPage.SetSelectionFilter(PRline);
                  

However, the Line at Approved Entries has a Vendor No. So I wish to show only those PO's in the StandardDialog page that are of the Vendor No. selected by user at Approved Entries.

Lets say on Approved Entries there's a Line

Doc No Amount Location Vendor No

B100 100 Blue 150074

The StandardDialog that opens should only show Purchase Orders of Vendor No 150074. Right now I am showing all the POs. Where do I write this filter to filter POs with selected Vendor No.

Thanks a lot in advance for the guidance!

Categories:

Financial Management

Purchasing

Other

Quick Links