Ideal Online Documentation

24754 A/P LISTINGS, REPORTS AND FORMS
AP5-03 Aged Trial Balance

 

PURPOSE

 

Aged Trial Balance will show for each supplier the total amount owing to them as well as aged subtotals, based on a user specified aging date.

 

Aged Trial Balance is accessed from:

  • Accounts Payable Month End menu.

 

PROCEDURE

 

Select Aged Trial Balance from the Accounts Payable Month End menu.

 

** AGING DATE ? (CR FOR PERIOD ENDING DATE): MMDDYY

 

Enter the aging date.

 

Typically, if doing your month end this would be the last day of the current month.

 

 

[Enter] for last period ending date.

 

** CURRENCY CODE (CR=ALL): __

 

Enter the desired currency code.

 

[Enter] to include all currency codes.

 

** GROSS OR NET AMOUNTS ? (G/N):

 

[Enter] or "G" for gross amounts.

 

"N" for net amounts (gross minus discounts).

 

[F3] to re-enter previous field.

 

[F4] to exit to menu.

 

** START AT ? (CR=FIRST):

 

Enter the code of the supplier to begin the report.

 

[Enter] for the first supplier in the system.

 

[F3] to re-enter previous field.

 

[F4] to exit to menu.

 

** END AFTER ? (CR=LAST):

 

Enter the code of the supplier to end the report.

 

[Enter] for last supplier in the system.

 

[F3] to re-enter previous field.

 

[F4] to exit to menu.

 

** AGED CATEGORY ? (30/60/90) OR CR FOR ALL:

 

Enter the aged category (30, 60 or 90 days).

 

[Enter] for All categories.

 

[F3] to re-enter previous field.

 

[F4] to exit to menu.

 

** GUARANTEED ONLY ? (Y/N/CR):

 

[Enter] for both guaranteed and not guaranteed.

 

"Y" for guaranteed only.

 

"N" for not guaranteed only.

 

[F3] to re-enter previous field.

 

[F4] to exit to menu.

 

** INCLUDE INVOICES FROM HISTORY? (Y/N): N

 

[Enter] or "N" to not include invoices from history.

 

This is the default.

 

 

"Y" to include invoices from history.

 

If you are printing the report using a previous month's aging date.

 

 

[F3] to re-enter previous field.

 

[F4] to exit to menu.

 

** PRESS CR TO CONTINUE:

 

[Enter] to generate the report.

 

[F3] to re-enter previous field.

 

[F4] to exit to menu.

 

You are taken to the print 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 Aged Trial Balance follows.

  



                                                  IDEAL BUILDING SUPPLIES LTD.
07/24/96  17:21:58                                                                                                    PAGE: 1

                      A/P AGED TRIAL BALANCE BASED ON GROSS FOR ALL AGE CATEGORIES FOR AGING DATE 06/30/96
                                               (BOTH GUARANTEED & NOT GUARANTEED)

--------------------------------------------------------------------------------------------------------------------------------
SUPPLIER                                            GUARAN?         0-30         31-60         61-90          91 +       BALANCE
--------------------------------------------------------------------------------------------------------------------------------

ACKLA       ACKLANDS                                   N             .00        562.82           .00      4,035.67      4,598.49

BUROF       BURNABY OFFICE                             N             .00           .00           .00        746.51        746.51

CINDU       CANADIAN INDUSTRIAL                        N             .00           .00           .00        409.92        409.92

MACMI       MACMILLAN BLOEDEL                          N        7,891.25           .00           .00           .00      7,891.25

TAIGA       TAIGA FOREST PRODUCTS LTD                  N        3,994.68           .00           .00     27,592.09     31,586.77

TARCO       TARGET CONCRETE PRODUCTS                   N             .00           .00           .00      5,012.04      5,012.04

                                                              ----------    ----------    ----------    ----------    ----------
                                                               11,885.93        562.82           .00     37,796.23     50,244.98
                                                              ==========    ==========    ==========    ==========    ==========



  
FIELDS:                                     

SUPPLIER   supplier code and description
GUARAN?    guaranteed Yes/No
0-30       0-30 days
31-60      31-60 days
61-90      61-90 days
91 +       91 days and more
BALANCE    amount totals