Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

WebWorkbench integrates with MYOB AccountRight Live Plus and AccountRight Live Premier versions using the MYOB API (AccountRight Premier V19 does not have an API service).  This replaces the previous approach of creating export files which were manually imported into MYOB.
Image Modified 

The MYOB AccountRight Live instance maybe deployed on a local server, or in the cloud. We highly recommend to set up using local instance. It provides better performance especially for large batches.

Image Removed
Image Added

A WBInterface database is used to stage the data which is exported from, and imported to, Workbench.

The WebWorkbench application uses the MYOB API to transfer data into and out of MYOB AccountRight Live.

Implementation

Prerequisites

  1. Server Edition instance (which includes the  API service) is installed and configured (Client version doesn't work with WebWorkbench) or MYOB AccountRight Online (no need to install AccountRight SE instance).

  2. A Workbench database is installed and all required control parameters has been set.

  3. Web Workbench minimum version 4.2 (this version doesn't require Interface DB anymore)

  4. The latest version of workbench requires .net 4.5.2 and it needs to be installed on a server prior the upgrade. You can download it from here: http://www.microsoft.com/en-nz/download/details.aspx?id=42642

 

For multiple FinCos on a single Workbench database, multiple MYOB will need to be set up on MYOB Integration screen.  

MYOB export scripts are installed with Web Workbench.

MYOB Integration Setup in WebWorkbench

At this point you need to decide if setting up 

MYOB Online Instance

or MYOB

or MYOB Local Instance.

Image Removed
Image Added


MYOB Online Instance

Image Modified 

  1. Navigate to the Configuration -> MYOB Integration

  2. Click Authorize (a new page will be opened in a new tab)

  3. Login to the MYOB. Request client's own account to MYOB (email address and password). This is different to the login and password needed on MYOB Integration screen.

  4. If successfully logged in you will see a page with a message from MYOB asking you to authorise Workbench to access MYOB. Click on Allow Access.

Image Removed
  1. Image Added



  2. On next page, choose company from the list (If MYOB File is not available, request client to create it first in MYOB or check that the login is valid) and click Next

Image Removed
  1. Image Added



  2. Manually copy values on this page back on WebWorkbench MYOB Intergartion screen (Access Token, Refresh Token, Company ID and Hash)

Image Removed
  1. Image Added



  2. Click Next and close the tab.

Image Removed
  1. Image Added
  2. Back on MYOB Integration screen in Workbench, choose a financial company for the imported transactions from the dropdown.

  3. On the integration screen Logincode and Password must be a user that does not have my.MYOB account.

    It should be a just User name and Password. See example on the screenshot below. (this is Password for a Company File locally - See MYOB company file help for more details). These is what MYOB refers to as Offline login username & Offline password. If the company file is only used online, enter Login: Administrator and no password. 
    If a user and password are being used on the company file, this is set on MYOB Setup Menu/ User Access (note that not all users have access to this menu)
      Image ModifiedImage Modified


  4. Provide a

'MYOB
  1. ‘MYOB Category' and an 'AP Suffix' for exported transactions (See MYOB categories for more details). 
    Most of our

clients
  1. clients’ MYOB category is: WBI
                                  AP Suffix:

WB 
  1. WB 

  2. Click Save

  3. Click Test to test connection

MYOB Local Instance

Image Removed
Image Added
  1. Tick MYOB Local Instance checkbox.

  2. The Validate option will open a new tab with a list of MYOB instances, each showing a unique Company ID.This Internal Address url is the server where AccountRight API has been installed + /AccountRight. If it shows localhost/AccountRight, but the server is not the server where the WebWB application is installed, then this needs to be changed to the real server name, and not 'Localhost'.

Image Removed

  1. Image Added




     

  2. Copy the company ID of your company file and paste it in the setup screen.

Image Removed
  1. Image Added



  2. If your MYOB instance is not shown, it may be necessary to respecify the MYOB Library Location, using the MYOB Set Library Location function.

Image Removed

Try exporting

  1. Image Added


  2. You can now export a batch.

  3. If you get the error on the screenshot 'Encountered a communication error (http:/localhost...', please follow the steps on this MYOB link to fix it. 

The services will need to

Note

MYOB API Service must be restarted after the myob config file MYOB.AccountRight.API.WindowsSericesHost.exe has been changed.

 

Image Added

Image Removed

Note

Make sure the API has been updated to the current MYOB version. If it is still pointing to the old version, it will not work.

The services will need to

MYOB API service must be restarted after the change.

Image Removed

Image Added



Related Pages:


FAQs:

Filter by label (Content by label)
showLabelsfalse
showSpacefalse
cqllabel = "placeholder" and space = "KB"

Process Flow: