Module: Financial Report Builder (Custom Financial Reports)
Query Description:
When building a Financial Report using the Location filter in the Column section (Report Builder), the system displays each individual sub-location as a separate column rather than allowing sub-locations to roll up under their parent location.
This becomes a problem when the reporting requirement is to view financial/cost data at the parent location level only. Currently, since NetSuite treats each sub-location as a discrete column dimension, users are forced to see costs broken out at the sub-location level, with no option to consolidate/group sub-locations under their parent for column display purposes.
Business Impact:
- We need to analyze cost levels (e.g., manufacturing/overhead costs) by parent location without the noise of sub-location-level splits.
- Manually adding all sub-locations together outside the report defeats the purpose of using Report Builder's native grouping/column functionality, and is error-prone and time-consuming for reports with a large number of sub-locations.
- This is directly comparable to how Report Builder already supports subsidiary-level rollups (i.e., not showing child subsidiaries as separate columns when parent context is intended) — we would expect the same rollup logic to be available for the Location hierarchy.
Steps to Reproduce:
- Navigate to Financial Report Builder (custom report definition).
- In the Columns section, add Location as a filter/column dimension.
- Observe that all sub-locations under a parent location are listed individually as separate columns.
- There is no setting or checkbox available to collapse/roll up sub-locations into their parent location for column display, unlike the behavior available for other hierarchical fields (e.g., Subsidiary "include children" logic in some contexts).
Expected Behavior:
Report Builder should provide an option (similar to subsidiary hierarchy handling) to display only the parent location as a column, with all transactional data from its sub-locations aggregated/rolled up into that parent column — without requiring the sub-locations to appear as individual columns.
Requested Resolution:
- Please confirm whether this rollup behavior is supported via any existing configuration, saved search logic, or report definition setting that we may be missing.
- If not currently supported, please log this as an enhancement request to add parent-level location rollup/grouping functionality to Financial Report Builder's column configuration, consistent with existing subsidiary rollup behavior.