News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Filter List Page based...

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

Unanswered

Filter List Page based on a procedure calculation.

(0) Share

Report

Report

Posted on by JustinWesty

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:

Business Central

All responses Img

All responses (0)

Answers Img

Answers (0)

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,056 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans