Sales List
Use the Sales List report to review sales and associated taxes for the reporting period you specify.
This report is available only if you select the Enable Tax Auditing Feature check box on the Tax Auditing tab of the Accounting Company Settings form ( .
Leading Zeros in Invoice Numbers
If your enterprise uses leading zeros in invoice numbers but you do not want to display the zeros on the report, clear the Display Invoice Leading Zeros option in the Invoice section on the General tab of the Accounting System Settings form ( ).
Cash-Basis Setting
To run this report as a cash-basis report, you must select Cash-Basis Reporting on the Reporting tab of the Accounting System Settings form( ).
Retainage Invoices
This report shows retainage invoices that include tax amounts. Because the retainage invoice number is the same as the number of the original invoice from which it was withheld, DPS displays Retainage Billing in the Comments column to identify the retainage invoices.
The report does not show retainage invoices for which no taxes are due.
Multiple Companies
If you use multiple companies, only information for the active company is included in this report.
As a result, if you have projects for which lower work breakdown structure levels belong to companies other than the company that owns the project, billing transactions associated with those levels will not appear on this report when you generate it for the company that owns the project. To see those transactions, generate the report for the company to which the lower work breakdown structure level belongs.
Multiple Currencies
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 the transaction currency, you also indicate if you want to include all currencies or only selected currencies; transactions on the report are limited to those with the transaction currencies that you specify.
- Functional currency: The report displays the amounts in the functional currency of the active company.
- Tax currency: This option is only available if tax auditing is enabled for the active company. If you use the tax currency, the report displays 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.
If you choose to 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.
DPS stores amounts in these types of currencies when the transaction is posted. The amounts are calculated using the exchange rates in effect on the posting date.
Options Dialog Box
Use the Options dialog box to specify reporting options for a report. Depending on the report, the dialog box contains one or more of the following tabs: General, Sorting/Grouping, Columns, Budget, Metrics, User Defined Sections, Activity, Drill Down, Layout, and Graph.