Issue when trying to connect to MYOB Advanced from Velixo

Issue when trying to connect to MYOB Advanced from Velixo

Issue
When you are trying to connect to your instance using Velixo, you are receiving the screenshot below. This is often after an upgrade.


Reason
Each time a new version is release, Velixo adds additional Inquiries that are utilized for that particular. These help with the many useful functions Velixo uses. These are added automatically by the installer, when the user signs in for the first time, if they are not present.

Therefore, after a major release, you need to get a user with Full User Access to login via Velixo to your instance first, with the correct permissions to create the GI's. Once these are created and installed, all other users will be able to run their reports with any issues. We suggest completing this process using the PartnerSupport account so that there will not be any security related issues.
Resolution
  1. From a workstation, try and connect to the MYOB Advanced instance via Velixo using a PartnerSupport account
  2. You will then be shown a message that the new GI's are being created
  3. Try to login again via Velixo as a regular user
  4. The issue should be resolved.


    • Related Articles

    • "Error! MYOB Advanced could not recognize the OData syntax."

      After Velixo Upgrade to version 6, you are getting the error below when using some GI Function Queries “Error! MYOB Advanced could not recognize the OData syntax. Most likely, your filter contains a function which MYOB Advanced does not support ...

    • Updating Velixo License

      Issue: You need to force update your Velixo license details after a change has been made to them. Resolution: Open Excel Go to the Velixo Tab / Accumatica Tab Click Advanced > Clear Cache Close down Excel and all instances Re-open Excel to initialize ...

    • Download and install the Excel Add-in

      Prerequisites The Velixo Add-in for Excel is compatible with Excel 2010 for Windows and later. For more advanced GI and List features, Velixo recommends a recent version of Excel 365. User of Excel Online or Excel for Mac may be interested in the ...

    • Velixo Refresh All

      Using Refresh All allows you to update the data returned by the Velixo functions in your report.   Velixo Reports retrieves data from your database via the database's OData feed.  To speed up further analysis, you data is cached within the Excel ...

    • Velixo for Excel 2010 and later vs Excel 365 compatibility

      Problem: I have an older version of Excel and we are not ready to upgrade. Are we still able to purchase Velixo Reports? Solution: Velixo Reports works with Excel 2010 and later. The main advantage of Excel 365 is the native support of Dynamic Arrays ...