web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / How do I fix SL 2011 Q...
Microsoft Dynamics SL (Archived)

How do I fix SL 2011 Quick Queries only displaying 10,000 rows of data?

(0) ShareShare
ReportReport
Posted on by 9b4341a4e61e4276bf1... 70

In SL 2011 I installed the hotfix to correct the quick query issue where the AR Transaction query would time out. In doing so it seems to have capped query results at 10,000 rows of data. Is there a fix out there so that AR Transactions does work and I can get all the transactions to display?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Dynamics 365 Profile Picture
    Community Dynamics 365 on at

    Dear Kristin

    We had this problem with too many AP transactions.  In situations where the database tables are too large (generally over 10,000 rows) you need to find a filter that will work for your situation.  We used a date filter that keyed off the current period field and limited the view to six previous periods of data.  That worked for us.  It's dynamics since after a period is closed the view rolls to the next period.

    Also since you can't load the screen with too many transactions to apply the filter you have to modify the view in the database.  We created a new view and associated the new view with a new quick query.  In that way we preserve the original view that SL provided.

    Hope this helps.

    Thanks

    Don

  • 9b4341a4e61e4276bf1de11ce8038fa0 Profile Picture
    9b4341a4e61e4276bf1... 70 on at

    Thanks for the reply and suggestion.  I will have to give some thought to creating new views.

  • Community Dynamics 365 Profile Picture
    Community Dynamics 365 on at

    Dear Kristin

    You can also modify the existing view.  The Quick query view all start with QQ in the database.  For example QQ_ARTRAN

    Thanks

    Don

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans