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

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Script behind the Smartlist?

(0) ShareShare
ReportReport
Posted on by 270

In GP 10, Microsoft Dynamics GP > SmartList > and then Sales > Customers > *

What is the script behind it? Any thoughts?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at
    RE: Script behind the Smartlist?

    Hi Mobin,

    I guess the script is normally a SQL view to display all the customer records. you can refer the view in backend as dbo.Customers(View section) from the corresponding company database

  • Suggested answer
    Naga Kiran Profile Picture
    on at
    RE: Script behind the Smartlist?

    Hi MOBIN,

    It will loop through records from the table RM_Customer_MSTR  (RM00101) and adds each record to the Smartlist window's list view. This script is run in the background so that the user interface will respond to any user actions during the time of execution of this script.

    Hope this helps.

  • soma Profile Picture
    24,410 on at
    RE: Script behind the Smartlist?

    Nataraj is correct. You can see all the Standard SmartList query from the backend under the views of appropriate company database. For customer smartlist query, expand the view Customers and right click to select new query window to view the same. This similar way you can see all other standard GP Smartlist from backend with the same name.

    Hope this helps!!!

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans