All the financial functions include a Branch argument to filter by branch or company. If you leave it blank, it includes every single company and branch.

Companies in Acumatica/MYOB Advanced can be setup to be with or without branches:

If a company is setup without branches, you can just use the Company ID as if it was a Branch in all the functions. If a company has branches, you can retrieve all the branches for this company by doing =BRANCHLIST(Connection, Company) and then use the resulting set of branches

To report on everything EXCEPT one company, you can do a few things:

Get the full list of branches/companies that should be included and pass that as the Branch filter in all the functions

- Use the new feature in Velixo 5 that allows you to include everything EXCEPT a few items -- see the Everything (*) operator in this article: https://support.velixo.com/hc/en-us/articles/360042333552-Specify-multiple-entities-ranges-and-wildcards-in-functions