This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I'll ask this question here as it seems to be more Finance related. In the default P&amp;L is there a way to just show the parent level Location and totals in the P&amp;L columns. We don't want to see the sub-location values, just the Totals by Location.

I have tried both Location &amp; Location (Hierarchy)

If I filter to just the Parent location, I only get the value posted directly to that Location but it doesn't include the rolled up value Total

I don't think so unfortunately. I'd love to know if you figure out a way. I've run into that issue with other segments, though not Locations.

NetSuite doesn't create subtotals at the parent level when viewing in a column format.

Thanks. My workaround is giving the summary in the Rows. 