Small and medium business | Business Central, N...

Bin List Page - SETFILTER based upon Source Page

(7) Share

Report

Posted on by ME-31032107-0

683

I have the following Trigger in the "Bin List" Page (7303):

trigger OnOpenPage()
begin
Rec.SetRange("InclQtyAvail", true);
end;

Works well when launched from the Sales Order Subform on the Bin Code field.

But now I want to do the opposite from the Purch Order Subform Bin Code field (set the filter to false). Both use the same Bin List page.

Is it possible to pass the Source PageID when opening the List, and set the condition based on the PageID?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

YUN ZHU 95,432 Super User 2025 Season 2 on at

Like (3)

Report

In this case, you cannot use the page's trigger OnOpenPage(), but instead apply the filter before the page opens.

1. Create a procedure on the Bin List Page, for example, FilterInclQtyAvail

2. Create a new button and execute the following process, where `page` is a variable:
`page.FilterInclQtyAvail`
`page.run`

Hope this can give you some hints.

Thanks.

ZHU

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 5,789 on at

Like (1)

Report

Hello,

Yes you can do this, but not by detecting the source PageID automatically.
You must pass a value into the Bin List page before it opens.

The Bin List has no built-in way to know which page opened it.

Create a public procedure on the Bin List page (via pageextension) to set a flag.

In the Sales Subform → call SetInclQtyAvail(true)

In the Purchase Subform → call SetInclQtyAvail(false)

The OnOpenPage trigger uses that flag to set the filter.

This is the clean and standard approach.

Regards,
Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
ME-31032107-0 683 on at

Like (2)

Report

OussamaSabbouh,

I understand the concept of what you are suggesting, but am not able to get the coding correct. Here is what I have so far.

The passed variable always shows as "No". What am I getting wrong? Thanks.

On the Bin List Page

trigger OnOpenPage()

begin
Message('Received Variable: %1', InclQtyAvail);
Rec.SetRange("InclQtyAvail", InclQtyAvail);
end;

var
InclQtyAvail: Boolean;

procedure SetInclQtyAvail(Value: Boolean)
begin

InclQtyAvail := Value;
end;

In the Bin Code field of the SalesOrderSubform:

modify("Bin Code")
{
Visible = true;
trigger OnBeforeValidate()
var
DestPage: Page "Bin List";
InclQtyAvail: Boolean;
Location: Record Location;
begin
Location.Get(Rec."Location Code");
InclQtyAvail := true;
DestPage.SetInclQtyAvail(InclQtyAvail); // Pass the variable
Page.RunModal(Page::"Bin List", Location); // Open the page
end;
}

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

Yes, you can handle this by passing context instead of hardcoding logic.

The best approach is to create a procedure in the Bin List page and call it when opening the page from each subform, so the filter is applied dynamically.

This avoids relying on SourcePageID and makes the solution cleaner and easier to maintain.

Alternatively, you could use RunPageLink to pass the filter directly, but parameter passing is more flexible for future changes.

1 people found this reply helpful.

Was this reply helpful? Yes No
ME-31032107-0 683 on at

Like (1)

Report

Jainam M. Kothari,

I am trying to determine where to place the call in the Subforms. I have been trying different triggers on the "Bin Code" field to pass the variable, but it always returns "No.".

If anyone can help debug the sample code I wrote above, I would appreciate it. Thanks.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,602 Super User 2025 Season 2 on at

Like (0)

Report

Still thinking why do you wish to have this on purchasing side?

Purchasing should show all the bin irrespective of what is available or not.

Let me know if I misunderstood something.

Was this reply helpful? Yes No
ME-31032107-0 683 on at

Like (1)

Report

RockwithNav,

The answer is that all PO's are to only be received into "In-Transit" (on the water) Bins (which we are flagging as "Qty Not Available"). Once they hit Port, an Item Reclassification Journal will be made to move them to "In-Stock" (flagged as "Qty Available").

Sales Orders are only to be coded to the "In-Stock" Bins. Just trying to eliminate order entry errors.

Interesting thing is that sometimes the Sales Order Subform calls the "Bin Contents" list, and sometimes it calls the "Bin List" page.

Purchase Orders always seem to call the "Bin List" page. If I can figure out Sales Order Subform logic, I might be able to have it always call the "Bin Contents" form, and that would also solve the issue.

Was this reply helpful? Yes No