SAP Knowledge Base Article - Public

3506005 - Trial Balance: 'Result set for query 2CCFITRIALBALQ0001 is empty'

Symptom

When running the 'Trial Balance' (app ID F0996) for a set of filters where no postings exist, the following message is prompted:

'Result set for query 2CCFITRIALBALQ0001 is empty' 

Environment

SAP S/4HANA Cloud Public Edition.

Reproducing the Issue

  1. Open Trial Balance.
  2. Choose filters for which no postings exist.
  3. Execute.

Cause

The balance carried forward is 0 from the previous fiscal year.

Resolution

Carrying forward a 0 balance in this app could cause several issues:

  • DPP problem (information of several years prior would be transferred in all futures years).
  • Performance issues (too many items).
  • If a 0 balance is reported, it's not clear whether it's, for example, a +10 and -10 or simply no data causing the 0 amount.

Keywords

Trial balance, query, 0, 2CCFITRIALBALQ0001, filters, empty, report , KBA , FI-FIO-GL-IS-2CL , Reporting Apps (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions