I’m trying to build a NetSuite P&L that shows the complete GL account structure across subsidiaries, including accounts with no activity / £0 balance.
I’ve noticed some unexpected behaviour: an Income account assigned to a child subsidiary with no transactions during the reporting period appears correctly as £0.00 when using Total, but the account disappears completely when the report is displayed using Subsidiary (Hierarchy).
I have also confirmed that Show Zeros = ON and Activity Only = OFF.
Has anyone encountered this behaviour before?
The requirement is simply to have a consistent P&L account structure across subsidiaries, so that all relevant GL accounts remain visible, with £0.00 shown where there is no activity.
Is there a Financial Report Builder setting or another supported approach that would allow this when using Subsidiary (Hierarchy)?
Any advice or experience would be greatly appreciated!