Skip to main content

Notifications

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

  • Almas Mahfooz Profile Picture
    11,009 User Group Leader on at
    RE: Lookups in Dynamics GP

    you are welcome.

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Lookups in Dynamics GP

    Right.  That's what I thought

  • Verified answer
    Almas Mahfooz Profile Picture
    11,009 User Group Leader on at
    RE: Lookups in Dynamics GP

    This could only be achieve with customization.

    Either VBA or Dexterity.

  • Community Member Profile Picture
    on at
    RE: Lookups in Dynamics GP

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

  • Community Member Profile Picture
    on at
    RE: Lookups in Dynamics GP

    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
    RE: Lookups in Dynamics GP

    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?

  • Danish Viqar Profile Picture
    829 on at
    RE: Lookups in Dynamics GP

    Can you share which master records you are referring

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans