MYOB Advanced set up guide (API)

MYOB Advanced set up guide (API)

Connecting to MYOB Advanced

There are different versions of MYOB that Lightyear can connect to. Please follow the below steps to connect to both MYOB Advanced. Some notes will be version specific, so please follow these carefully as we go.

Because these versions of MYOB and Lightyear are both cloud-based, the set-up and connectivity between the systems is seamless. But before we proceed, please ensure your connection with MYOB is set up as follows. This is a one time connection.  


Note: The user who establishes the connection to MYOB must be a licensed user, with Full User (Full API) permissions.
From the Navigation Pane, head over to Settings > Accountancy > select MYOB Advanced > Connect. 

You will be presented with a popup, prompting you to enter your MYOB Advanced Credentials.



Domain Name: This will be the domain you log into e.g. company-name.myobadvanced.com and can be found in the address bar of your browser while logged in MYOB Advanced. Paste this into Lightyear.


Client Secret:
Log into your MYOB Advanced instance, and in the search bar, look for 'connected applications' and open this.
Enter a Client Name, set the Flow as 'Authorization Code', then click 'ADD SHARED SECRET'.
Enter a Description, set an expiry date (the date chosen will be the date the connection needs to be re-done, so set in line with your organisations needs and policies), and copy the secret value and paste into the Client Secret field in Lightyear, before clicking OK, as this will not be retrievable later.
 
Client ID ​
Click Save and you will see you Client ID populate. Copy this value and paste into the Client ID field in Lightyear.


Open the Redirect URIS tab, click the + button and enter https://app.lightyear.cloud/accounting-software as the URI, and click save.


Back in Lightyear, confirm the domain, Client ID, and Client Secret are correct before pressing Connect.

You will be redirected to MYOB Advanced and asked to authorise the connection. Click "Yes, Allow" and you will be sent back to Lightyear, and prompted to configure your Accountancy Settings. Once done, the import routine will run.


If the import fails, doublecheck the user making the connection has Full API permissions (Under Users  -License Types)


You can configure your Accountancy Software Setting to control the below:

Use of Subaccounts: If disabled, Subaccounts will not be selectable in the Approval workflow. 
Automatically Apply Chart of Accounts/Subaccounts at a line item level: If enabled, any coding rules will apply, if disabled, Subaccounts/Chart of Accounts will be left blank for manual coding. 
Sync Posting Date: Choose to populate the Posting Date in MYOB Advanced as either the date of export, or the Invoice Date.
Group Line Item Data: Group and Export Line Detail into the smallest possible combination of Chart of Account, Tax Code, and Subaccount. More detail on this feature can be found here 










Once the connection is established, Lightyear will import your Company file data.
Lightyear will automatically sync the following data back from MYOB Advanced which are required to process your payables bills: 
  • MYOB Suppliers
  • Chart of Accounts
  • Tax Rates
  • Subaccounts


The final step is to go to setup your default Tax Rates. Click here to learn how.
You MUST have a default tax code set up in order for bills to be exported to MYOB Advanced





      

    Check out our
    Product Blog Series
    to stay up to date

      • Related Articles

      • Connecting Lightyear to MYOB Advanced/Acumatica (via CSV)

        Lightyear can help businesses using MYOB Advanced or Acumatica save time on their Accounts Payable and Purchasing processes; data can be exported using the "Other" accounting software widget. Should the need arise, you can customise the below format ...

      • MYOB integration set up guide (Essentials & AccountRight)

        Connecting to MYOB (Essentials & AccountRight) There are different versions of MYOB that Lightyear can connect to. Please follow the below steps to connect to both MYOB Essentials and MYOB AccountRight. Some notes will be version specific, so please ...

      • Troubleshooting MYOB Error Messages

        [[BusinessEvent_DateOccurred_InLockPeriod; DateOccurred:(PurchaseEvent); BusinessEvent_DateOccurred_InLockPeriod; InventoryDateOccurred:(PurchaseEvent)]] Translation: Locked Period in MYOB If you are trying to export to a locked period, you will be ...

      • Exporting from Lightyear to MYOB

        Once some bills have been approved, go to the Signed Off tab in Lightyear and select the invoices you wish to export and click the Export to MYOB button. At the end of the export process, you will get a confirmation on screen that the export has been ...

      • Why can't I successfully connect to MYOB?

        There are a couple of common reasons we see as to why you're unable to sync your MYOB with Lightyear. Let's take a look at the below: Enable my.MYOB sign on access If you're connecting to MYOB AccountRight and having issues, head to your desktop ...