Symptom
Mexico VAT Declaration report (MX_VAT_REP) generated empty with message "No items to report;Query DOC_SEL did not return any data."
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Open the Statutory Reports app.
- Select the Report Name: Mexico VAT Declaration (MX_VAT_REP).
- Run the report.
- Observe that the run completes successfully but displays: "No items to report;Query DOC_SEL did not return any data."
Cause
Documents relevant for the Mexico VAT Declaration were not cleared; the Clearing Journal Entry field was not populated, so the documents were not considered for MX_VAT_REP.
Resolution
The documents need to be cleared in order to be picked by the report.
See Also
Refer to: VAT Declaration
Refer to: Configuration for VAT Declaration
Keywords
mexico vat declaration, mx_vat_rep, no items to report, query doc_sel did not return any data, empty report, statutory reporting, drc mexico, clearing journal entry, document not cleared, vat report empty, mexico vat, report selection, tax report mexico, doc_sel, reported item log , KBA , FI-LOC-FI-MX-ACR , Statutory Reporting , Problem
SAP Knowledge Base Article - Public