Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Trigger Smartlists to be reinstalled

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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans