Velixo and Excel together enable efficiency

Velixo and Excel together enable efficiency
Velixo builds on the power of Microsoft Excel™ to make your reporting and data analysis more efficient.

Fundamental changes to Microsoft Excel™ have provided rich ecosystems for developers to create solutions. In 2010 Excel was expanded to support a million rows on a single worksheet. The introduction and subsequent upgrading of Dynamic Arrays in Excel 365 was a ground-breaking move in working with data.

The Dynamic Array formulas return multiple results to a range of cells on the worksheet, based on a single formula entered in one cell. This provides endless opportunities for Excel users to access and return datasets for use in analysis. However it is still complex and requires advanced Excel skills to use them effectively, and more particularly, efficiently.

Velixo and Excel together

Velixo is an add-on solution to MYOB Advanced and Excel that has taken the upgraded power of Dynamic Arrays and used them to create a set of functions. These new functions enable the end user to simply and successfully leverage these arrays without being an advanced Excel user.

Generic Inquiries Functions Reference

Introduction to Generic Inquiries:

  • GI function
  • GIFILTER function
  • GILOOKUP function
  • GILOOKUPF function

The introduction of List functions in Velixo allows any user of Velixo to extract and use data efficiently and effectively. These functions have been followed by the powerful Generic Inquiry Function (GI) and its related Generic Inquiry Filter Function (GIFILTER).

The GI function allows you to extract a set of data from any Generic Inquiry within MYOB Advanced. This data can then be used with standard Excel tools, functions, and formulas to create reports for analysis.

While this is possible to do natively in Excel with an Odata connection, Velixo is better suited and more efficient for experienced users.. The add-on brings a level of security and filtering on extract from MYOB Advanced, as opposed to only once the data is returned into the workbook.

Additionally, the GIFILTER function allows you to return a valid Odata filter from your GI in MYOB Advanced. GIFILTER filters the data during the extraction process, so there is no superfluous data to remove in Excel. This means that the function will only return the data you require for your reports and analysis, making the process more efficient.

A basic introduction to these functions can be accessed here.

What does this mean for me?

Given that it is possible to write a Generic Inquiry on any set of data within MYOB Advanced, you can use Velixo to analyse your data simply and efficiently across your entire system.

With the power to pull data from anywhere in MYOB Advanced, data security may become a concern. However, Velixo takes the security settings in MYOB Advanced into account. If you do not have the right to access data in MYOB Advanced, you will not have access to it in Velixo. This keeps your sensitive information safe, while also only giving your team access to the data that they need.

Harness the Power of Velixo Functions

Register for our MYOB Advanced Deep Dive to learn how to better harness the power of Velixo functions for report building. Velixo has seen many recent updates coming with a plethora of new functionality. Some of these functions may have been introduced after Velixo was deployed in your system, and some might have been presented but not required during your implementation. In this webinar, we would like to highlight some of the new and less commonly known but no less valuable functions in Velixo so that you can find improved efficiency and get more value out of your solution.

More information

To start a conversation about how Velixo could improve efficiency in your business email us or call 0800 437 774.

5 good reasons to choose Enprise

Reason 1: Gold standard service and support. 

Reason 2: Cloud options for every piece of software we sell.

Reason 3: The largest MYOB Advanced and MYOB Exo partner in Australasia, with dedicated sales, implementation & support teams.

Reason 4: A wide range of proven companion products from trusted partners. 

Reason 5: With Enprise, you get MYOB Exo from the people that invented it. 

More Information

For more information, contact us.
One of our consultants can call or visit you to discuss your needs.

MYOB Advanced Platinum Partner & MYOB Exo Platinum Partner logos - Enprise

Enprise MYOB Awards strip 2016-2021, 1200

Contact or Subscribe

Complete the form below and one of our consultants will contact you to discuss your needs.
You can also subscribe to our email newsletter to stay up-to-date on industry news.

The 'First name' field is required
The 'Last name' field is required
Please enter a valid Email address
by: