Microsoft Dynamics GP SmartList Window Not Showing or Blank
Posted by Mike Gordon, CPA, MCP on April 26, 2017
Recently, a client of mine had an issue where the Dynamics GP SmartList Window would not open or when it did, it was blank.
I found that this is a known issue, as the window settings in the DYNAMICS SY01402 table can become corrupt and cause the window to hide or be blank.
Troubleshooting & Fixing the SmartList Window:
- First, try to find the window.
- Right click on the window and choose maximize. If that does not work, the settings are most likely corrupted.
- If you think the settings are corrupt, check the user settings in the table by running this query:
select * from DYNAMICS..SY01402 where syDefaultType = '96'
Try to reset the setting for the current user with the issue by replacing the setting with one from another user that is working properly.
update DYNAMICS..SY01402 set SYUSERDFSTR = 'TRUE~506~792~1~1~177~' where USERID = 'XXXX' and syDefaultType = '96'
If that does not resolve the issue, delete the setting for the user with the error.
delete Dynamics..SY01402 where syDefaultType='96'and syUSERID='xxxx'
To re-create that user, have the user log out of Dynamics GP and log in again. Now, have the user open the SmartLists, and the setting will be recreated.
If you’re not familiar with SQL or have further questions, we have a team of Dynamics GP experts here to help. Send us an email at Support@Crestwood.com.