Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / GP Smartlist not showi...
Finance | Project Operations, Human Resources, ...
Suggested answer

GP Smartlist not showing data for a single user when he tries to run a single smartlist report whereas all other users can see the record

(0) ShareShare
ReportReport
Posted on by IT Analyst

A Single user in our company gets no record when runs a specific smartlist. Other than this user, every body can see the record when that specific smart list is run. I have checked the security, it seems fine but even though this specific user does not get a single record when this single user tries to run this specific smartlist report. Note that other than this report this user can see data in all other smart list.

Looking at this issue, I did following steps but still the issue is there:

  • GRANT SELECT ON <TABLE/VIEW>  TO DYNGRP
  • CHECKED THE SECURITY IN TASK IN GP. This user has the same access as his colleagues have
  • Checked smartlist SQL Table security. (Tools >> smartlist builder >> security >> SQL Table security  (Every thing is fine here)

but this single user still has issue on this single smart list so when this user runs this smartlist, there is no record shown whereas other users can see the data

In addition to this I was trying to look for the following in dex.ini file but couldn't find it

SQLLogSQLStmt=FALSE

SQLLogODBCMessages=FALSE 

SQLLogAllODBCMessages=FALSE 

Can some one let me know what to do to solve this issue

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,928 Most Valuable Professional on at
    RE: GP Smartlist not showing data for a single user when he tries to run a single smartlist report whereas all other users can see the record

    Hi Kellyanne

    I think that article addresses where the window opens and stops it opening off screen.

    FYI: GP Power Tools will prevent windows opening off screen and remember where you want them on a per user basis.

    I think the issue is not the window not opening, but the data returned by a favourite is not working.

    I suggest you capture logs. You can use GP Power Tools to capture up to 5 logs of just the issue from only the current instance with a single click.

    Or go through the manual steps to capture 1 log of everything from login to the issue. Add those dex.ini settings as TRUE and remember to set them back to false afterwards. If this is on a terminal server, the manually created logs will contain data from all sessions.

    It should show you why the SQL query is failing.

    I suspect regional settings on that machine. The question is... does it follow the user or the machine. Log that user onto another machine, and another user onto the machine where you saw the issue.

    Keep us informed of what you find.

  • Suggested answer
    KellyanneB Profile Picture
    KellyanneB 15 on at
    RE: GP Smartlist not showing data for a single user when he tries to run a single smartlist report whereas all other users can see the record

    "1. Run this script:

    USE DYNAMICS

    SELECT SYUSERDFSTR, * FROM SY01402

    WHERE syDefaultType='96'

    AND USERID ='xxxx' (replace xxxx with the working GP User ID)

    SELECT DEX_ROW_ID, * FROM SY01402

    WHERE syDefaultType='96'

    AND USERID ='yyyy' (replace yyyy with the non-working GP User ID)

    2. Ask the user with the issue to close their GP application.

    3. Next, copy the value under SYUSERDFSTR field.

    4. Then, run the UPDATE script below for the User ID that has the issue. Copy the value of SYUSERDFSTR (from step 2) into the script below.

    UPDATE

    SY01402

    SET SYUSERDFSTR='aaaa' (replace aaaa with the SYUSERDFSTR value of the working GP User ID from step 2)

    WHERE USERID='yyyy’ (replace yyyy with the non-working GP User ID)

    AND syDefaultType = 96 AND DEX_ROW_ID=’zzzz’ (replace zzzz with the dex_row_id value of the non-working GP User ID from step 2)"

    www.enavate.com/.../how-to-resolve-microsoft-dynamics-gp-smartlist-window-not-showing

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans