Hello,

I can’t help with your schema builder question above but I wonder if you have checked Additional Sort & Filters to see whether Company Group is an available option in the Transactions for Period report parameters:

The sample company above has no company groups but I’m hopeful you will see an option to choose Company Group in the Additional Filtering Conditions, Property list.

Too late to edit above… if you don’t see Company Groups in filters, will probably work to select the branches individually in Additional Filtering conditions with multiple lines, then save the filtering conditions as Report templates by company groups.

Example:

(GLTransaction.Branch     Equals     Branch1      Or

(GLTransaction.Branch     Equals     Branch2      Or

(GLTransaction.Branch     Equals     Branch3      Or

(GLTransaction.Branch     Equals     Branch4)     

Save Template with name Company Group A.

when users need the report for combined company groups, they choose the proper template with Template drop-down.

Hello @ashleyb ,

Were you able to find a solution?  If not please post details of what you tried so we can further help you.

Thank you.

You need to set up the company group and then they will become an option.

Thank you both for your help! I actually did try adding multiple branches at first under the additional sort and filter options and that did not work. Looks like I had to replace the OrganizationID with the OrgBAccountID in the schema builder and that did the trick!

Thank you for sharing your solution with the community @ashleyb !