Hi folks,
Please help me out. I have created a Smartlist from the existing Sales Line Items Smartlist and saved it to Favorites. I have been using it for a year and suddenly it disappeared just 2 days ago. There is another sale smartlist disappeared too. Any idea about it?
Thank you for your support in advance.
Nhi
*This post is locked for comments
We are having the same experience with **some** of our users. The users have saved their custom SmartList to their UserID and the SmartList, while visible in their My Reports window, when clicked, takes them to the default folder. For example, user creates a custom Account Transactions query, with a specific column layout, saves it to their UserID, SmartList query saves to their My Reports on their home page. User uses their custom SmartList day-in-and-day-out without any issues. Now, sometime later, could be 6+ years later as is our current situation, when the user clicks on their shortcut, they're taken to the Financial >> Account Transactions folder. The user's custom SmartList is not executed, nor is it visible in the Account Transactions hierarchy of available queries. They can create and save a new query; however, they have to save it with a new name (we've been adding a period to the end of the name) because when they try to save with their original name, a message appears indicating a SmartList with that name already exists.
After recreating the queries with the new names, I then delete the user's original SmartList queries from the ASIEXP81 and ASIEXP86 tables, I have the user exist GP and sign back in, but the original queries (without the period in the name) continue to display in the user's My Reports window. It could be I need the user to exit from GP completely first and then delete the original queries, I have not tried this step yet. Are there any other tables I should be considering?
In another thread, pertaining to missing SmartList queries, one user wrote about resetting the Navigation Options, but that feature does not seem to be an option in the GP2015 R2 version we're using. Are there any other ideas on how to resurrect a user's missing SmartList query? community.dynamics.com/.../118776
been running GP for 18 years and never had a smartlist disappear..other than a user deleting it
Hi Leslie
this issue happen often. it isn't someone who deleted it. Even if the smartlist is view per user id or company or system it disappear. can it be an issue with our installation?
best regards
jennifer
Hi Jennifer,
Does this happen often? One thing you might consider is to change the setting so that the SmartList Favorite isn't viewable by the whole system. Someone could have deleted it if it doesn't show up again. For this particular kind of problem, I do not know of a way the matter can be resolved from the user interface.
Kind regards,
Leslie
Hi Leslie
can the issue of the smartlist disappearing be resolve or we need to always restore from a back up file?
Best Regards
Jennifer
Look for the SmartList in the ASIEXP81 and ASIEXP86 tables. The script below should first make it visible to everyone, then you can restrict it just to you if you want. Sometimes the 'Favorite' is lost, but it's really still there. Backup the DYNAMICS database before you attempt this.
/*
Value 1 denotes the first option in that Drop Down, which is SYSTEM.
Since I have to set visibility to all users across all companies,
all I have to do is to set USERID as an Empty String and Company ID as ZERO.
This will change a particular Smartlist Favorite's visibility to all users, all companies.
*/
DECLARE @FavoriteName varchar (30)
set @FavoriteName = 'Accounts'
UPDATE DYNAMICS..ASIEXP81
SET ASI_Favorite_Save_Level = 1, USERID = '', CMPANYID = 0
WHERE ASI_Favorite_Name = @FavoriteName
UPDATE DYNAMICS..ASIEXP86
SET ASI_Favorite_Save_Level = 1, USERID = '', CMPANYID = 0
WHERE ASI_Favorite_Name = @FavoriteName
Share
Report
All responses (
Answers (
1,008
