great plains maximum records

I have a user that uses a smart list to look at all of the vendors we have in great plains. The maximum records search option is set to 5,000. We have over 5,000 vendors so when the user searches, only 5,000 of our vendors are shown, not all of them. The user has to manually go into the search options and change it from 5,000 to 6,000. Is their a way to change the default search option?

Thanks,

Justin
JustinGSEIWIAsked:
Who is Participating?
 
Abdulmalek_HamshoCommented:
Note: The previous statement changes all of SmartList max records to 6,000. If you want to change only the 5,000 to 6,000 you can use this:

update ASIEXP81 set ASI_Max_Records = 6000 where ASI_Max_Records = 5000
0
 
Abdulmalek_HamshoCommented:
Would SQL approach be acceptable, or must be from the user interface?
0
 
JustinGSEIWIAuthor Commented:
I would not mind using SQL to make the change. However, the end user cannot use SQL.

I am happy to try either.

Justin
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Abdulmalek_HamshoCommented:
update ASIEXP81 set ASI_Max_Records = 6000

Execute the above on DYNAMICS DB.
0
 
JustinGSEIWIAuthor Commented:
Do I just run this command as an SQL query? How do I know that running that command will only change the setting on the smart list the user wants it changed on? Their are many lists.
0
 
Abdulmalek_HamshoCommented:
Yes, run the above statement as a normal SQL Query.

The first statement sets the MAX_Records value to 6,000 for all of the existing smartlists, while the second one changes the Max_Records value to 6,000 for the smartlists that have the Max_Records = 5,000. Otherwise, you need to customize the WHERE statement according to your needs.
0
 
JustinGSEIWIAuthor Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.