Scenario
The user has a customized Income Statement report, and they want to display zero values. They have enabled the 'Show Zeros' functionality and also activated the 'Activity Only' option. When 'Activity Only' is enabled, the header and line-level GL Account do not repeat, and transactions with no activity are also hidden. However, when 'Activity Only' is disabled, the header and line GL Account repeat with zero values.
The users prefer not to have the header and line GL Account repeat. They want to know how to prevent this repetition without enabling the 'Activity Only' option.
Solution
What the user observed is the standard behavior of the Financial Report. When Show Zeros = T and Activity Only = T, this will only show accounts that had activity during the specified date or period range for your report.
The repetition of header lines and GL Accounts on the other hand occurs because the report groups all related accounts under their corresponding main account. This is based on the hierarchy structure, where, for example, 4000-2000 - Sales - Export is the main account, and the other two accounts beneath it are sub-accounts. This grouping and display in the report is standard behavior, reflecting the hierarchical organization of accounts.
Currently, the alternate solution you can try is to remove the account hierarchy, you can perform the following:
1. On your Report, click on Customize button.
2. On Edit Layout, click on Compensation (or any Account Section).
> Notice that it is Group By = Account, and Show Hierarchy = True.
3. Kindly unmark Show Hierarchy checkbox.
- Perform the same to other Account Sections.
4. Click Preview or Save.
___
If you find this information useful, let us know by reacting or commenting on this post!