Adding custom filters to the request form NAV Classic

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Suresh Kulla 50,241 Super User 2025 Season 2 on at

Like (1)

Report

RE: Adding custom filters to the request form NAV Classic

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Adding custom filters to the request form NAV Classic

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.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,241 Super User 2025 Season 2 on at

Like (1)

Report

RE: Adding custom filters to the request form NAV Classic

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

Was this reply helpful? Yes No
mmv 11,471 on at

Like (1)

Report

RE: Adding custom filters to the request form NAV Classic

Hi,

Is the "Qty. Available" a customized field in the Item table?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Adding custom filters to the request form NAV Classic

Yes. It's part of a custom report that is calculated with this:

Inventory - "Qty. on Sales Order"

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,241 Super User 2025 Season 2 on at

Like (0)

Report

RE: Adding custom filters to the request form NAV Classic

If your custom field is not a flow field then apply the filter onpredataitem

SETFILTER("qty. available",'>=%1',qtyavailfilter);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Adding custom filters to the request form NAV Classic

What if I was looking for a <= to? Client just asked that they would like to go < as well.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,241 Super User 2025 Season 2 on at

Like (0)

Report

RE: Adding custom filters to the request form NAV Classic

Yes you can change it. I thought it was >

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Adding custom filters to the request form NAV Classic

Thank you everyone for your support. I greatly appreciate your time.

Was this reply helpful? Yes No