SAP Knowledge Base Article - Public

3750192 - DRC Mexico VAT Declaration (mx_vat_rep) shows "no items to report; query doc_sel did not return any data"

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

  1. Open the Statutory Reports app.
  2. Select the Report Name: Mexico VAT Declaration (MX_VAT_REP).
  3. Run the report.
  4. 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

Product

SAP S/4HANA Cloud Public Edition all versions