SAP Knowledge Base Article - Public

3166793 - No Results Shown For a Specific Invoice in VAT Reports

Symptom

You expected the report Open VAT / Sales Tax Items (Report ID FINTAXU09_Q003) to show the data related to a specific Customer Invoice. However, the report does not return any results and shows the message "No report data available to display; check the selection".

This scenario may also apply to report All VAT / Sales Tax Items (Report ID FINTAXU09_Q003).

Environment

 SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Go to the Design Reports view.
  3. Search and open the report Open VAT / Sales Tax Items. 
  4. Use the relevant selection criteria to search (e.g. Company, Tax Due Date, Tax Country/Region, Tax Event...).
  5. Click on Apply button.

The following message is displayed: No report data available to display; check the selection

Cause

The invoice you expect to see in the report contains the deferred tax line items.

Defer tax can be liable only when the payment for the invoice happens, tax amount will then move from defer tax to actual tax account.
Since the invoice contains defer tax line item the tax due date will be empty for the invoice, so that is the reason the invoices are not getting shown in the report.

Resolution

If you do the payment for the invoice, the payment document will be shown in the report.

Keywords

VAT, report, No report data available, Sales Tax, invoice , KBA , SRD-FIN-GLO-TAX , GLO - Tax Declaration , How To

Product

SAP Business ByDesign all versions