web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Filter Based on Anothe...

Microsoft Dynamics NAV (Archived)

Filter Based on Another Field

(0) Share

Report

Report

Posted on by themrmystery

529

Is it possible to execute a filter based on another field?

For example, on a report or list, that allows to filter based on both:

"Qty on Sales Orders" and "Qty in Pick Zone"

Can I enter a filter for one of the two that states:

For filter "Qty on Sales Orders" can I enter something like: > "Qty in Pick Zone"

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

Mohana Yadav 61,204 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You can do it on Code level but not on "ReqFilterFields" level.

Was this reply helpful? Yes No
Verified answer

themrmystery 529 on at

Like (0)

Report
Copy link

Link copied!

Yes, that appears to be the answer. Pretty new to this, but ended up with the following code, which appears to do what I want. Added a Boolean checkbox for the report:

CALCFIELDS(Quantity,"Qty in Pick Zone","Qty on Sales Order");

IF TopPriority = TRUE

THEN BEGIN

IF "Qty in Pick Zone" < "Qty on Sales Order" - QtyFilterbyCust THEN

Replenishmt.Replenish("Bin Content",QtyFilterbyCust);

END

ELSE BEGIN

IF "Qty in Pick Zone" < "Min. Qty." + "Qty on Sales Order" - QtyFilterbyCust THEN

Replenishmt.Replenish("Bin Content",QtyFilterbyCust);

END;

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans