Quick question. How can I setup a preferred report for specific users/roles? When an GL Account is opened from a custom balance sheet, I want them to open the custom GL instead of the standard GL

It sounds like you want to add a drill-down report to your custom balance sheet. Here is a blog post that goes through how to add this.