Hi Raff,
Like you our legacy Excel and Access solutions would no longer work after upgrading to MYOB AccountRight Live as query tables could not connect to the API in the cloud. To continue using them we had to get the data into a database which they consume using an ODBC or similar connection. So we developed code in Excel to connect to the web based API and download the data into a Local Access Database. As the end points in the MYOB AccountRight Live API http://developer.myob.com/api/accountright/v2/ are different to the v19 ODBC driver we created conversion tables to shape the data into the old v19 format. To handle multiple data files we created the ability to support multiple connections which can support both v19 and v2017 simultaneously. We packaged this solution into an addon called ODBClink http://accountingaddons.com.au/odbclink/ which you can download and trial. There is also an unsupported Free edition available with restricted functionality
Jeff Stephenson
Accounting Addons
Related Content
- 3 years ago
- 11 months ago
- 3 years ago