Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

SmartList Search Not Working

Posted on by Microsoft Employee

Hello:

This is a strange one.  I have looked in SmartList at several of the “Receivables Transactions” reports in the Sales object, on all three of our production Terminal Server boxes.

 

None of the reports will display data, when you conduct a search based on Customer Name—only on Customer ID.

 

In fact, just now, I looked in GP on our test environment.  There, I was able to successfully pull up such SmartList reports, when I used Customer Name criteria.

We are on GP 2013 R2 (12.00.1920)--in both production and test.  And, both production and test are configured the same.  The only difference is that the data in test is several months old. 

Regardless, production should be pulling in data based on a search on Customer Name.  Even the default (*) SmartList is not displaying data.

I have tried several variations of the search and conducted case-sensitivity "troubleshooting".

Also, not only has one user reported this issue logged into GP as herself.  But, I logged in as "sa" and got the same bad result.

What are some other steps that I can take to troubleshoot and eliminate this issue?

Thanks!  I appreciate all of you!

John

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SmartList Search Not Working

    You're a brilliant man, Babu!  I have always appreciated your help!

    John

  • RE: SmartList Search Not Working
    That's really good information John, thanks for sharing it. My guess was correct :-)
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SmartList Search Not Working

    Thanks, Babu!!!  What you told me gave me the step in the right direction!

    It does have to do with accidentally modifying the SmartList.  Since we have and use SmartList Builder and not SmartList Designer, through some SQL scripting we found that someone opened SmartList Builder and messed up the default SmartList.  Below is further information, for your future reference:

    The only solution is to delete the modified list, which will revert it back to the default list.  

    All the favorites that were attached to the original default SmartList will come back, and they all will work again.  The only favorites that will disappear will be the new ones they created AFTER the SmartList was accidentally modified.  

    Since the modified SmartList essentially didn't work at all, hopefully they weren't out there creating hundreds of favorites against a broken SmartList.  

    If you want to find out who modified the SmartList, run the following query in management studio.  

    select MDFUSRID,MODIFDT,* from SLB10000 where SmartList_Item_Name='Receivables Transactions'

    That will show you the user that did it, and when they did it.  (Only the date, not the exact time).  Then lock that user out of SmartList Builder, so that when they accidentally hit the modify button, they will get a message that they don't have access to the resource.  If they are a power user, you can't remove access to it, just tell them not to hit the modify button anymore if they aren't sure what they are doing.  

    sqlbijourney.wordpress.com/.../dynamics-gp-smartlist-default-produces-no-data

    www.eonesolutions.com/.../removing-modified-default-gp-smartlist

    www.eonesolutions.com/.../tech-tuesday-restricting-the-modification-of-existing-smartlists-by-smartlist-builder

  • Verified answer
    RE: SmartList Search Not Working

    Hi John,

    I have faced a similar issue like this.  And the problem is might be related to one of the user has accidentally pressed the modify button on top of smart list which will open smartlist builder modify window and made some changes and saved it.  What you can do is since your test environment is working correctly, please take a backup of company and dynamics database.  And go to receivables transactions-sales and press modify and select some extra column and save it( you can make a note of what is getting defaulted on the live * and select exactly the same).  close the smartlist and open it again and you should see similar issue what you see on production.  Mainly you need to look at your ASI tables under dynamics database before and after the changes and see what changed on this tables.  This look like a bug which need to be reported to Microsoft.  Please let me know the outcome.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SmartList Search Not Working

    Hi There, Kirk!

    We do not have Extender.  

    Also, I just reviewed eOne's website.  Yes, we are on the latest version of SmartList Builder for GP 2013 R2.  That version of SmartList Builder is 12.00.0086.

    We have been using this version of SmartList Builder, as well as this version of GP, since January 17 of this year.  This is the first that I have seen, of this issue.

    John

  • Suggested answer
    KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: SmartList Search Not Working

    Hi John,

    Are you running the latest release of Smartlist Builder?

    Do you use eXtender in your environment? I have seen it create some unexpected results when used with smartlists.

    Best regards,

    Kirk

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans