how can the order of columns for department (hierarchy) be manually rearranged on income statement?

AI generated answer (using internal Slack threads):

To manually rearrange the order of columns for department hierarchy on the income statement, you would need to customize the layout of the report. Here are the steps: 1. Navigate to the Income Statement report. 2. Click on the 'Customize' button. 3. In the customization window, click on 'Edit Layout'. 4. In the section where you want to change the layout, adjust the 'Group By' to 'Department', and 'Then By' to 'Account'. Please note that this will group your income statement by department first, then by account. However, if you want to display the total of child-departments under the parent department, this is not directly possible in NetSuite. You would need to export the report to a CSV file and manually delete the unnecessary columns. If you want to group results in a header/summary or formula row in an income statement by department, you would need to create separate financial categories for each department instead of using the 'group by' function. Alternatively, you can display columns by department and get the totals and grouping done that way. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******