Report Designer: Options for letters

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 a letter 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 letter. 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 to print on the selected letter.

Notes

  • The Alternate Header and Footer regions in a letter can be used for letters that are more than one page in length. Choose Print on first page with alternate on subsequent pages on the Reports tab of the File > Page Setup dialog, for both the Header and Footer fields.
  • The type of dates that are available vary based on the report type. For example, letters include standard dates, bank account statement dates, accounting dates, accounts payable dates, and accounts receivable dates.

Selecting options for letters

The following options for accounting method, filtering and sorting, journal entry treatment, accounts payable/receivable treatment, implied filtering, and third-party sick pay treatment apply to the selected letter.

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

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.

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.

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.

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

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

The options you choose here determine the default checks and transactions (based on their status) that will be 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 will be 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.

For customer transactions

  • None. Applies no default filtering so that all customer transactions (regardless of status) are displayed.
  • Open. Filters out customer transactions with any status but open so that only open customer transactions are displayed.
  • Closed. Filters out customer transactions with any status but closed so that only closed customer transactions are displayed.
  • Standard. Filters out voided and deleted customer transactions so that only standard, live customer transactions are displayed.

For payroll checks

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

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

Use the following options to specify whether or not check amounts for third-party sick pay should be excluded from the selected report.

  • None. All check amounts for third-party sick pay are included in the selected report.
  • Employer taxes only. Only employer tax portions of check amounts for third-party sick pay are included in the selected report.

If you attempt to delete a letter that is attached to a report profile, the application generates a Values do not exist error. Prior to deleting a specific letter, we recommend that you verify and remove it from all report profiles.

Top of page

Was this article helpful?

Thank you for the feedback!