Excluding companies from Consolidated Reports

Excluding companies from Consolidated Reports

Issue
You would like to exclude any number of companies from the consolidation reports in Velixo for MYOB Advanced.

Resolution
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:
Velixo Version 4
Get the full list of branches/companies that should be included and pass that as the Branch filter in all the functions
Velixo Version 5
- 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


    • Related Articles

    • Getting Started with Velixo Reports

      Prerequisites The add-in is currently compatible with Acumatica 5.3 and later, as well as with Excel for Windows 2010 and later. For best performance, Acumatica 6.1 or later is recommended (streaming mode allows Acumatica to send data back to the ...
    • Scheduling Alchemex Reports

      You would like your reports automatically emailed to particular users across your organisation It’s time to stop manually distributing your reports and start saving time by scheduling your reports to automatically distribute themselves.  In this tip, ...
    • Data Source name not found and no default driver specified. SQLState=IM002

      Error "Data Source name not found and no default driver specified. SQLState=IM002" when trying to run any reports Resolution Go to the Connector Find the connection the report with the error is running off Ensure the report is on the correct ...
    • Minimum Role Requirements for using Velixo Reports

      Overview At the most basic level, Velixo is governed by the same access rights as MYOB Advanced.  So if you want to control access to various Velixo features, you can do so by controlling access to the screens used for those elements in MYOB ...
    • Error Scheduling Reports for Intelligence Reporting

      Problem There is an error scheduling reports to execute using the Windows Task Scheduler Symptoms: The Report is scheduled but the BICore.exe process doesn't launch The report is scheduled but the BICore.exe launches but doesn't consume any memory ...