Notifications
Announcements
No record found.
Is there any way to export a SmartList definition if you don't have SmartList Builder?
*This post is locked for comments
If you need a definition for an out of the box SmartList, you'll find them in the Integration Guide for Dynamics GP in Part 7. You can download the guide for your GP version here - www.microsoft.com/.../DownloadResults.aspx.
Hope this helps,
Actually I need the definition of user created SmartLists
You mean SmartList Favorites? Or are we talking SmartList Designer in GP 2013?
Smartlist Designer. What I'm trying to do is take the user created Smartlists from one GP instance and copy them to another
Gotcha. I'm not sure if SmartList Designer uses the same or additional tables as SmartList, but you could check the ASIxxxxx tables, which are SmartList. You might be able to copy and insert the table contents from one instance to another.
The smart list designer doesn't create a new view. The SQL script is dynamically built up each time you press on the new Smart List, key data fields are stored in ADH tables (ADH00100, ADH00101, ADH00102, ADH00103, ADH00104).
Your feedback is highly appreciated,
Sounds like a great product suggestion!!!
connect.microsoft.com/dynamicssuggestions
Yes Smartlist Designer will do the Job, if you are on GP 2013 SP2. When you create a smartlist in Smartlist designer, you can click on 'Execute' button which generates SQL query which can be used in external environments. The SQL query is very much readable to an end-user.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
mtabor 1
Victoria Yudin 1
