Skip to main content

Solutions

Products

Recommended products

Questions? We are here to help.
Contact us

Purchase

Questions? We are here to help.

Resources

Report Designer

Accounts payable report options

Show all hidden content
  1. Select an accounts payable report.
  2. Go to
    File
    , then
    Page Setup
  3. Use the
    Report
     tab to modify related options in the
    Print — Options
     and
    Print Reports
     windows (accessed from the
    File
     menu).

Selecting header, footer, and date options

  1. Choose how you want the header or footer to print on the selected accounting report
    • Print on every page
    • On the first page only
    • On all but the first page
    • On the first page with alternate on subsequent pages.
  2. Select the date type and specific date options to make them available in the dropdown list for the selected report.
note
The type of dates that are available vary based on the report type. For example, accounts payable reports include payable dates.

Options for the selected accounts payable report

The following options for accounting method, filtering and sorting, journal entry treatment, accounts payable treatment, and implied filtering apply to the selected report.
note
The implied filter is the default setting that can be overridden by going to File > Print > Options dialog.
Accounting treatment
  • Mark the
    Accounting method
     checkbox to create an optional section in the
    File, Print, Options
     window that helps you select an accounting basis. You can then choose
    Client
    ,
    Accrual
    , or
    Cash
     for reports that include accounts payable or accounts receivable general ledger activity.
    note
    You can set up the accounting basis by going to
    Setup
    ,
    Clients
    , then either
    Accounts Payable
     or
    Accounts Receivable
     tab to be used as the default for reports that use the Client basis and reports that depend on a basis, but do not offer the accounting method options at print time.
  • Mark the
    Balance basis
     checkbox to create an optional section in the
    File, Print, Options
     window that helps you to select a Balance Basis. You can then choose
    Adjusted
    ,
    Report
    ,
    Tax
    , and
    Other
    .
    note
    Basis types applied to amounts in a report or financial statement in the Report Designer through the
    Design Tools
     frame aren't  overwritten with the basis selected in the
    Print – Options
     window at print time
Filtering and sorting
Mark the checkboxes for the data sources to include in the
File, Print, Options
 window when you print the selected report.
note
The Bank Account data source is available by default. All other data sources vary based on the variables on the selected report. For example, for a report that includes client variables, the
Client
 checkbox is displayed in the Filtering and Sorting Options section.
Journal entry treatment
Mark the checkbox for the payroll, accounts payable, or accounts receivable journal entry treatment options to include the corresponding summarizing options in the
File, Print, Options
 window when you print the selected report.
Accounts payable treatment
Mark the checkbox to include the Aging basis, Period definition, or Discount treatment options in the
File, Print, Options
 window when you print the selected report.
Implied type filtering
The options you choose determine the default accounts and transactions (based on their type) included when you print the selected report.
note
You can override certain implied filtering options in the Filtering and Sorting section of the
File, Print, Options
 window when you print the selected report
  • For general ledger accounts
    • None
      . Applies no default filtering so that all general ledger accounts are displayed.
    • Non memo accounts
      . Filters out memo-type accounts so that only non-memo type accounts are displayed.
  • For vendor transactions
    • None
      . Applies no default filtering so all vendor transactions are displayed.
    • AP transactions only
      . Filters out payroll-related vendor transactions so only accounts payable transactions are displayed.
    • PR transactions only
      . Filters out transactions so only payroll-related vendor transactions are displayed.
Implied status filtering
The options you choose here determine the default checks and transactions (based on their status) included when you print the selected report.
note
You can override certain implied filtering options in the Filtering and Sorting section of the
File, Print, Options
 window when you print the selected report.
  • For checks
    • None
      . Applies no default filtering so that all checks (regardless of status) are displayed.
    • Standard
      . Filters out voided, deleted, pending, and unprinted checks so that only standard, live checks are displayed.
    • Unprinted
      . Filters out checks with any status but unprinted, so that only unprinted checks are displayed.
    • Pending
      . Filters out checks with any status but pending, so that only pending checks are displayed, meaning checks that originate from a suspended batch in the
      Actions, Enter Batch Payroll Checks
       window.
  • For transactions
    • None
      . Applies no default filtering so that all transactions (regardless of status) are displayed.
    • Standard
      . Filters out voided and deleted transactions so that only standard, live transactions are displayed.
  • For vendor transactions
    • None
      . Applies no default filtering so that all vendor transactions (regardless of status) are displayed.
    • Open
      . Filters out vendor transactions with any status but open so that only open vendor transactions are displayed.
    • Closed
      . Filters out vendor transactions with any status but closed so that only closed vendor transactions are displayed.
    • Standard
      . Filters out voided and deleted vendor transactions so that only standard, live vendor transactions are displayed.
    • Pending
      . Filters out vendor transactions with any status but pending so that only pending vendor transactions are displayed, meaning vendor transactions that are selected to pay in the Actions > Manage Payments screen.
  • For liabilities
    • None.
       Applies no default filtering so that all liabilities (regardless of status) are displayed.
    • Open.
       Filters out liabilities with any status but open so that only open liabilities are displayed.
    • Closed.
       Filters out liabilities with any status but closed so that only closed liabilities are displayed.
    • Standard.
       Filters out voided and deleted liabilities so that only standard, live liabilities are displayed.
Implied impound status filtering
  • For vendor checks
  • None.
     Applies no default filtering so all vendor checks (regardless of impound status) are displayed.
  • Pending or Funded.
     Filters out non-impound vendor checks so only vendor checks with a pending or funded impound status are displayed.
  • Not applicable.
     Filters out all vendor checks with an impound status so only non-impound vendor checks are displayed.
  • For payroll liabilities
  • None.
     Applies no default filtering so all payroll liabilities (regardless of impound status) are displayed.
  • Pending.
     Filters out payroll liabilities with any impound status but pending so only pending impound status payroll liabilities are displayed.
  • Funded.
     Filters out payroll liabilities with any impound status but funded so only funded impound status payroll liabilities are displayed.
  • Not applicable.
     Filters out all payroll liabilities with an impound status so only non-impound payroll liabilities are displayed.

This article applies to:

  • PRODUCT: Accounting CS
  • Subject: Reports

Related Content