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.
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
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... 290,537 Super User 2024 Season 2
Martin Dráb 228,520 Most Valuable Professional
nmaenpaa 101,148