We help IT Professionals succeed at work.

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
Comment
Watch Question

Would SQL approach be acceptable, or must be from the user interface?

Author

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

Execute the above on DYNAMICS DB.
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

Author

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

Author

Commented:
Thank you!