Customer Balancing Audit Report overview

Customer > Reports > AR Reports > ARRB

Function acronym: ARRB

Use this report to review balance information for each of your customers.

It also provides a means to correct any discrepancies that exist between a customer's balances record and the Customer Transaction Entry record. If discrepancies exist, you can change the balances on the Customer Setup record. You can display discrepancies on the report and make manual changes. Run this report daily. Because of the time that is required to compile the report, run the report after normal business hours.

Whenever the Customer Balancing Audit Report updates Customer Setup or Customer Ship To Setup balances, an internal SASB record is created to indicate which values changed. SASB records are not created for customer only balance updates. Run theSA Balance Maintenance Report to view SASB records using the .

During processing, these Customer Setup or Customer Ship To Setup balances are compared with the Customer Transaction Entry file:

  • Periods 1 – 5
  • Future Invoices
  • COD Balance
  • Unapplied Cash
  • Misc Charges
  • Service Charges
  • Customer Periods 1 – 5
  • Customer Future Invoices
  • Customer COD Balance
  • Customer Unapplied Cash
  • Customer Misc Charges
  • Customer Service Charges
  • Ship to Periods 1 – 5
  • Ship to Future Invoices
  • Ship to COD Balances
  • Ship to Unapplied Cash
  • Ship to Misc Charges
  • Ship to Service Charges

For customer ship to records with an out-of-balance condition, the amount out of balance and the total balances previously listed are included on the report. The on order balance is not included in this review. Customer ship to record balances that are greater than the transaction record balance are noted with an up arrow symbol next to the out of balance amount. Transaction record balances that are greater than the customer ship to record balances are noted with a down arrow symbol.

If you update customer ship-to files, the Customer Setup or Customer Ship To Setup records are adjusted to correct out of balance amounts. The transaction file is not adjusted. If you update customer files automatically or manually correct balances in Customer Setup or Customer Ship To Setup , the SASB record is updated.