Skip to main content
Solved

Exact number of records cannot be retrieved on a Generic Inquiry

  • October 24, 2024
  • 4 replies
  • 133 views
B
Freshman II
Forum|alt.badge.img

Good day, we have a client that has suddenly received an error on one of their Generic Inquiries.

On the Main GI there is an exclamation mark that states System was not able to get record count and there’s an exclamation mark in the top right corner indicating that the number of records is capped at 50,000

On one of the exisitng filters it states: The exact number of records cannot be retrieved. During export to Excel top 1000 transaction records will be exported.

See screenshot below.

Version 2024R1 PCS on an Azure server

 

 

Best answer by Manikanta Dhulipudi

@brettd36 

The issue is related to below error 

 

You need to check if you can optimize the Relations and quick search checbox on the result grid.

View original
Did this topic help you find an answer to your question?

4 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

@brettd36 

The issue is related to below error 

 

You need to check if you can optimize the Relations and quick search checbox on the result grid.

Acumatica Functional Consultant & Customer Experience Supervisor
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

This is also related to performance issue https://www.augforums.com/forums/acumatica-generic-inquiries/system-was-not-able-to-get-record-count-warning/

 

Please optimize the relations and issue is related to below warning message.

Also disable the quick search checbox on some of the result grid data fields.

Acumatica Functional Consultant & Customer Experience Supervisor
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
Laura02
Captain II
Forum|alt.badge.img+19
  • Laura02
  • Captain II
  • 3132 replies
  • October 24, 2024

Hello @brettd36 ,

Did you notice this previous post by Royce where Naveen, Laura, others have suggested solutions?

 

The original poster solved by unpublishing/republishing (removing from site map and adding back ) but there are a few other recommendations in the thread. Good luck!

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
B
Freshman II
Forum|alt.badge.img
  • brettd36
  • Author
  • Freshman II
  • 12 replies
  • October 24, 2024
Laura02 wrote:

Hello @brettd36 ,

Did you notice this previous post by Royce where Naveen, Laura, others have suggested solutions?

 

The original poster solved by unpublishing/republishing (removing from site map and adding back ) but there are a few other recommendations in the thread. Good luck!

Laura

Dear Laura, I did review Royces post on Aug Forum and we tried the option of removing from the sitemap and re-adding it, but that did not help. I will review the community post above and see if we are able to get further with this. Thanks

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved