APPX Software Library

4Reports and Inquiry

Option 6Daily Cash Receipts

Use this function to print a report that shows all cash receipts that have been posted, in sequence by posting date. The following processing steps accomplish this job.

  1. Step 1This function allows you to enter a low and high cash account range in order to print the Daily Cash Receipts report.

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

The screen shown below allows you to enter parameters needed for the Daily Cash Receipts report.

Transaction Processing menu

The Accounts Receivable Transaction Processing Menu
Figure 56

Data items for the preceding screen are described below:

Begin Cash Account

Upper case, up to 12 characters Required

Supply the beginning account in the cash account range for the Daily Cash Receipts report.

End Cash Account

Upper case, up to 12 characters Required

Supply the ending account in the cash account range for the Daily Cash Receipts report. If only one account is to be printed, the Start and End Cash Accounts should be the same.

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:

  • EEnd Account Must Be Higher Than Begin Account

Press ENTER to save the information on this screen.

  1. Step 2In preparation for performing a sort/selection process on the Month To Date Postings information, this step provides you with a default sequencing of data records by Transaction Date, Account Number, Operator ID, and Control No, giving additional sort order choice by Post Month and Post Year, with the option to change modifiable parameters at run time. Selection of data records is provided by Transaction Date, Operator ID, Control No, Post Month, and Post Year, with the option to enter user-specified comparisons at run time.
  2. Step 3This is the standard disposition used for all reports not printed on special forms.
  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 Daily Cash Receipts, this step formats the Month To Date Postings information. The following data items are shown: Operator ID, Control No, Transaction No, Post Month, Post Year, Customer, Name, Description, Transaction Date, Invoice/Check Number, Apply To, and Amount. As appropriate, group headings appear whenever a change occurs in Transaction Date or Account Number. If requested, group totals appear whenever a change occurs in Account Number or Transaction Date.

A sample output is shown below.

                                                       Expert Computing, Inc.
11/08/94 15:08                                                                                                       LGG Page:  1
                                                        Daily Cash Receipts

           Trx   Post
Op ID/Cont No    Mo Yr  Customer                                Description          Trx Date  Check No  Apply To       Amount
=================================================================================================================================

Date Check Received 06/10/89

Account 1030001001WH  Accts Receiv, Sales/Wholesale

    / 0000 0000  06 89  00000040 Burlington Enterprises         Svc Charge Write Off 06/10/89  404       404             22.22-
    / 0000 0000  06 89  00000040 Burlington Enterprises         Svc Charge Write Off 06/10/89  604       604            101.90-
SRR / 0004 0001  08 89  00000010 Burlington Enterprises         Service Charge       06/10/89  S0100     0040            16.84
SRR / 0004 0002  08 89  00000040 Burlington Enterprises         Service charge       06/10/89  S0101     604            101.90
SRR / 0004 0003  08 89  00000040 Burlington Enterprises         Service charge       06/10/89  S0102     404             22.22
                                                                                                                         —————
                                                                                — Account Number Subtotals —>            16.84
                                                                                                                    ===========


Account 1050001000  Service Charges Receivable

SRR / 0004 0001  08 89  00000010 Burlington Enterprises         Service charge       06/10/89  S0100     0040            16.84-
SRR / 0004 0002  08 89  00000040 Burlington Enterprises         Service charge       06/10/89  S0101     604            101.90-
SRR / 0004 0003  08 89  00000040 Burlington Enterprises         Service charge       06/10/89  S0102     404             22.22-
                                                                                                                         —————
                                                                                — Account Number Subtotals —>           140.96-
                                                                                                                    ===========


Account 3060000000  Miscellaneous Income

    / 0000 0000  06 89  00000040 Burlington Enterprises         Svc Charge Write Off 06/10/89  404       404             22.22
    / 0000 0000  06 89  00000040 Burlington Enterprises         Svc Charge Write Off 06/10/89  604       604            101.90
                                                                                                                         —————
                                                                                — Account Number Subtotals —>           124.12
                                                                                                                    ===========

                                                                                                                        —————
                                                                              — Transaction Date Subtotals —>              .00
                                                                                                                    ===========


Date Check Received 06/30/89

Account 1030001001WH  Accts Receiv, Sales/Wholesale

    / 0000 0000  06 89  00000010 Alexander's, Inc.              Svc Charge Write Off 06/30/89  401       401             20.26-
    / 0000 0000  06 89  00000020 Master Sellers Company         Svc Charge Write Off 06/30/89  333       333              2.00-
                                                                                                                         —————
                                                                                — Account Number Subtotals —>            22.26-
                                                                                                                    ===========