4Reports and Inquiry
Option 5Cash Requirements Projection
Use this function to project the amount of cash needed to pay invoices for a given period. The time periods for projection can be varied and can be based either on the invoice due date or the discount due date. The following processing steps accomplish this job.
- Step 1You can use this function to enter a projection date, choose which date to use when projecting cash required, and choose the lengths of the projection periods.
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 Cash Requirements Projection.
Cash Requirements Projection screen

Data items for the preceding screen are described below:
- Projection Date
Date (YMD)
The system defaults today’s date as the date upon which you want the cash requirements projection to be based. You may change this entry.
- Due Date to Project
Positive number, 1 digit
Indicate which due date to use when projecting the cash required for the unpaid invoices. Valid options are:
- 1
- Transaction Due Date
- 2
- Discount Due Date
If the Transaction Due Date is used to determine the projection period, the gross amount of the invoice is added to the column representing the number of days from the date entered as the Projection Date until the invoice is due.
If the Discount Due Date is used, the net amount of the invoice (gross amount less any applicable discount) is added into the projection period representing the number of days until the discount due date. If no discount due date is present for an invoice, the transaction due date is used to determine the correct projection period.
- Projection Periods
Number, up to 3 digits
Weekly periods are defaulted for the projection periods. If you wish the projection to be based on different periods, enter the number of days for each period.
- Period Ending Dates
Date (YMD) Display only
This date shows you the actual ending date for each projection period to be printed. This date is determined by adding the number of days in the corresponding Projection Period to the Projection Date. For example, if the projection date is 7/01/90 and the projection periods are 7, 14, 21, and 28 days, the Period Ending Dates are 7/08/90, 7/15/90, 7/22/90, and 7/29/90.
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:
Press ENTER to save the information on this screen.
- 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 Vendor Alpha, Vendor, Apply To, Invoice Type and Date/Time Stamp, giving additional sort order choice by Liability Account, 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.
- Step 3This disposition type is used for all standard Accounts Payable reports.
- Step 4According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 5In order to print the Cash Requirements Projection, 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 and Amount Total. Grand totals print at the end, showing Total Balance, Amount Total, Total Number of Invoices and Total Number of Vendors.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 09:59 LGG Page: 1
Cash Requirements Projection
Projected as of 11/08/94 Using Trx Due Date
11/15/94 11/22/94 11/29/94 12/06/94
Apply To Description Trx Due Date Balance 7 & Under 8 To 14 15 To 21 22 To 28 Over 28
=================================================================================================================================
Vendor 00000040 Albert Materials, Inc.
1006 materials 08/25/89 79.50 79.50
103 Albert Materials, Inc. 441.60 441.60
104 Albert Materials, Inc. 352.00 352.00
105 Albert Materials, Inc. 200.00 200.00
106 Albert Materials, Inc. 80.00 80.00
204 Albert Materials, Inc. 100.42 100.42
308 stock 08/25/89 126.17 126.17
311 stock 08/10/89 76.25 76.25
5521 Albert Materials, Inc. 26.82 26.82
8090 Albert Materials, Inc. 222.31 222.31
96215 Materials 09/10/89 63.00 63.00
____________ ____________ ____________ ____________ __________ ____________
— Vendor Totals —> 1768.07 1768.07 0. 0. 0. 0.
============ ============ ============ ============ ========== ============
Vendor 00000080 Sam Jones
12345678 Invoice Description 08/31/94 1000.00 1000.00
ER1005 Aug. expenses thru 8/10 08/31/89 1216.90 1216.90
____________ ____________ ____________ ____________ __________ ____________
— Vendor Totals —> 2216.90 2216.90 0. 0. 0. 0.
============ ============ ============ ============ =========== ============
Vendor 00000010 Miscellaneous Supplier
221 New lobby plants 08/31/90 305.00 305.00
Northwest Interiors
89071001 CUSTOMER REFUNDS 08/31/89 100.00 100.00
Master Sellers Company
DEP6/89 convention room 07/31/89 1200.00- 1200.00-
Westin Hotel
L9980 Office landscaping 08/31/89 620.00 620.00
Evergreen Landscaping
P09844 Yellow page ad 08/31/89 250.00 250.00
Neighborhood Directory
____________ ____________ ____________ ____________ __________ ____________
— Vendor Totals —> 75.00 75.00 0. 0. 0. 0.
============ ============ ============ ============ ========== ============
Vendor 00000020 Pool and Associates
9852-6 brochure 08/31/89 2410.00 2410.00
9877DEP deposit on mailer production 08/10/89 1500.00- 1500.00-
____________ ____________ ____________ ____________ __________ ____________
— Vendor Totals —> 910.00 910.00 0. 0. 0. 0.
============ ============ ============ ============ =========== ============
Vendor 00000060 Travel Planners
11102-1 Williams to Sacramento 09/13/89 386.10 386.10
11562-0 Williams to San Diego 09/03/89 487.00 487.00
11596-1 Jones to DC 08/31/89 985.60 985.60
11598-1 Jones to Columbus 09/04/89 742.50 742.50
11600-0 Peters to Memphis 09/08/89 802.00 802.00
11651-1 VP to New York 09/08/89 1125.60 1125.60
____________ ____________ ____________ ____________ __________ ____________
— Vendor Totals —> 4528.80 4528.80 0. 0. 0. 0.
============ ============ ============ ============ ============ ===========