web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Lookups in Dynamics GP

(0) ShareShare
ReportReport
Posted on by

Is there a way to set the lookups for Master Records to Exclude Inactive by user and never allow them to change it.

*This post is locked for comments

I have the same question (0)
  • Danish Viqar Profile Picture
    829 on at

    Can you share which master records you are referring

  • Community Member Profile Picture
    on at

    Let's say I wanted to change the Customer and Prospects Lookup to exclude Inactive customers.  Further, I wanted to force that to be the one and only view that certain users ever use on the lookup.  I know I could write VBA code to accomplish it but I want to be able to do it through Smart List Administration and Security through the application layer.  Is it possible?

  • Community Member Profile Picture
    on at

    Inactive status is a choice in smartlist - sometimes the GP admin has to add it to the default list.  Maybe that will help?

  • Community Member Profile Picture
    on at

    yes, but is there a way to not allow users to change it back to whatever they want to?

  • Verified answer
    Almas Mahfooz Profile Picture
    11,009 User Group Leader on at

    This could only be achieve with customization.

    Either VBA or Dexterity.

  • Suggested answer
    Community Member Profile Picture
    on at

    Right.  That's what I thought

  • Almas Mahfooz Profile Picture
    11,009 User Group Leader on at

    you are welcome.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans