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
- Go to the Business Analytics work center.
- Go to the Design Reports view.
- Search and open the report Open VAT / Sales Tax Items.
- Use the relevant selection criteria to search (e.g. Company, Tax Due Date, Tax Country/Region, Tax Event...).
- 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