
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
