Error! MYOB Advanced could not recognize the OData syntax.

"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 server-side (such as tolower(), startswith(), or contains()).
If possible, try to reformulate the filter expression without using any unsupported function calls.
Alternatively, if this inquiry is not too large to load without a filter, consider enabling client-side filtering for the inquiry in Velixo's Generic Inquiry options.
Visit velixo.com/help/gi-filtering to learn more.

Reason

In Velixo 6, we have changed the filtering from client side to server side as an enhancement. However, there are a few functions which are not able to be processed server side.

Resolution
Go to Options > Generic Inquiry > Always load the entire Generic Inquiry and filter the data locally



    • Related Articles

    • 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 ...

    • Error with Endpoint when publishing customization

      Issue When trying to publish the Velixo Customization package, you receive this error message "Versions of the contract for a system endpoint cannot be created. Create a custom endpoint and give its contract another name" Furthermore -  You can ...

    • 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 ...

    • 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 ...