Trigger Smartlists to be reinstalled

(0) Share

Report

Posted on by Richard Wheeler

75,730

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.

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Suggested answer

Derek Albaugh on at

Like (0)

Report

RE: Trigger Smartlists 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.

RE: community.dynamics.com/.../quot-problem-ascertaining-version-information-quot-error-when-installing-or-upgrading-microsoft-dynamics-gp

Thanks