Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Trigger Smartlists to be reinstalled

(0) ShareShare
ReportReport
Posted on by 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:
  • Suggested answer
    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

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.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans