Ideal Online Documentation

25658 A/R LISTINGS, REPORTS AND FORMS
AR5-01 Aged Trial Balance

 

PURPOSE

 

For each customer this report prints total receivables as well as aged subtotals. In addition, other information can be included for credit management purposes. Although this report can be printed at any time during the month, it is recommended that you include it in your month/year end routine since this report cannot be backdated.

 

A/R Aged Trial Balance is accessed from:

  • A/R Report and Month End menus

 

PROCEDURE

 

When you select Aged Trial Balance from the A/R Report or Month End menu the following prompts display.

 

** ENTER REPORT DATE (CR FOR SYSTEM DATE):

 

Enter the date from which you want the report aged.

 

[Enter] for current system date.

 

The date entered here must be within the current A/R period, past or future dated months are not allowed.

 

 

** ALPHA OR NUMERIC SEQUENCE (A/N):

 

"A" to print in alpha customer code sequence.

 

"N" to print in numeric customer code sequence (if available).

 

[Enter] to accept the default "A".

 

** STARTING CUSTOMER CODE (CR FOR FIRST):

 

Enter the starting alpha or numeric customer code.

 

[Enter] for the first customer.

 

** ENDING CUSTOMER CODE (CR FOR LAST):

 

Enter the ending alpha or numeric customer code.

 

[Enter] for the last customer.

 

** INCLUDE SALES DATA? (Y/N):

 

"Y" to print sales information.

 

This includes sales and profit statistics.

 


"N" to not print sales information.

 

** PRINT FULL ADDRESS? (Y/N):

 

"Y" to print name, address and phone number.

 

"N" to print only customer name.

 

** ENTER AGING CATEGORY:

 

[Enter] to select all aging categories.

 

"1" to select only customers with a 30 to 60 day balance.

 

"2" to select only customers with a 60 to 90 day balance.

 

"3" to select only customers with an older than 60 day balance.

 

"4" to select only customers with an older than 90 day balance.

 

** STORE CODE (CR FOR ALL):

 

Enter the desired store code.

 

If a store code is specified, only customers that reference that store code will be printed.

 

 

[Enter] to select all stores.

 

[F5] to display list for selection.

 

** SALESMAN CODE (CR FOR ALL):

 

Enter a salesman code.

 

Applicable only if a specific store code is specified. If a salesman code is specified, only customers that reference that salesman code as their responsible salesperson will be printed.

 

 

[Enter] to select all salesmen.

 

[F5] to display list for selection.

 

** MINIMUM YTD SALES $ (CR=ALL):

 

Enter the minimum year to date sales dollars.

 

Anything less than this amount will not be printed.

 

 

[Enter] for any sales dollars amount.

 

** HOW MANY COPIES ? (CR=1):

 

Enter the number of copies to print.

 

[Enter] to print one copy.

 

** INCLUDE PROFIT FIGURES (Y/N):

 

"Y" to print profit dollars and profit percent statistics.

 

"N" to not print the statistics.


** PRESS 'CR' TO CONTINUE:

 

[Enter] to continue to printer selection menu.

 

[F4] to exit to menu.

 

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 Aged Trial Balance follows.

  



                                                         IDEALWARE
07/12/95 12:34:29                                                                                           PAGE: 1
                                               A/R AGED TRIAL BALANCE AS AT 07/05/94
                           FOR ACCOUNTS WITH CURRENT TO 60 DAY BALANCES ONLY - YARD: ALL - SALESMAN: ALL
-------------------------------------------------------------------------------------------------------------------
CODE      CUSTOMER/                         ACCOUNT                                                       OLDER
PHONE #                       LAST PAYMENT  BALANCE    CURRENT    Jun/94    May/94    Apr/94    Mar/94 CREDIT LIMIT
-------------------------------------------------------------------------------------------------------------------
ABACON    ABACAB CONSTRUCTION LTD          8,423.48     299.48  4,777.50  2,341 25  1,005.25    
C/O HARRY SMITH
1555 BOUNDARY ROAD
BURNABY, B.C.
V4R 1D4
299-9090                                                                                                 10,000.00
 (MTD SALES:      262.70 ) (MTD PROFIT$:    1,050.84 )
 (YTD SALES:    8,847.46 ) (YTD PROFIT$:    1,050.84 ) (YTD PROFIT%:  11.88 )
 (LYR SALES:         .00 ) (LYR PROFIT$:         .00 )

AHCON     A&H CONCRETE LTD                   795.82               795.82
C/O BILL JONES
5000-166TH STREET
SURREY,   B.C.
V5E 2D5
555-6666               264.20 : 08/12/94                                                                  2,000.00
 (MTD SALES:         .00 ) (MTD PROFIT$:      732.10 )
 (YTD SALES:    2,129.90 ) (YTD PROFIT$:      732.10 ) (YTD PROFIT%:  34.37 )
 (LYR SALES:         .00 ) (LYR PROFIT$:         .00 )


...

WATCON    WATLEY CONNORS                     849.31               849.31
C/O JOHN SMITH
4444 TRAIL AVE
VANCOUVER, B.C.
V5F 1D5
222-3333               749.60 : 08/17/94                                                                  4,000.00
 (MTD SALES:         .00 ) (MTD PROFIT$:    1,831.10 )
 (YTD SALES:    7,167.26 ) (YTD PROFIT$:    1,831.10 ) (YTD PROFIT%:  25.55 )
 (LYR SALES:    9,513.35 ) (LYR PROFIT$:    8,414.24 )

                                         ---------- ---------- --------- --------- --------- --------- ----------
RECORDS: 5                                24,961.35   1,358.55 16,256.10  5,452.55  1,552.55     41.35     300.25 
                                         ========== ========== ========= ========= ========= ========= ==========
                                             100.00       5.44     65.13     21.84      6.22       .17       1.20