Hi
Our management reporting is performed outside of Netsuite and is not integrated, therefore as a financial accountant, it takes too long to see the profit and loss and balance sheet categorized by 'Management account' category.
I would like to create a profit and loss and balance sheet report which groups accounts by 'Management account' category. However one of the problems we have is that a management account category may contain a mix of account types. Therefore I am unable to achieve this by using summary accounts as summary accounts require all the children to inherit the parent's account type.
Currently for information purposes, I have created a custom field on the Chart of accounts, with a custom list containing all the management account categories. Each account has been allocated a'management account category.
I have tried to custom the profit and loss report so that the 'budget and financial: section name' column is removed, with the aim to use my custom field as the first column and the group column, however the column 'budget and financial: section name' cannot be removed.
I then tried to write a condition on each section so that it filters by my management account category, however I can only see a select number of fields being 'account name', account type, account number, class name, department name, customer/job name, item name or subsidiary name. I am unsure if my custom field can be added.
I'm aware I could write a lot of conditions in the financial section e.g. account number is 4000, account number 4001 however this would take a long time to create and when new accounts are added the conditions would need to be updated.
Wondering if anyone had any suggestions on how this could be achieved.
Thanks
Tim