Hello Gurus!
I have been searching the tools for an answer but have not found my exact question so I will ask.
My company is restructuring and adding some layers and reporting requirements not previously thought of when NetSuite was implemented a short 16 months ago. Who would have guessed!
Currently we are:
- flat in our Departments, no child departments
- using Department as a restriction on roles
- using the Class field for another purpose and cannot change
- using the Project field for another purpose and cannot change
I am considering the following option to achieve 3 separations:
- Layer 1 = Departments (already use)
- Layer 2 = Child Department (do not use)
- Layer 3 = Repurpose "Location" for a Division field (we do not currently use Location)
Three layers of Department appears to be possible but I am concerned about the rollup for reporting. I have found mentions this does not work well at 2 levels; 3 levels will be a challenge even if it works seamlessly.
Primary goal is rollup reporting, role restrictions, and flexibility for the future.
Does anyone have experience with this type of setup or suggestions on something other than Dept, Child Dept, Division (Location)?
I have considered a Custom Segment also but this seems more line detail information that using for restrictions and reporting.
Thank you in advance for your collective wisdom!