fmAccounting Link (MYOB Essentials Edition) v2 Trial Version
You can download a 14 day trial version of fmAccounting Link (MYOB Essentials Edition) v2 here.
Some notes about the trial version:
- it's limited for 14 days
- the file is locked and will stop working after 14 days
- you will not be able to import data from the trial version into the version that you purchase
The download is a .zip file – please make sure you unzip/extract the .zip file first before opening the fmAccounting Link (MYOB Essentials Edition) file. On Windows this can be done by right clicking the .zip file and select "Extract All". On the Macintosh you can simply double click the .zip file to unzip the file (if it was not unzipped automatically after it was downloaded).
Cloud API Setup
Setting up the fmAccounting Link (MYOB Essentials Edition) file to work with your MYOB Essentials company file only takes a few minutes - you will login to your my.MYOB account from within the fmAccounting Link file to approve access and generate the tokens used for subsequent requests to the MYOB Essentials API.
To begin click on the MYOB BUSINESS navigation button at the top of the screen which takes you to the MYOB Preferences screen where you can start the authentication process and select the Company File you wish to use:
Redirect URL: enter http://desktop (this should be set by default)
You can ignore all the other options at this stage. You are now ready to test that you can authenticate against the Cloud API. Click the Authenticate button and a new Card window showing a Web Viewer will appear for you to login to your my.MYOB account:
Once you've entered your login details (and optional verification code if Two-factor authentication is setup) you will be prompted to approve access to your Essentials company files (this only appears once):
Click the Allow access button to continue. If you entered the correct my.MYOB login credentials the Web Viewer will show a blank page. When this appears click the Continue button in the bottom right hand corner to proceed:
You should then see the following dialog box confirming that you have authenticated successfully with the Cloud API and the Web Viewer card window will close:
The tokens that were generated during the authentication process will now be populated in these fields:
These will be used to authenticate with the MYOB API from now on – you won’t be required to login to your my.MYOB account unless your Refresh Token expires. Access Tokens expire after 20 minutes (we keep track of this in the Expires At field) and can be refreshed automatically using the Refresh Token. Refresh Tokens expire after 1 week: if you don’t refresh your access token within 1 week you will need to click the Authenticate button and login to your my.MYOB account to generate a new set of tokens.
You are now ready to select which of your available Essentials Company Files in the Cloud you wish to work with when making API requests. Click on the Company Files TAB then click the Import All Company Files button to download the list of Company Files into FileMaker:
You can now select the MYOB Company File to use from the MYOB Company File list:
To test that the connection is working successfully we recommend making a few requests to the Essentials API, such as downloading some data such as your list of Account Codes or Tax Codes:
- click on the General Ledger TAB then the Accounts TAB and click the Import Accounts button. The full list of Account Codes from the selected Essentials file should be downloaded:
- click on the General Ledger TAB then the Tax Codes TAB and click the Import Tax Codes button. The full list of Tax Codes from the selected Essentials file should be downloaded
If these are successful you can download other configuration data on the General Ledger TAB, then click on the General TAB and download your customers and suppliers from the Contacts TAB and your Inventory Items from the Items TAB. Finally you could create a new Customer or Supplier in the Contacts module and upload this to MYOB Essentials.
You can also watch this short video below that demonstrates how to setup the Cloud API: