Why did the Get Data process fail to read my MYOB AccountRight Classic table
Overview
For some users, the Get Data process may fail to read a specific table from MYOB AccountRight Classic. There are different causes as to why this may occur.
Get Data process may fail due to user permissions
The MYOB login used to read your MYOB data file may not have the necessary permissions to read all tables. As a general rule, we recommend that the Administrator login is used as this ensure all tables can be read.
To change the login used to connect to your MYOB data file, see Changing how BudgetLink connects to your data file and Connecting BudgetLink to MYOB AccountRight 19.
Get Data process may fail due to different versions of MYOB
MYOB AccountRight Classic comes in different editions: Accounting, Accounting Plus, Premier and Enterprise. It also comes in different versions: v18, v19, etc. Not all editions and versions of MYOB comes with all tables. For instance, MYOB Accounting does not include the payroll related tables. Accounting and Accounting Plus do not include multiple currencies.
While the MYOB ODBC Driver used is common across all versions. It may be that the table required is only available in one specific edition or version of MYOB. It may also be that this table is required for a specific feature of BudgetLink to work.
If the get data process fails and you cannot determine why, we recommend you contact Accounting Addons.