MYOB Acumatica Integration Setup Guide

MYOB Acumatica Integration Setup Guide

Connecting to MYOB Acumatica

Idea
As of July 2024, MYOB Advanced is rebranded to MYOB Acumatica. Any reference to MYOB Acumatica or MYOB Advanced in this guide can be used interchangeably.

There are different versions of MYOB that Lightyear can connect to. Please follow the below steps to connect to both MYOB Acumatica. 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.  
Info
Please Note: The user who establishes the connection to MYOB must be a licensed user, with Full User (Full API) or Limited API permissions. Please speak to you MYOB consultant if you require Full User (Full API) licenses. 

Establishing the Connection

From the Navigation Pane, head over to Settings > Accountancy > select MYOB Acumatica > Connect. 

You will be presented with a modal, prompting you to enter your MYOB Acumatica 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 Acumatica. Paste this into Lightyear.
Alert
The https:// component should not be copied across. 

Client Secret:
Log into your MYOB Acumatica 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 Acumatica 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.
Alert
If the import fails, double check the user making the connection has Full or Limited API permissions (Under Users - License Types)

Software Settings

You can configure your Accountancy Software Setting to control the below:
  1. Turn on and off Subaccounts
  2. Turn on and off Locations
  3. Turn on and off Branches
  4. Set a Header Branch
  5. Automatically apply Categories on line item level
  6. Automatically apply Chart of Accounts on line item level
  7. Set up Posting Dates
  8. Enabled Grouped Line Data

Do you use Subaccounts?

Enable this option if you have Subaccounts to be imported to Lightyear. Select these against each Bill/Credit Note line item to be exported into MYOB Acumatica.

Do you use Locations?

InfoPlease Note: This is set at a company level and cannot be changed on a document basis.
    WarningIn order to enable Lightyear to view your MYOB Acumatica locations, you will need to complete the below steps within MYOB Acumatica first:
    1. Navigate to the Integration section on the left hand side menu within MYOB Acumatica and open the Web Services Endpoints screen
    2. Click into the Default endpoint (with the latest version number) this should be Screen ID SM207060

    3. Click on Extend Endpoint 

    4. Give the Endpoint a name and version, as per below (it's important these are exactly as shown below) and press OK
      Endpoint Name: DefaultExtended
      Endpoint Version: 22.200.001
       

    5. On the tree view on the left side menu of this new Endpoint click onVendor, then press the insert button
        

    6. Fill in the Field Name, Object Name and Object type as per below and press OK
      Field Name: Locations
      Object Name: LocationsDetail
      Object Type: Detail
      Leave Use existing entity blank
      A screenshot of a computer Description automatically generated 

    7. Select the new Entity you just created from below the Vendors folder on the left hand side menu, go to fields tab and click populate
        

    8. Select Locations as the object and check all the available fields, then press ok
        

    9. Save the web service endpoint by pressing the save icon as per below. Your list of fields, and extended endpoint should reflect the below details once finished:
        

    Once the above is completed in MYOB Acumatica, you can then enable Locations in your Lightyear accountancy settings, which will set a specific location as the Header location that will be set against each Bill/Credit Note to be exported into MYOB Acumatica.
    Info
    This is only visible from Accountancy Software Settings and on the document/s once exported to MYOB Acumatica.


    Do you use Branches?

    Enable this option if you have Branches to be imported to Lightyear. Select these against each Bill/Credit Note line item to be exported into MYOB Acumatica.

    Set Document Header Branch As:

    When Branches are enabled, you can have the option to set a specific branch as the Header Branch that will be set against each Bill/Credit Note to be exported into MYOB Acumatica.
    Info
    Please Note: This is set at a company level and cannot be changed on a document basis.

    Automatically apply Dimensions on line item level?

    1. Yes - Save time by coding it in Lightyear, and we’ll remember the next time we extract the line item that you’ve coded the supplier lines to.
    2. No - Keep these blank for you to code individually.

    Automatically apply Chart of Accounts on line item level?

    1. Yes - Save time by coding it in Lightyear, and we’ll remember the next time we extract the line item that you’ve coded the supplier lines to.
    2. No - Keep these blank for you to code individually.

    Sync Posting Date As:

    You can choose for the posting date to be exported as two different dates depending on your business needs.
    1. Export Date - the date the document has been exported from Lightyear into Business Central. 
    2. Invoice Date - the date populated in the Invoice Date field within Lightyear. If you select this option, you'll also have the option to select a Custom Date within this field in the Approvals Workflow.

    Group Line Item Data?

    Turning this on will allow you to export Grouped Account data, rather than line item data. For the full article on this, click here.

    Once the connection is established, Lightyear will import your Company file data.
    Lightyear will automatically sync the following data back from MYOB Acumatica 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.
    Warning
    You MUST have a default tax code set up in order for bills to be exported to MYOB Acumatica
    Notes
    When importing Suppliers, ensure the below
    BANK DETAILS - As these are customisable fields in MYOB Acumatica, when importing Suppliers, the description in Payment Instructions MUST match the labels below:
    1. BSB Number (not sort code, branch code etc...)
    2. Account Number (not any sort of abbreviation such as ACC Number, Account, etc...)

    Migrating Software?

    Once you select MYOB Acumatica as your software, you won't be able to change it. If you are thinking about changing accountancy software, please reach out to our Support team for guidance on how to do so.



        

      Check out our
      Product Blog Series
      to stay up to date

        • Related Articles

        • MYOB Acumatica Best Practices

          MYOB Acumatica Tips and Tricks Set your Tax Calculation Mode Under your MYOB Acumatica Supplier profile> Purchase Settings > you can set the Tax Calculation Mode. For the most seamless experience from Lightyear, best to set this as Net. This will ...

        • Connecting Lightyear to MYOB Acumatica/MYOB Advanced (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 Setup 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 ...

        • AccountsIQ Integration Setup Guide

          Connecting to accountsIQ Setting up and connecting Lightyear to accountsIQ is a quick and easy process. From the left hand ribbon, head over to Settings > Accounting Software > Select accountsIQ > Connect. A popup will display asking for a User Key ...

        • Fuelsoft Integration Setup Guide

          Lightyear allows you to export your bills in a pre-set CSV format, which can then be uploaded directly to Fuelsoft. To get started, head to the Accounting Software section of Lightyear and select Fuelsoft from the drop down. Once done, you'll need to ...