Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Subsidiary-Wise Trial Balance in NetSuite
1. Background
NetSuite’s standard Trial Balance (TB) report does not currently support subsidiary-wise segmentation, which is a common reporting requirement in OneWorld environments. This limitation is tracked under Enhancement #174031.
To address this reporting gap, we implemented a workaround by customizing the Balance Sheet report to replicate the Total view of the Trial Balance for individual subsidiaries.
2. Approach Overview
The customized report uses the Balance Sheet structure but is redesigned to behave like a Trial Balance. This is achieved by:
- Clearing all layout rows
- Adding a Financial Section containing all accounts
- Applying specific display settings
- Filtering by Subsidiary to produce subsidiary-wise outputs
Tagged:
2