IBM Support

Trial Balance drilldown report's consolidated group column appears blank when that account does not include an automatic journal

Troubleshooting


Problem

When running the Trial balance with drill down report and selecting to " Show consolidated group" the consolidated group column may inconsistently appear blank when the total is 0 sometimes as demonstrated below:

image-20230821094722-2

Symptom

All accounts with automatic journals will have a 0 as expected when the total is 0. Accounts that do not have an automatic journal will appear to be blank when the total is 0. Should the total be anything other than 0 the consolidated group column should correctly display the value regardless if the account has any automatic journals. 

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"ARM Category":[{"code":"a8m0z000000bnDIAAY","label":"APAR Incident"}],"ARM Case Number":"TS013631764","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
09 May 2025

UID

ibm17028204