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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Abdulmalek_HamshoCommented:
update ASIEXP81 set ASI_Max_Records = 6000

Execute the above on DYNAMICS DB.
0
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.