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.

    Enavate Recent Posts

    6 minute read | January 12, 2021

    How does technology improve customer service?

    In today’s fast-paced world, organizations are expected to respond quickly to customers. How do you achieve that, considering that the COVID-19 pandemic has driven that... Read More
    11 minute read | December 22, 2020

    Own Your NetSuite with Analytics Workbooks: Create a dataset and workbook

    This blog is Part 2 of the "Own Your NetSuite" series, which focuses on features, functions and tricks every NetSuite user should know to get the most out of the platform.... Read More
    7 minute read | December 16, 2020

    Year-End closing best practices part 5: Dynamics SL – general ledger module

    This is Part 5 in a series for Microsoft Dynamics SL year-end closing best practices. This post outlines the year-end closing for the General Ledger Module in Dynamics SL.... Read More

    Subscribe to Receive Email Updates