4Reports and Inquiry
Option 5Cash Receipts Projection
Use this function to print summaries of projected cash receipts. The number of days projected can be varied, allowing you to do comparative analyses. The following processing steps accomplish this job.
- Step 1You can use this function to enter a projection date, choose which date to project from, and choose the length of the projection periods.
On the following pages, the screen displayed by this function is shown.
The screen shown below allows you to enter parameters needed for the Cash Receipts Projection report.
Transaction Processing menu
Data items for the preceding screen are described below:
- Projected From Date
Date (YMD) Required
Specify the date from which the transactions to be printed will be projected. By default, the system displays today’s date. You can enter a new date to override the display.
- Date to Use as Basis
Upper case, 1 character Required
The system displays a default value from the Parameters file. If you wish, you can change it. This entry signifies which date to use as the basis for projections. Valid options are:
- 1
- Invoice date
- 2
- Due date
- Projection Periods
Number, up to 3 digits
The system displays, in days, a set of weekly projection periods. You can override any of the period values.
Each projection period refers to either the invoice date or the due date, depending on the entry in the Date to Use as Basis field. A positive entry indicates the number of days ahead that you want to project.
- Period Ending Dates
Date (YMD) Display only
These dates shown you the actual ending date for each projection period that is 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 will be 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 Customer Alpha, Customer, Apply To, and Date/Time, giving additional sort order choice by Post Year, Post Month, and Account Number, with the option to change modifiable parameters at run time. Selection of data records is provided by Account Number, with the option to change modifiable parameters at run time. Selection of data records is provided by Account Number, Customer, Post Month, and Post Year, with the option to enter userspecified comparisons at run time.
- Step 3This is the standard disposition used for all reports not printed on special forms.
- Step 4According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 5In order to print the Cash Receipts Projection, this step formats the Transactions information. As appropriate, group headings appear whenever a change occurs in Customer. If requested, totals appear whenever a change occurs in Customer or Account Number. When totals are specified, the following items are accumulated: Total Balance, Amount Total, and Ageing Period Percent. Grand totals print at the end, showing Total Balance, Amount Total, and Ageing Period Percent.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:07 LGG Page: 1
Cash Receipts Projection
Projected as of 11/08/94 Using Due Date
11/15/94 11/22/94 11/29/94 12/06/94
Apply To Description Date Balance 7 & Under 8 To 14 15 To 21 22 To 28 Over 28
=================================================================================================================================
Customer 00000010 Alexander's, Inc.
0040 Service Charge 06/10/89 16.84 16.84
1001 6/6/89 Supply shipme 07/10/89 20.00- 20.00-
1013 chair shipment 6/12/ 07/21/89 1296.87 1296.87
1016 shelving units shipp 07/21/89 1368.54 1368.54
1018 correction 08/12/89 275.98 275.98
2002 7/6/89 shipment 08/09/89 1782.90 1782.90
2022 7/26/89 shipment 08/30/89 1896.55 1896.55
3001 Special order shipme 09/10/89 778.92 778.92
3002 8/2/89 shipment 09/10/89 1396.88 1396.88
401 Opening Entry 05/14/89 40.82- 40.82-
7210 deposit 07/31/89 1200.00- 1200.00-
7211 deposit 07/31/89 1700.00- 1700.00-
89071000 Monthly shipment 08/09/89 600.00 600.00
—————— —————— —————— —————— —————— ——————
— Customer Totals —> 6452.66 6452.66 0. 0. 0. 0.
100.0 % .0 % .0 % .0 % .0 %
============ ============ ============ ============ ============ ============
Customer 00000040 Burlington Enterprises
100001 P10982 09/11/89 100.00 100.00
1003 P10982 09/11/89 831.05 831.05
1023 6/28/89 shipment 07/30/89 57.45 57.45
2013 7/19/89 shipment 08/20/89 1267.58 1267.58
2016 7/19 shipment 08/20/89 3954.25 3954.25
3003 8/5/89 shipment 09/10/89 4589.65 4589.65
3004 8/10/89 shipment 09/10/89 1896.35 1896.35
—————— —————— —————— —————— —————— ——————
— Customer Totals —> 12696.33 12696.33 0. 0. 0. 0.
100.0 % .0 % .0 % .0 % .0 %
============ ============ ============ ============ ============ ============