asked on

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

Abdulmalek_Hamsho

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

JustinGSEIWI

ASKER

I would not mind using SQL to make the change. However, the end user cannot use SQL.

I am happy to try either.

Justin

Abdulmalek_Hamsho

update ASIEXP81 set ASI_Max_Records = 6000

Execute the above on DYNAMICS DB.

ASKER CERTIFIED SOLUTION

Abdulmalek_Hamsho

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

JustinGSEIWI

ASKER

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.

Abdulmalek_Hamsho

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.

JustinGSEIWI

ASKER

Thank you!