High BSID volume problem
We have a customer with more than a million open line items (BSID). We are running into huge problems due to this. This customer makes up one third of our business and since this customer uses the same bank details every time they send the payment, we cannot use more than one master record for this account, as this will cause problems in cash application.
Even a simple offset of debit and credit using F-32 times out every time. When we use a background job, it takes nearly 20-25 minutes for each transaction. We have nearly 25000 offsets to do and there is no way to accomplish this ..if this goes on.
Please suggest a way to improve the performance of this issue..