SAP Knowledge Base Article - Public

3835368 - DRC Canada - GST/HST Return report shows zero values; Analyze Data empty (2CCCASRGSTITMQ) — SAP S/4HANA Cloud Public Edition

Symptom

  • Canada GST/HST Return report (CA_GST_HST_RITC_RETURN) displays 0.00 in all boxes although GST/HST transactions exist.
  • Analyze Data / Box Summary shows: "The result set does not contain any relevant data".
  • Analyze Data / Box Summary shows: "Result set for query 2CCCASRGSTITMQ is empty".
  • Report run and outputs (Canada GST/HST Reporting and Canada GST/HST Internet File) are generated successfully but contain no transactional values.

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Open the Run Statutory Reports app.
  2. Execute the CA_GST_HST_RITC_RETURN report.
  3. Open the generated Canada GST/HST Reporting output and observe all boxes show 0.00.
  4. Choose Analyze Data / Box Summary.
  5. Observe messages: "The result set does not contain any relevant data" and "Result set for query 2CCCASRGSTITMQ is empty".

Cause

Missing configuration for the for GST/HST report.

Resolution

  1. Review the required configuration for the GST/HST report in the Setting up your Statutory reporting configuration activity (ID: 101071).
    At 'Parameters specific to report category' node, enter the relevant tax box structure type in TAXBOX_STR_TYPE, e.g., "1".
    At 'Parameters specific to reporting entity' node, enter the GST registration number for Canada in CA_GST_REGISTRATION. 
  2. Maintain the tax jurisdiction codes in the Specify the Federal Level Tax Jurisdiction Code (ID: 103086) activity.
    Ensure Tax Jurisdictions relevant for GST/HST reporting have the "X" indicator marked in the Federal Level column. Values other than "X" are not validated by the standard logic.

See Also

Keywords

CA_GST_HST_RITC_RETURN, GST/HST, Canada, Run Statutory Reports, Analyze Data, Box Summary, 2CCCASRGSTITMQ, taxbox_str_type, Federal Level, Tax Jurisdiction Code, ID 103086, zero values, empty result set, Advanced Compliance Reporting, statutory reporting , KBA , FI-LOC-FI-CA , Canada , Problem

Product

SAP S/4HANA Cloud Public Edition all versions