SmartList Search Not Working

(0) Share

Report

Posted on by Community Member 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

All responses (6)

Answers (1)

Community Member Microsoft Employee on at

Like (1)

Report

RE: SmartList Search Not Working

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

John
babubaskaran@outloo... on at

Like (0)

Report

RE: SmartList Search Not Working

That's really good information John, thanks for sharing it. My guess was correct :-)
Community Member Microsoft Employee on at

Like (0)

Report

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

babubaskaran@outloo... on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 5,985 on at

Like (0)

Report

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