Access/Datapax 7 Support

ID #1017

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.

Categories for this entry

Tags: AR, OOB, out of balance, residuals

Related entries:

Last update: 2009-08-12 16:24
Author: Administrator
Revision: 1.0

Digg it! Print this record Send to a friend Show this as PDF file
Propose a translation for Propose a translation for
Please rate this entry:

Average rating: 0 out of 5 (0 Votes )

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry