Check Detail Query

 

Training demonstration related to this topic (click to start):

The Check Detail Query report enables you to review check details, such as payees, the addresses to which checks were sent, and summaries of what was printed on checks.

Check Detail Query is a versatile query that accesses check data. The report reads from a new table, so any historical check information, other than unposted checks residing in the check queue, will not be printed on the report.

Running the Report

To run the report:

  1. On the A/P submenu, click Check Detail Query.

    The Check Detail Query dialog box appears.

    The following table describes the fields on the Check Detail Query dialog box.

    Field Description

    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 checks 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.

    Branch

    Branch. The report will include checks 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 #

    Check number. The report will include this check only. Leave this field blank to include all checks.

    GL Chart

    General ledger chart number. The report will include checks associated with this general ledger chart only. Leave this field blank to include checks for all general ledger charts.

    Payee

    Name of the payee printed on the check. The report will include checks for this payee only. Leave this field blank to include checks for all payees.

    Account Type

    Type of account. The report will include checks 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.

    Check Type

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

    • All – Includes details for all posted checks. This option also includes a summary of what printed on each check.
    • Invoice Checks Only – Includes details for posted checks associated with invoice numbers.
    • G/L Checks Only – Includes details for checks posted to the general ledger.
    • Check Summary Only – Includes all posted checks. This option includes only a summary of what printed on each check.
    • Mark for 1099 Only – Includes details for posted checks written out to employee and vendor accounts for which the Mark for 1099 option is selected (see Edit Employee Screen and Edit Vendor Screen).
    • Voided Checks Only – Includes details for voided checks.
    • Check Reversals Only – Includes details for reversed checks.
    • Unposted Checks Only – Includes details for checks stored in the check queue.
    • Group Checks Only – Includes details for checks associated with a group ID.

    Include Expense Payable Offset

    When checked, Expense Offsets display above the 2120 check, without the check number. These offsets are not included in the calculation total on the report.

    Additionally, the Expense Offsets are included in the Batch for Check Detail Query.

    From (for dates)

    Beginning date of a range of check dates. Checks 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 dates)

    Ending date of a range of check dates. Checks 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.

    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 Dates 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

Check Detail Query report example