web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Smartlist missing
Finance | Project Operations, Human Resources, ...
Suggested answer

Smartlist missing

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,848 Moderator

I just did an upgrade from GP 2015 to GP 18.4.1461. None of the non-system Smartlists are appearing. We still have to old server running. Is there an issue upgrading user visible Smartlists? Is there a way I can identify if they are even in the upgraded Smartlist tables? What tables can I examine to compare what is in the old Smartlist tables versus the new Smartlists tables?

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Smartlist missing

    ASIEXP81 does get upgraded post GP 2016, ASIEXP83 doesn't get upgraded at all, ASIEXP86 last gets upgraded at the 14.00.0704 version and ASITAB20 doesn't get upgraded. These would be the main SmartList tables, though there are many others.

    To understand, it sounds like all of the custom SmartList reports are missing but all the default SmartList folders and reports show correctly after the upgrade to GP 18.4?

    If so, were the custom SmartLists created in SmartList Builder and is that product installed?

    We haven't seen any issues with missing SmartLists post upgrade, whether default or custom, though if the custom reports were created via SLB and that isn't installed, that may be an issue.

    This script will show what custom reports are present:

         Select * from ASIEXP81 where ASI_Favorite_Type > 499 and ASI_Favorite_Type < 2000 order by ASI_Favorite_Dict_ID, ASI_Favorite_Type

    Thanks

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Smartlist missing

    This query returns 0 records on the new server.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Smartlist missing

    It also returns 0 zero records on the old server.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Smartlist missing

    On the old server there are 242 records in ASIEXP81. On the new server there are 259. How do I tell which are system and which are not?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Smartlist missing

    On the old server in the ASIEXP86 table there are 15 records for this missing Smartlist' On the new server there are only 8.

    I used a generic SQL search for text script to search for the title.

    The ASIEXP81 tables both have 1 record on each server.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Smartlist missing

    There is a column called ASI_Favorite_Save_Level in the ASIEXP81 and ASIEXP86 tables.

    On the old server this had values of 0,1 and 4.

    On the new server the only values are 0 and 1.

    Guess what value the Smartlist called Search had?

    If you guessed 4, you win the prize. I bet during the upgrade all 4’s were dropped. Please confirm.

  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Smartlist missing

    The ASI_Favorite_Save_Level is used mainly with SmartList Favorites and I suppose custom reports as well, where you can determine whether to set permissions to System (1), Company (2), User Class (3) or User ID (4).

    I'm still not sure as to why some records or any, for that matter, would be dropped during an upgrade or why. Just the way Utilities updates a table, there's really not a way for data loss to occur. Not saying it's completely impossible, but not common.

    Other than using something like SQL's Import/Export to copy over the missing information, there's really not any specific process we have for resolving this type of issue.

    Thanks for the information.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Smartlist missing

    Running SELECT DISTINCT ASI_Favorite_Save_Level FROM ASIEXP81 or ASIEXP86 returned 0,1,4 on the old server and 0,1 on the new server.

    It appears, in this case, this affects only one Smartlist. Of course, this is the one they use all the time. I will do an export from the old server and import to the new server.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,850

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 795 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 519 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans