After upgrading to 2021R1, the Bank Deposit screen has become unusable. We have a not-so-large ARRegister table (few million rows). It takes about 8-10 minutes after clicking “Add Payment”.
Looking through the built SQL query, Acumatica is using a STRAIGHT_JOIN on the ARRegister and the ARPayment. After capturing the query and using an INNER JOIN the results are immediate.
I understand the difference between the two and using STRAIGHT_JOIN is rarely used.
Has anyone ran into this issue with a fairly large db?
FYI - I did un-publish customizations and I also created a ticket and reproduced the issue with support.
Any other ways to create bank deposits other than import scenarios since that will just make the problem worst.
Best answer by pmccormack58View original