So I have a report that generates a column "Qty. Available" and would like to create a custom filter that filters a range of the amount in that column. Not really sure where to start. Can anyone help?
*This post is locked for comments
So I have a report that generates a column "Qty. Available" and would like to create a custom filter that filters a range of the amount in that column. Not really sure where to start. Can anyone help?
*This post is locked for comments
Thank you everyone for your support. I greatly appreciate your time.
Yes you can change it. I thought it was >
What if I was looking for a <= to? Client just asked that they would like to go < as well.
If your custom field is not a flow field then apply the filter onpredataitem
SETFILTER("qty. available",'>=%1',qtyavailfilter);
Yes. It's part of a custom report that is calculated with this:
Inventory - "Qty. on Sales Order"
Hi,
Is the "Qty. Available" a customized field in the Item table?
Please let us know the report no. There is no column in the table Item called Qty. Available, the actual field is Inventory
If you are referring the Inventory Field on the Item table then that is a flow field for that you need to use onaftergetrecord something like below
CALCFIELDS(Inventory);
IF Inventory >= QtyAvailFilter THEN
CurrReport.SKIP
Yes I would like to place the filter on that column but on Item OnAfterGetRecord( )
IF QtyAvailFilter <> '' THEN
SETRANGE("Qty. Available", QtyAvailFilter);
This is what I have but It's not working. Also I would like it to be just a >= a certain amount.
Very new to this. Just started last month.
Do you want to apply filter on that column ? From the request form you can apply the filter or the specified data item in the code on Pre-data Item you can apply the filter using SETFILTER or SETRANGE
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156