Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

SmartList won't open for a specific user

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

We are using GP 2013 on a terminal server. I think this should eliminate DEX.INI as the culprit. Other users are unaffected and I do not see SmartList running in the task manager on this user's machine.

I tried to use a script I found in another forum post but it did not resolve the issue:

 update sy01402 set SYUSERDFSTR = 'TRUE~506~792~1~1~177~' where USERID = 'affecteduser' and syDefaultType = '96'

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SmartList won't open for a specific user

    Did you ever resolve this issue? I'm having the same problem...I change the value for this user in sy01402, but as soon as they open/log into GP the setting goes back to it's original crazy value. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SmartList won't open for a specific user

    Hi Everyone,

    I changed the value in SY01402 where syDefaultType = '96' several times with no luck. The user was able to open SmartList when logged in as someone else, so I ended up creating a new user and copying the user's security. When logged in as the new SQL user, they are now able to open SmartList.

    Thanks everyone for your time!

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: SmartList won't open for a specific user

    Something happened yesterday that makes me make this post.

    I had a client for whom we created a specific TEST database - assigned only to one user.

    When we were done with the TEST work - the IT managers asked us to remove the database - we used the DELETE database from within the application and to remove the company and encountered the error that the database was not available.

    We looked at the SQL Server and learned that the IT tech decided that the note from her boss meant, REMOVE the database from SQL Server - so ....

    Now we have to use Clear Company to get the database reference removed.

    Having done this we now encounter an error for the Smartlist where it will not load.

    There is a post on the forum that discusses this - if this is your issue - if not, sorry to take your time with this post.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: SmartList won't open for a specific user

    Clint,

    If the problem user logs in as someone else can he open the SmartList window?

    Leslie

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: SmartList won't open for a specific user

    If the users machine smartlist list window open with empty, then follow the Mr.Babu suggestion.

    If users not able to open the smartlist window, run the below query to check the result values and update the table with appropriate match values.

    select * from SY01402 where syDefaultType = '96'

    Hope this helps!!!

  • Suggested answer
    RE: SmartList won't open for a specific user

    Hi Clint,

    Have you checked the language for unicode under Region and Language and change it to English (country)

  • KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: SmartList won't open for a specific user

    Hi Clint,

    I am not sure if that value was unique to my environment or not. What is the result of running select * from SY01402 where syDefaultType = '96'? Can you update the value to match that of a user that you know smartlist is working for?

    Regards,

    Kirk Livermont

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SmartList won't open for a specific user

    Thank you for the reply! That is the other forum post that I was working from. However, following the steps did not resolve my issue.

  • soma Profile Picture
    soma 24,406 on at
    RE: SmartList won't open for a specific user

    Please have a look on the below link.

    community.dynamics.com/.../120847.aspx

    Hope this helps!!!

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans