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.”

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.