Announcements
No record found.
Is it possible to use SQL to write a script to provide a listing of all Smartlists across all products? I am looking for the main folder and then all Smartlists under each folder. What are the proper tables and linkages?
The ASITAB30 table seems to have a list of the default SmartList reports.
For custom SmartList reports, the ADH00100 would probably be the easiest to use.
SmartList Favorites are held in the ASIEXP81 table along with custom SmartList reports.
If using SmartList Builder from eOne, they have their own tables as well.
Thanks
Thanks, it appears they have been using Smartlist Designer as there are custom Smartlists. The problem I have is they just created a new company with a different fiscal year. The GL Smartlists that exist do not match this new company and since they were deployed as system cannot be used. I will recreate them just for this new company.
Period 1 in this new company is January where in all the other companies Period 1 is July.
This works great!
use DYNAMICS
select isnull(TRANSVAL, '') SmartList, ASI_Favorite_Name Favorite,
Module = case when asi_favorite_dict_id = 3830 then 'SLB' else 'GP' end,
a.CMPANYID, isnull(CMPNYNAM,'') CompanyName, USRCLASS, USERID
from [ASIEXP81]​ a
left join [ASITAB30] b on a.[ASI_Favorite_Name] =b.UNTRSVAL
left join [SY01500] c on a.cmpanyid = c.cmpanyid
Thanks, this does work great. I will add this to my GP SQL bag of tricks!
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 616
André Arnaud de Cal... 460 Super User 2026 Season 1
Syed Haris Shah 331 Super User 2026 Season 1
