Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / FlowField IsExist on T...
Microsoft Dynamics NAV (Archived)

FlowField IsExist on Transfer Order Document show/hide

(0) ShareShare
ReportReport
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

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    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;

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans