Hi @RSHAH1 what do you mean with Data processing in background? Improve the time response of GI´s? Dashboards?

I´d like to get a concrete example of what you are trying to accomplish, so I could give you better advise.

Regards,

Hi @RSHAH1  Have you reviewed the SQL Profiler to know which SQL queries are running in the background and taking time?

@deybanperez83 @Naveen Boga 

Hello sorry for late replay…

Yes, I would like the processing time for GI's, Reports and Dashboards to improve significantly. For example: We have an internal ticketing system and a lot cases get created on a daily basis. Once the cases are closed, they may be required for another few months for reference purpose but that may not be the case after 1 or 2 years. Instead of deleting such cases, is it possible to remove them from appearing in system, but when required it can be accessed with a separate login.

Hi @RSHAH1 - were you able to find a solution? Thank you!

Hi @RSHAH1 , you can exclude them from your generic inquiries by doing so in the relations. If you do it on the conditions tab it will still load all the data and then only filter out based on your conditions. If you do it on the relations tab then you limit the amount of data being loaded initially.

So if you want to only show all cases besides the closed cases, you can do something like this:

Case2 is just the CRcase table but you will notice in the join we are looking for all cases that are not closed. You can then create an historic cases GI that will show all the closed cases.

Hope this helps.

If you are on 2023 R1, have you looked into this new feature for Archiving Old Documents - Currently limited to Sales Orders and Shipments, but I’d assume that additional document types may be added to this functionality in the future:
 https://help.acumatica.com/(W(3))/Help?ScreenId=ShowWiki&pageid=9346f797-eebc-4d54-a176-00084a6d0faf 

There’s some additional requirements and requests logged under this idea here: