We are seeing few of the customers having incorrect balances and everytime when we observe this we are running the “Validate Customer Balances’ processing screen then Customers are updating with the proper balances.
As we have huge number of customers in the system, this process is taking so much of time.
Do we have any other alternative to find only the customers which are having incorrect balances, so that we will run this process only for those customers.
Best answer by Hannah Barnes
Hi naveenb74!
The customer balance is calculated at the time the Validate Customer Balances process is ran. The current balance would not have anything to compare to before this calculation was processed, so knowing which balances are incorrect beforehand is not currently part of the functionality.
The customer balance is calculated at the time the Validate Customer Balances process is ran. The current balance would not have anything to compare to before this calculation was processed, so knowing which balances are incorrect beforehand is not currently part of the functionality.
Can you confirm the version and build your instance is on? Since the issue occurs on regular basis, you may try identify the root cause as well. Are there any customizations built on SO/SI /AR module ?
We have a huge number of customers ( Around Five hundred thousand) and when we run this “Validate Customer Balances” processing screen we observed performance issues in the 2019 R1 and 19.106.0020 version.
We are upgrading to 2020 R1, we will need to verify the performance of this screen.
Noted, here is one specific fix mentioned on 2019 19.119.0011 build release notes which may be relevant. I am not sure if these changes are part of ‘ValidateSimplifyPackage’. The upgrade to 2020r1 in any case, should take care of all of this.
AC-166430: Users experienced performance issues if they tried to process all records on the Validate Customer Balances (AR509900) form. Fix description: Additional indexes were created for the SOOrder, CuryARHistory, ARAdjust, ARHistory, and PMTran tables.
Will be curious to know the results post upgrade to 2020r1.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.