90
I remember it being possible to download smart lists in order to customize in smart list builder. Does anyone know where these can be found? I basically need to add one custom field to the Sales Transactions smart list but since that's not possible, I have to recreate that smart list as a custom one.
*This post is locked for comments
The out of the box and predefined Dynamics GP smart lists can be found as explicit views on the SQL level. On your SQL Management Studio, click on the company database then right click on the views folder > Filter > Filter settings.
Add the following filter: Name contains "Sales". You will get the below:
Now, right click on the selected view, and create to new query editor in order to get the definition script.
You can actually manipulate the script to add whatever modifications you want, and create a new view accordingly.
It is important to know that with the release of GP 2013 SP2, Smart List designer made it easier to modify a predefined smart list by creating a new one based on an existing smartlist.
Let us know if you have any further inquiries,
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,289
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
