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
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
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
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,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156