Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
NSC | Customize Financial Report Builder > Remove Hierarchy on Account
Scenario:
The user has a customized Income Statement report with the "Show Zeros" option enabled and the "Activity Only" checkbox disabled. They observe that the header and line GL (General Ledger) Account entries are repeating with zero values. They seek guidance on how to modify the report to not have these repeated accounts displayed with zero values.
Solution:
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.
Clarisa De Torres | Ask a Guru
- Earn Community badges now! Refer a Member | Answer Accepter |
The Support Community is your launchpad for learning, sharing, and earning exclusive rewards. Every contribution you make helps others and brings you closer to our official Oracle merchandise.
Learn more and join in the fun: