Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to "Start Ove...
Finance | Project Operations, Human Resources, ...
Suggested answer

How to "Start Over" with SmartLists in a Test Environment

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi:

We have a separate test environment containing the default SmartLists, some SmartList favorites, and SmartLists created through a third-party tool.

In this test environment, we want to (a) delete all SmartLists and (b) use SQL importing to import only the default SmartLists from production into test.

We know how to conduct the SQL importing.  We just need to know which SQL tables to delete the SmartList data from and which tables to import the default SmartLists from.

Please let us know.

Thank you!

John

Categories:
Microsoft Dynamics GP
  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: How to "Start Over" with SmartLists in a Test Environment

    Along with what Beat mentioned, if it is a test environment and you want to take SmartList back to only the defaults, meaning all SmartList favorites and custom SmartLists would be gone, as in a 'new' install of SmartList, you could potentially re-initialize SmartList feature using the scripts/steps mentioned in this blog:

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

    After you run the scripts then launch GP Utilities again, it'll setup the SmartList feature to have only default information in the tables, again, like a brand new install of Dynamics GP.

    For your reference, as well, the SmartList tables are:

    ADH00100

    ADH00101

    ADH00102

    ADH00103

    ADH00104

    ADH00105

    ADH00106

    ASIEXP50

    ASIEXP51

    ASIEXP60

    ASIEXP81

    ASIEXP83

    ASIEXP86

    ASIEXP95

    ASIEXP98

    ASIEXP99

    ASIEXP100

    ASIEXP101

    ASITAB10

    ASITAB20

    ASITAB30

    ASIEXP01

    ASIEXP02

    ASIEXP03

    ASIEXP04

    ASIEXP05

    ASIEXP06

    ASIEXP07

    ASIEXP08

    ASIEXP09

    ASIEXP10

    ASIEXP11

    ASIEXP12

    ASIEXP13

    ASIEXP14

    ASIEXP15

    ASIEXP16

    ASIEXP17

    ASIEXP18

    ASIEXP19

    ASIEXP20

    ASIEXP21

    ASIEXP22

    ASIEXP23

    ASIEXP24

    ASIEXP25

    ASIEXP26

    ASIEXP27

    ASIEXP28

    ASIEXP29

    ASIEXP30

    ASIEXP31

    ASIEXP32

    ASIEXP36

    ASIEXP91

    ASIEXP92

    ASIEXP93

    ASIEXP94

    ASIEXP96

    ASIEXP97

    Thanks

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,054 Super User 2024 Season 1 on at
    RE: How to "Start Over" with SmartLists in a Test Environment

    Hi John,

    Check this blog post from eOne, that should help put you on the right track..

    www.eonesolutions.com/.../

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans