APPX Software Library

4Reports and Inquiry

Option 2Ageing Report

Use this function to print vendor balances broken down by ageing category. Detail on transactions can also be printed if you choose. The following processing steps accomplish this job.

  1. Step 1You can use this function to enter the ageing date, choose which date to use when ageing transactions, define the ageing periods, and choose whether or not to print the transaction detail.

On the following pages, the screen displayed by this function is shown.

The screen shown below allows you to enter information required to print the Ageing report.

Ageing screen

The Accounts Payable Ageing Screen
Figure 53

Data items for the preceding screen are described below:

Ageing Date

Date (YMD)

You can specify the date from which the printed transactions are aged. By default, the system displays today’s date. You can enter a new date to override the display.

Date to Age

Positive number, 1 digit

Indicate which date you would like to use for ageing the transactions. The Ageing Type is displayed from the Parameters file but may be changed. Valid options are:

1
Transaction Date
2
Due Date
Ageing Periods

Number, up to 3 digits

The system displays the Transaction Register Periods that were entered in the Parameters file. You can override any ageing period.

Each ageing period refers to either the invoice date or the due date, depending on the entry in the Date To Age field. A positive entry indicates the number of days after the invoice or due date. A negative entry indicates the number of days before the invoice or due date.

For example, ageing entries of ‘0’ and ‘30’ would define the following three periods:

0 and before

1 to 30

31 and above

Period Ending Dates

Date (YMD) Display only

This date shows you the actual ending date for each ageing period to be printed. This date is determined by subtracting the number of days in the corresponding Ageing Period from the Ageing Date. For example, if the Ageing Date is 6/30/90 and the ageing periods are 0, 30, 60, and 90, the Period Ending Dates are 6/30/90, 5/31/90, 5/1/90, and 4/1/90.

Print Summary?

Y or N Default N Required

Enter ‘Y’ to print only the summary report. Enter ‘N’ to include the detail.

The entered data is validated. During validation, including access to other files, conditions may be found which cause messages to be displayed. Errors (E), Warnings (W), and Messages (M) that may result are shown below:

  • EAgeing Periods Must Be in Ascending Order

Press ENTER to save the information on this screen.

  1. Step 2In preparation for performing a sort/selection process on the Transactions information, this step provides you with a default sequencing of data records by Liability Account, Vendor Alpha, Vendor, Apply To, Invoice Type and Date/Time Stamp, giving additional sort order choice by Post Year and Post Month, with the option to change modifiable parameters at run time. Selection of data records is provided by Liability Account, Vendor, Post Month and Post Year, with the option to enter user-specified comparisons at run time.
  2. Step 3This disposition type is used for all standard Accounts Payable reports.
  3. Step 4According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  4. Step 5In order to print the Ageing Report (Summary), this step formats the Transactions information. As appropriate, group headings appear whenever a change occurs in Post Month, Liability Account or Vendor. If requested, totals appear whenever a change occurs in Apply To, Vendor, Liability Account or Post Month. When totals are specified, the following items are accumulated: Total Balance, Amount Total and Ageing Period Percent. Grand totals print at the end.

A sample output is shown below.

                                                       Expert Computing, Inc.
11/08/94 09:51                                                                                                       LGG Page:  1
                                                           Ageing Report

                                              Aged as of 11/08/94   Using Due Date

                                                      11/08/94        10/09/94        09/09/94        08/10/94
Vendor                                   Balance      0  & Under      1  To  30      31  To  60      61  To  90        Over  90
=================================================================================================================================

Account 1061001000  Prepaids & Deposits

00000010  Miscellaneous Supplier             .00              0.              0.              0.              0.             .00
00000020  Pool and Associates            1500.00-             0.              0.              0.              0.         1500.00-
                                    ___________     ____________    ____________    ____________    ___________     ____________
          — Account Totals —>          1500.00-             0.              0.              0.              0.         1500.00-
                                                           .0  %           .0  %           .0  %           .0  %       100.0  %
                                    ============    ============    ============    ============    ============    ============

Account 2010001001  Accounts Payable, Sales

00000040  Albert Materials, Inc.          124.00-             0.              0.              0.              0.          124.00-
00000070  Insurances Unlimited               .00              0.              0.              0.              0.             .00
00000080  Sam Jones                      2216.90              0.              0.              0.         1000.00         1216.90
00000010  Miscellaneous Supplier           75.00              0.              0.              0.              0.           75.00
00000030  Mountain Air Conditionin           .00              0.              0.              0.              0.             .00
00000090  George Peters                  1198.50              0.              0.              0.              0.         1198.50
00000020  Pool and Associates            2410.00              0.              0.              0.              0.         2410.00
00000060  Travel Planners                4528.80              0.              0.              0.              0.         4528.80
00000100  Kris Williams                  1156.33              0.              0.              0.              0.         1156.33
00000050  Hardware Services, Inc.         625.88              0.              0.              0.              0.          625.88

                                     ___________     ____________    ____________    ____________    ___________     ____________
          — Account Totals —>         12087.41              0.              0.              0.         1000.00        11087.41
                                                           .0  %           .0  %           .0  %           8.3  %        91.7  %
                                    ============    ============    ============    ============    ============    ============

Account 2030001001  Retention Payable, Sales

00000040  Albert Materials, Inc.         1892.07         1892.07              0.              0.              0.              0.

                                    ___________     ____________    ____________    ____________    ___________     ____________
          — Account Totals —>          1892.07         1892.07              0.              0.              0.              0.
                                                         100.0  %           .0  %           .0  %           .0  %          .0  %
                                    ============    ============    ============    ============    ============    ============

Account 4010000001WH  Cost of Goods Sold, Sales/Whls

00000040  Albert Materials, Inc.             .00             .00              0.              0.              0.              0.

                                    ___________     ____________    ____________    ____________    ___________     ____________
          — Account Totals —>              .00             .00              0.              0.              0.              0.
                                                           .0  %           .0  %           .0  %           .0  %          .0  %
                                    ============    ============    ============    ============    ============    ============


                                    ___________     ____________    ____________    ____________    ___________     ____________
            — Grand Totals —>         12479.48         1892.07              0.              0.         1000.00         9587.41
                                                           15.2  %           .0  %           .0  %          8.0  %        76.8  %
                                    ============    ============    ============    ============    ============    ============
  1. Step 6In order to print the Ageing Report (Detail), this step formats the Transactions information. As appropriate, group headings appear whenever a change occurs in Post Month, Liability Account or Vendor. If requested, totals appear whenever a change occurs in Apply To, Vendor, Liability Account or Post Month. When totals are specified, the following items are accumulated: Total Balance, Amount Total and Ageing Period Percent. Grand totals print at the end.

A sample output is shown below.

                                                       Expert Computing, Inc.
11/08/94 09:52                                                                                                       LGG Page:  1
                                                           Ageing Report

                                              Aged as of 11/08/94   Using Due Date

Apply To  Description                         Balance     0  & Under     1  To  30     31  To  60     61  To  90       Over  90
=================================================================================================================================

Account 1061001000  Prepaids & Deposits


Vendor  00000010  Miscellaneous Supplier

                                         ____________   ____________   ____________   ___________    ____________   ____________
                — Vendor Totals —>              .00             0.             0.             0.             0.             0.
                                                               .0  %          .0  %          .0  %          .0  %          .0  %
                                         ============   ============   ============   ============   ============   ============


Vendor  00000020  Pool and Associates

9877DEP   deposit on mailer production      1500.00-                                                                    1500.00-
                                         ____________   ____________   ____________   ___________    ____________   ____________
                — Vendor Totals —>          1500.00-            0.             0.             0.             0.         1500.00-
                                                                 .0  %          .0  %          .0  %          .0  %      100.0  %
                                         ============   ============   ============   ============   ============   ============


                                         ____________   ____________   ____________   ___________    ____________   ____________
               — Account Totals —>          1500.00-            0.             0.             0.             0.        1500.00-
                                                                 .0  %          .0  %          .0  %          .0  %      100.0  %
                                         ============   ============   ============   ============   ============   ============

Account 2010001001  Accounts Payable, Sales


Vendor  00000040  Albert Materials, Inc.

34576     write off retention                   36.00-                                                                     36.00-
84700     write off retention                   88.00-                                                                     88.00-
                                         ____________   ____________   ____________   ___________    ____________   ____________
                — Vendor Totals —>             124.00-            0.             0.             0.             0.         124.00-
                                                                 .0  %          .0  %          .0  %          .0  %      100.0  %
                                         ============   ============   ============   ============   ============   ============


Vendor  00000010  Miscellaneous Supplier

221       New lobby plants                     305.00                                                                     305.00
          Northwest Interiors
89071001  CUSTOMER REFUNDS                     100.00                                                                     100.00
          Master Sellers Company
DEP6/89   convention room                     1200.00-                                                                   1200.00-
          Westin Hotel
L9980     Office landscaping                   620.00                                                                     620.00
          Evergreen Landscaping
P09844    Yellow page ad                       250.00                                                                     250.00
          Neighborhood Directory
                                         ____________   ____________   ____________   ___________    ____________   ____________
                — Vendor Totals —>              75.00             0.             0.             0.             0.          75.00
                                                                 .0  %          .0  %          .0  %          .0  %      100.0  %
                                         ============   ============   ============   ============   ============   ============