Talk With an Expert
    July 27, 2020

    How to resolve Microsoft Dynamics GP SmartList window not showing

    Sometimes in Dynamics GP, the SmartList Window does not open as it should, which can bring your productivity to a halt. Fortunately, there are simple ways to solve this on your own.

     This blog will discuss the two main reasons that SmartList might not open and how you can resolve the issue.

    Troubleshooting & Fixing the Smart List Window:

    Problem: SmartList is minimized on the taskbar

    This usually happens when users are utilizing an extended monitor, or two or three monitors at the same time.

    Solution: This is an easy fix. Simply hover over the GP icon in the taskbar at the bottom of the screen and right click the SmartList Window. Then, select “Maximize.”

    GP icon in the taskbar

    If this solution does not resolve the issue, it means that the values in the Microsoft Dynamics database are incorrect.

    Problem: SmartList is pulling incorrect database values

    When many users are trying to access SmartList, the database values can occasionally get changed. To resolve this, the values will need to be fixed manually.

    Solution: Start by checking with another user, such as an administrator or “super user,” to see if they can open SmartList with their credentials. If so, run the script below against the DYNAMICS database. Replace the ‘xxxx’ section of the script with the User ID that does not have any issues and the ‘yyyy’ with the User ID that is having the issue. Essentially, you are replacing the setting with one from another user that is working properly. Follow these steps to resolve the issue:

    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)

    One of these solutions should rectify the issue and give you consistent access to SmartList in Dynamics GP. Once you have resolved it, the issue will be unlikely to happen again.

    If you could still use some help gaining access to SmartList in Microsoft Dynamics GP, don’t hesitate to contact our team of Dynamics GP experts.

    About the author:

    Riaz Qadeer is certified in MS Dynamics GP (Installation and Configuration). He has experience in training, project management, consulting, and implementation of Microsoft GP. He is also experienced in SQL server database administration and IT.

    Riaz Qadeer

    Riaz Qadeer is certified in MS Dynamics GP (Installation and Configuration). He has experience in training, project management, consulting, and implementation of Microsoft GP. He is also experienced in SQL server database administration and IT.

    Enavate Recent Posts

    March 27, 2024

    The Costs and Benefits of Microsoft Dynamics 365 Business Central

    Microsoft Dynamics 365 Business Central is an agile ERP platform that allows small to medium-sized businesses (SMB) to enhance, grow, and scale their operations, allowing for... Read More
    March 15, 2024

    How to Reduce Warehouse Management Costs with Automation

    Way back in 2015, Supply Chain Management Review claimed that warehouse automation is one of the few remaining areas where companies can still significantly reduce their... Read More
    March 13, 2024

    How Business Central Helps You Stay on Task

    Anyone who has ever traveled by plane knows how stressful it can be to have a connecting flight. You must wait your turn to get off the first plane, figure out where your... Read More

    Subscribe to Receive Email Updates