Report Designer: Options for accounts payable reports

Show expandable text

We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

You can select options on the Report tab of the File > Page Setup dialog to modify related options in the File > Print - Options dialog in the Report Designer and in the File > Print Reports screen.

Select an accounts payable report in the Report Designer, choose File > Page Setup, and click the Report tab.

See also: Making report options available at print time

Selecting header, footer, and date options

  1. Choose how you want the header or footer to print on the selected report. The drop-down list includes options to print on every page, on the first page only, on all but the first page, or on the first page with alternate on subsequent pages.
  2. Select the date type and specific date options to make them available in the drop-down 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 accounts payable dates.

Selecting options for accounts payable reports

The following options for accounting method, filtering and sorting, journal entry treatment, accounts payable treatment, and implied filtering apply to the selected report.

The implied filter is the default setting that can be overridden in the File > Print > Options dialog.

Accounting Treatment Options

Mark the Accounting method checkbox to create an optional section in the File > Print > Options dialog that enables you to select an accounting basis (Client, Accrual, or Cash) for reports that include accounts payable and/or accounts receivable general ledger activity.

Note: The accounting basis can be set up in the Setup > Clients > Accounts Payable tab and/or the Setup > Clients > 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 dialog that enables you to select a Balance Basis (Adjusted, Report, Tax, and Other).

Note: Basis types that are applied to amounts in a report or financial statement in the Report Designer via the Design Tools frame are not overwritten with the basis that is selected in the Print – Options dialog at print time.

Filtering and sorting

Mark the checkboxes for the data sources to include in the File > Print > Options dialog 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 that are inserted 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 appropriate checkbox for the payroll, accounts payable, and/or accounts receivable journal entry treatment options to include the corresponding summarizing options in the File > Print > Options dialog when you print the selected report.

Accounts payable treatment

Mark the appropriate checkbox to include the Aging basis, Period definition, and/or Discount treatment options in the File > Print > Options dialog when you print the selected report.

Implied type filtering

The options you choose here determine the default accounts and transactions (based on their type) that are 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 dialog 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 account filtering so that all vendor transactions are displayed.
  • AP transactions only. Filters out payroll-related vendor transactions so that only accounts payable transactions are displayed.
  • PR transactions only. Filters out accounts payable transactions so that 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) that are 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 dialog 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 screen.

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 that all vendor checks (regardless of impound status) are displayed.
  • Pending or Funded. Filters out non-impound vendor checks so that only vendor checks with a pending or funded impound status are displayed.
  • Not applicable. Filters out all vendor checks with an impound status so that only non-impound vendor checks are displayed.

For payroll liabilities

  • None. Applies no default filtering so that all payroll liabilities (regardless of impound status) are displayed.
  • Pending. Filters out payroll liabilities with any impound status but pending so that only pending impound status payroll liabilities are displayed.
  • Funded. Filters out payroll liabilities with any impound status but funded so that only funded impound status payroll liabilities are displayed.
  • Not applicable. Filters out all payroll liabilities with an impound status so that only non-impound payroll liabilities are displayed.

Was this article helpful?

Thank you for the feedback!