News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) FlowField IsExist on T...

Microsoft Dynamics NAV (Archived)

FlowField IsExist on Transfer Order Document show/hide

(0) Share

Report

Report

Posted on by Nareshwar Raju Vane...

5,596

Hi all,

We recently implemented a pattern to show/hide master information to a specific user based.

We did it with Bank Accounts. Reference: https://medium.com/nareshwar-r/user-wise-filtering-in-any-master-tables-on-dynamics-nav-98f16ca5e21a#.xtsvuzpu3

What we used is the IsExist method on FlowFields on the Bank Account Table. Everything works fine.

We had the same requirement for Transactional Documents mainly Sales/Purchasing/Transfers, where only the user's location documents will be shown. I am able to handle Sales and Purchasing Documents since it has only one Location Code on its header.

But when handling Transfer Documents, the client asked to check both the Transfer-From and Transfer-To locations, and if any of the location is his location, then show the document to the user. I am unable to add filters with OR or XOR conditions. Please, advise me on this regard?

Any other solutions are also welcome. Thanks in advance :)

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: FlowField IsExist on Transfer Order Document show/hide

i'm not sure if this solution is "elegant" enough but you can add two boolean fields, one for the from-code(A) and one for the to-code(B), then on your page add this code on the OnOpenPage trigger (you can add as many filter you need i write down just the basic)

IF FINDSET THEN REPEAT

IF (A=TRUE) OR (B=TRUE) THEN

MARK(TRUE);

UNTIL NEXT = 0;

MARKEDONLY(TRUE);

IF FINDFIRST THEN;

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans