Hello @rafaelcolon ,

I am wondering if the query is slow because of Volume only, or because of other conditions. Can you please provide more details:

Are you opening the screen directly with a Tile, with “+New,” or are you clicking on “Bills and Adjustments”?

If you are opening with #3 “Bills & Adjustments”, has the Generic Inquiry been edited, or is it original?

If the generic inquiry has been modified, you might complete a quick test by backing up (exporting) your current GI and replacing it with an original Bills and Adjustments GI, such as from an empty tenant, test tenant or demo tenant. If there is a difference between the timing of your modified GI and the original gI then volume of Bills isn’t the only reason the Bills screen is slow.

It’s possible that joins and other inquiry configurations could be improved for speed. In this case, most Community helpers will want to see your changes and joins. Can you post screenshots of  Relations, Conditions, Grouping, Sort tabs, or just export and attach here the XML?

If you are opening Bills & Adjustments screen directly, without seeing the generic inquiry (#1 and #2 on first screenshot above), please let us know if the Bills screen itself is customized and whether the screen opens at the same speed with customizations temporarily un-published.

Thank you.

Laura

The generic inquiry hasn’t been modified. We believe that performance degraded as we

added more transactions to the table. We just migrated to Acumatica and we imported data in phases so thats why we noticed the change so drastically as more data was added.

Here are the screenshots of the data sources and relations.

HI @rafaelcolon 

Could you add a condition to only show bills from the past year?

This may limit the data and the loading times.

Alongside this, I’m guessing you would want another screen with all the bills at the tip of your fingers, so what you can do is copy and paste this GI into a new one which can be used for data purposes.

Hope this helps,

Aleks

We were able to fix performance by reducing the amount of records loaded at a time. Instead of the deafult 1000 we lowered it down to 300 for now. It reduced time from 10sec to around 3sec. We did it through the edit generic inquiry button you showed. Thanks!