IdealWare Online Users Manual

AR2-06 A/R PROCESSING
25567 System Balancing Test

 

PURPOSE

 

The A/R system balancing test is used to verify that the totals from the various accounts receivable files are in sync and in balance. Files that are compared are your A/R detail file, customer master file and your G/L master file. The program is typically run as part of the month end routine, but it may be run at any time to test the state of your system.

 

It is important to run this program prior to continuing with the other month end programs. If this report indicates that your system is out of balance, consult your Ideal consultant before proceeding with the month end procedures and especially before performing the A/R month end purge.

 

Open A/R cash receipt batches will make the balancing test think that the system is out of balance. If there is an amount in the CASH RECEIPTS TOTAL, update or abort the cash receipt batch(es) and re-print the balancing test.

 

 

PROCEDURE

 

Select Balancing Test from the Accounts Receivable Month End menu.

 

You are taken directly to the Printer Selection screen.

 

PRINTER SELECTION & CONFIGURATION

┌────────────────────────────────────────────────────────────────────────────────┐
│08/14/07                *****  PRINTER SELECTION  *****                         │
│                                                                                â”‚
│                                                                                â”‚
│** MAKE SURE PRINTER IS READY BEFORE PRESSING CR .....                          â”‚
│                                                                                â”‚
│1. PRINTER NAME ................................. P1  OKIDATA 390               â”‚
│                                                                                â”‚
│2. CHARACTERS PER INCH ? (10,12,17) ............. 10                            â”‚
│   SINGLE OR DOUBLE DENSITY ? (S,D) ............. S   SINGLE DENSITY            â”‚
│                                                                                â”‚
│** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS): _            â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS):

 

"1" to change printers.

 

"2" to change the CPI and/or print density.

 

[Enter] to print.

 

[F4] to not print and exit to the menu.

 

[F5] to display a list of printers for selection.

 

An example A/R System Balancing Test follows.

  



                                                     IDEALWARE
07/17/95  18:31:44                                                                                       PAGE: 1
                             A/R SYSTEM BALANCING TEST FOR THE MONTH ENDING Sep 30/94

-------------------------------------------------------------------------------------------------------------------
DESCRIPTION                   CURRENT     31 TO 60     61 TO 90    90 TO 120   120 TO 150     OVER 150        TOTAL
-------------------------------------------------------------------------------------------------------------------

A/R MASTER (/x/iw/51/data/   6,437.62    37,697.37     5,963.39     5,600.40     7,917.55     2,050.43    65,666.76

A/R DETAIL (/x/iw/51/data/   6,437.62    37,697.37     5,963.39     5,600.40     7,917.55     2,050.43    65,666.76

A/R CONTROL (01-00-1200/01-00-0000)                                                                       65,666.76

UNBILLED A/R:                       .00
CASH RECEIPTS TOTAL:           .00



FIELDS:

UNBILLED A/R:         amount committed in the Sale Order Entry system
CASH RECEIPT TOTAL:   amount existing in open Cash Receipt batches