Sales List General Tab

Use the General tab to select report options for the Sales List report and to save sets of options for reuse.

Contents

Field Description
Report Name You can change the default report name.
Tax Code Select <all tax codes> if you want the report to include transactions for all tax codes. To select one or more tax codes, use the lookup.

Time Frame

Use these options to specify the timeframe for data included on the report.

Field Description
Current Period The report shows data for the accounting period that is currently open.
Year-to-Date The report shows data for the current fiscal year through the current accounting period.
Range of Periods Specify a range of accounting periods.
Ranges of Dates Specify the start and end dates of the range.
Field Description
Client Detail

Select the level of detail:

  • Totals Only: The report only displays client totals for tax basis, tax amount, and tax received.
  • Tax Code Summary: For each client, the report displays tax code totals for tax basis, tax amount, and tax received.
  • All Transactions: For each client and tax code, the report displays the following for each sales transaction: transaction date, transaction type, invoice number, fiscal period, posting sequence number, project number, task number, phase number, tax basis, tax amount, and tax received.
Foreign Tax Registered Clients Only Select this check box if you only want to report on clients with a tax country that is different from your enterprise's tax country.

You specify client tax countries in the Firms hub.

You specify your enterprise's tax country on the Tax Auditing tab of the Account Company Settings form (Settings > Accounting > Company).

Print Received Details

Select this option to add the Tax Received column. That column displays the amount of tax received from clients.

If you select this check box, the report displays amounts based on both invoices and cash receipts. If you also select All Transactions in Client Detail, the report displays invoice transactions and related cash receipt transactions in separate rows.

This option only applies to the accrual-basis version of the report. To generate the cash-basis version, you must clear this check box.

Cash Basis Reporting

Select this option to generate the cash-basis version of the report. This version only displays amounts based on cash receipts. It does not include tax amounts for invoices for which you have not received payment.

This option is not available if either of the following is true:

  • The cash-basis reporting feature is not enabled. You must select Cash-Basis Reporting on the Reporting tab of the Accounting System Settings form(Settings > Advanced Accounting > System) to enable it.
  • You selected Print Received Details to display received tax amounts.
Report in

If you use multiple currencies, you have the option to have the report display tax basis amounts, tax amounts, and tax received amounts in any of the following types of currency:

  • Transaction Currency: If you use transaction currency, the report displays the amounts in the currency associated with the individual transactions. Use the Currency field to indicate whether you want to include all currencies or only selected currencies. DPS then limits the transactions on the report to those with the specified transaction currencies.
  • Functional Currency: If you use functional currency, the report displays the amounts in the functional currency of the active company.
  • Tax Currency: If you use tax currency, the report displays the amounts in the currency specified for the tax code on the Tax Codes form. Normally, this is the currency in which the tax is reported and paid to the taxing authority. (This option is only available if tax auditing is enabled for the active company.)
Currency If you use multiple currencies and you select Transaction Currency in Report in, use this field to indicate if you want to include all currencies or only selected currencies, which you specify on the lookup. Transactions on the report are limited to those with the specified transaction currencies.