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
- Open the Run Statutory Reports app.
- Execute the CA_GST_HST_RITC_RETURN report.
- Open the generated Canada GST/HST Reporting output and observe all boxes show 0.00.
- Choose Analyze Data / Box Summary.
- 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
- 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. - 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
- Refer to: Setting Up the GST/HST Report
- Refer to: Making Additional Settings for the GST/HST Report
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
SAP Knowledge Base Article - Public