Access/Datapax 7 Support
Clearing out of balances from Accounts Receivable
***Backup all database files before proceeding***
- Check the Detailed Aging for those customers that are OOB
- Look for any open corrections to closed invoicese) If found then go to the Trace Customer Account and look for that transaction and note the invoice number
- Go to the Correct Invoice Status function
- Locate the invoice number and uncheck (open) and recheck (close) the invoice.
Saving in between checks will clear the prompt, instead do the open and close in the same action then Save - that will keep the prompt and usually closes the invoice
Be careful of any invoices with the same invoice number - you may need to open and re-close all invoices of the same number to ensure that the corrections close properly.
If this is done the Correct Brought Forward Balances function will have to be run using the prior month and year of corrections that were closed.
If OOB or BFW conditions still exist then run the Correct Brought Forward and Current Balances function with the starting month as the prior month and the current year
A. If only a handful of customers, I recommend running for those customers individually
B. If several customers then run for All customers
C. If residuals were created as a result of correcting the balances then check the Trace Customer Account and try to confirm that the residuals are legit
Usually created from clients posting payments and not wanting to apply them because the account is out of balance
I also see a lot of clients try to reverse open corrections by entering in false payments or additional AR corrections to try and reverse the open corrections. Please do not do this as it will throw off your entire AR. If you believe there should be no residual on the account after going through the steps listed previously then apply an AR correction in the opposite amount of the residual, go into the customer in AR, and double-click on that correction to zero out the residual.
Tags: AR, OOB, out of balance, residuals
Related entries:
Last update: 2009-08-12 16:24
Author: Administrator
Revision: 1.0
You cannot comment on this entry