Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Smartlist Source Tables

Posted on by Microsoft Employee

I would like to see the source tables for an existing SmartList in GP.  It appears to have been created by copying a favorite (canned report).  I don't see it in SmartList Builder.

*This post is locked for comments

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Smartlist Source Tables

    You can download smartlist builder files for the standard smartlist from the reports page on customersource. I don't have the link with me, but I can email the .xml files if somebody doesn't put up the link. Email me at leslievail@earthlink.net

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Smartlist Source Tables

    Dynamics GP canned Smartlists have associated SQL views on the database level with the exact same name. For instance, the Accounts smart list under financial have a predefined SQL view which name is [Accounts]. Same for any other smart list

    So if you are looking for creating a customer smart list, the best way is to create a separate SQL view taking into consideration the source tables of the original smart list as explained above.

    Please never hesitate to share any further inquiries,

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans