Running the Cash Receipts Query Report

The Cash Receipts Query report lists cash receipts that exist in GlobalWare. Voided cash receipts are excluded from the report.

Running the Report

To run the report:

  1. On the A/R submenu, click Cash Receipts Query.

    The Cash Receipts Query dialog box appears.

    The following table describes the fields on the Cash Receipts Query dialog box.

    Field Description

    From (for date range)

    Beginning date of a range of cash receipt dates. Cash receipts within the specified range of dates will be included on the report. You must use this date in conjunction with the To date to define a range.

    To (for date range)

    Ending date of a range of cash receipt dates. Cash receipts within the specified range of dates will be included on the report. You must use this date in conjunction with the From date to define a range.

    Account ID

    Account ID. Specify a full account ID to include checks for this account ID only.

    For customer accounts, you can also specify @TAGGED to include cash receipts for tagged accounts only. You can also specify @ followed by a customer interest code (for example, @SKI) to include checks for only accounts with that interest.

    Leave this field blank to include checks for all accounts.

    To find and select an account ID, click the lookup () button. The Find an Account ID screen appears. For details, see Using the Lookup Buttons and Screens.

    Account Type

    Type of account. The report will include cash receipts for this type of account only. Select one of the following options from the drop-down list:

    • All – Includes all accounts.
    • Customers Only – Includes only customer accounts.
    • Employees Only – Includes only employee accounts.
    • Providers Only – Includes only provider accounts.
    • Vendors Only – Includes only vendor accounts.

    Branch

    Branch. The report will include cash receipts for this branch only. Only the branches to which the employee has access display. If All is selected, all branches to which the user has access are considered.

    To find and select a branch, click the lookup () button. The Find Branch screen appears. For details, see Using the Lookup Buttons and Screens.

    Check Type

    Type of check. The report will include cash receipts for this type of check only. Select one of the following options from the drop-down list:

    • All – Includes cash receipts for all posted checks.
    • Invoice Checks Only – Includes cash receipts posted to anything other than the general ledger (that is, on account or to invoices or other transactions).
    • G/L Checks Only – Includes cash receipts posted to the general ledger.
    • UnPosted Checks – Includes cash receipts for checks stored in the check queue.

    A cash receipt posted partially to the general ledger and partially to transactions will appear on the report if you select either G/L Checks Only or Invoice Checks Only. These are indicated with "Inv/GL" in the Type column on the report.

    Travel Type

    Type of travel. The report will include cash receipts for this type of travel only. Select All to include all travel types.

    Sort Level 1

    First-level field to use for sorting report data. The following fields are available from the drop-down list: Account Id, Account Type, Branch, Chart, Check #, Check Type, Control #, From, Receipt #, and Travel Type. You can also select none.

    Subtotal (for sort level 1)

    Indicates whether to subtotal based on the field specified in Sort Level 1.

    Page Break(for sort level 1)

    Indicates whether to start new report pages based on the field specified in Sort Level 1.

    Sort Level 2

    Second-level field to use for sorting report data. The following fields are available from the drop-down list: Account Id, Account Type, Branch, Chart, Check #, Check Type, Control #, From, Receipt #, and Travel Type. You can also select none.

    Subtotal (for sort level 2)

    Indicates whether to subtotal based on the field specified in Sort Level 2.

    Page Break(for sort level 2)

    Indicates whether to start new report pages based on the field specified in Sort Level 2.

    Sort Level 3

    Third-level field to use for sorting report data. The following fields are available from the drop-down list: Account Id, Account Type, Branch, Chart, Check #, Check Type, Control #, From, Receipt #, and Travel Type. You can also select none.

    Subtotal (for sort level 3)

    Indicates whether to subtotal based on the field specified in Sort Level 3.

    Page Break(for sort level 3)

    Indicates whether to start new report pages based on the field specified in Sort Level 3.

  2. Complete the fields as appropriate.

    Note: The date fields for Date Range are required.

  3. Choose one of the following print options:

    • To print the report immediately, click PRINT.

      The Send to dialog box appears. Select a report destination. For more information, see Printing Overview.

    • To store the report as part of a batch for printing later, click BATCH.

      The Choose a Batch dialog box appears. For more information, see Batch Printing.

Report Example

Report Notes