Sales Aging Report Running Slow

[Borvik]

Hey all,

I've been running into a problem recently. It seems that when we run the Aging report (Routines > Sales > Aging) it runs really, really slow. Nothing else seems to be affected. I'm wondering if our database is just getting really massive, or if it some other problem.

Any ideas?

 

[Luvsql]

Do you occasionally run the paid transaction removal to move fully applied documents into history? This will make the RM Open tables smaller, thus less to age.

 

[Borvik]

Thanks for the reply Luvsql!

The paid transaction removal is currently run at least once a month, maybe they should be doing it more - I'm not sure.