Skip to main content

Notifications

Announcements

No record found.

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

Filter List Page based on a procedure calculation.

Posted on by 16
Hi BC community,
 
Looking for some advice on how to filter a List page based on a procedure calculation. (main goal is to filter a list for everything that will = 0 for the field i am showing on the page /rdy to ship qty/)
 
field(/rdy to Ship qty/; Rec.CalcOutstandingQty())
                {
                    ApplicationArea = all;
                    Caption = 'rdy to Ship';
                    ToolTip = 'rdy to Ship.';
 
                }
I have a boolean on the page 
 ShowReadytoShip = true then
this doesnt work
  rec.SetRange(CalcOutstandingQty(), 0)
this also doesnt work
  rec.SetRange(/rdy to Ship qty/,0)
 
 
Table extension for the procedure
 procedure CalcOutstandingQty(): Decimal;
    var
        ReservedQty: Decimal;
    begin
        ReservedQty := CalcReservedInvQuantity();
        exit(Rec./Outstanding Quantity/ - ReservedQty);
    end;
Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans