Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
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: