Announcements
I have another client who has developed missing Smartlists and ASI_Explorer Favorites Columns error(38) error messages. Please remind me what script(s) to run so GP utilities will think SmartLists needs to be reinstalled.
If you want to completely re-initialize the SmartList module in Dynamics GP:
>>Against the GP system database
1. Delete DB_Upgrade where PRODID = 1493
2. Delete DU000020 where PRODID = 1493
3. Delete SY90200 where PRODID = 1493 (this table most likely does not exist)
>>Against each and every company database mentioned in SY01500 table:
1. Drop Table ASILOC90
After this, launch your current GP version's Utilities and it'll see that SmartList needs to be re-installed and do so.
**NOTE: This will remove all SmartList favorites, custom SmartLists and any modifications the customer made in SmartList.
Thanks
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156