MYOB NetoSync Install



This manual will guide you through MYOB NetoSync setup.

Before you begin

This guide requires the Neto Connect module from the Addon’s store. Please install prior to starting this guide.

NetoSync is not compatible with Webroot Anti-Virus Software as it causes the integration to cease operating.

Before starting the NetoSync setup please ensure that the following is installed on the server or computer that contains your MYOB company file:

• MYOB application
• MYOB ODBC (compatible version for your current MYOB application version)

If you wish to allow NetoSync to read and write to your MYOB company file whilst other users are logged in,
simply follow the steps below:

• Share the folder that contains the MYOB company file on your computer or server
• Create a mapped network drive to connect to the MYOB company files folder
• The mapped network drive is a connection to the shared folder on the Host machine represented by a drive letter in Windows Explorer

Why do I need to do this?

Within the MYOB ODBC driver there are checks performed upon connection to the MYOB data file. One of them is to check that the file is not opened for single user access. At the time connection is executed, the driver checks the file state and then if it is in use, checks for an MYOBP.EXE (Premier) or MYOB.EXE process that has a handle on the data file.

In a network situation, the process that has the file open will usually be running on a different workstation or in the case of Terminal Services, another server session and as such cannot be read or detected by the session or workstation the ODBC connection is being executed from.

The inability to detect another terminal server sessions process’s is a part of the server operating system security by design. In the new MYOB ODBC driver, the check for file exclusivity has been bypassed for any file opened from a network location.

This means that in order to ensure the connection is successful regardless of other users or connections, the database path needs to be a network path.

Step by Step Install Instructions

Step 1 - Activate MYOB ODBC
To enable Neto read/write access to your MYOB company file please follow these MYOB ODBC activation instructions.

Go to: https://my.myob.com.au/Pages/ODBCActivation.aspx

Enter your MYOB serial number.
Enter the following activation code: 7365669
Follow the on-screen instructions.




Step 2 - Create a New MYOB User
Once you have activated your MYOB ODBC please login to your MYOB company file as an administrator and create a new user with administrator privileges and the following credentials:

username: neto
password: net@!

To setup a new user in the MYOB Application, navigate to Setup > Preferences > Security Tab > User ID’s Button > New.

This user will be used by MYOB ODBC to access your company file. If you do not have additional MYOB licenses available, you can use an existing user with the correct privileges.




Step 3 - Backup Your MYOB Company File
Once you have created the user please create a backup of your MYOB company file by copying your current MYOB company file and renaming it “netotest“.

Store this file in the same location at your active company file. This file will be used for testing the Neto connection and read write access to your company file.




Step 4 - Download NetoSync Scripts
Once you backed up your company file please download the latest version of NetoSync by going to:
https://www.neto.com.au/assets/downloads/netosync/NetoSync.zip

Please download and unzip the file to your C:\ or equivalent drive.


Step 5 - Set Up MYOB ODBC Data Source Connection

For 32-bit Operating Systems (E.g.: Windows XP 2003 etc.):
Once you have unzipped the required files to your C:\ drive you will need to setup your MYOB ODBC data source connection.

  1. On your Windows desktop

  2. Click on Start > Control Panel > Administrative Tools

  3. Click on Data Sources (ODBC)

  4. Select the System DSN tab

  5. Click Add

  6. Select MYOB_ODBC > click Finish

  7. Data Source Name: Myob

  8. Description: Neto Myob



  1. Click Browse > select the location and file name of your Myob Data file (for testing use the netotest file created earlier). e.g. C:\Program Files\Premier10\netotest.myo (If your company is on a network location, you must specify the full path, for example \Drive1\Folder1\CompanyFile.myo) and click Open.

  2. User Name: neto and password: net@!

  3. Developer Access > select Enable. Click Browse and select the location and file name of your Myob Program. e.g. C:\Program Files\Premier10\Myobp.Exe and click Open.

  4. File Access > select Single or Multi. Single user requires all users to be logged out of Myob during import.
    Multi user allows users to be logged into Myob during import. If Multi user selected, also select Protocol TCP/IP.

  5. Key Value

  6. Click Browse and select the location where NetoSync is installed on your computer (C:\NetoSync by default). In this file you will find a file that end is .key (e.g.: 1234567890.key) and select this file.

  7. Save your changes



For 64-bit Operating Systems (E.g.: Windows 2008):
Once you have unzipped the required files to your C:\ drive you will need to setup your MYOB ODBC data source connection.

  1. Go to: C:\windows\sysWOW64\odbcad32.exe

  2. Select the System DSN tab and click Add

  3. Select MYOB_ODBC, click Finish


  4. Data Source Name: Myob

  5. Description: Neto Myob


  6. Click Browse > select the location and file name of your Myob Data file (for testing, use the netotest file created earlier). e.g. C:\Program Files\Premier10\netotest.myo (If your company is on a network location, you must specify the full path, for example \Drive1\Folder1\CompanyFile.myo)

  7. Click Open

  8. User Name: neto and password: net@!

  9. Developer Access > select Enable

  10. Click Browse > select the location and file name of your Myob Program. e.g. C:\Program Files\Premier10\Myobp.Exe and click Open.

  11. File Access > select Single or Multi. Single user requires all users to be logged out of Myob during import and Multi user allows users to be logged into Myob during import. If Multi user selected, also select Protocol TCP/IP.

  12. Key Value

  13. Click Browse and select the location where NetoSync is installed on your computer (C:\NetoSync by default). In this file you will find a file that end is .key (e.g.: 1234567890.key) and select this file.

  14. Save your changes




Step 6 - Configure NetoSync

Once you have setup DSN for the associated MYOB driver you will need to install and configure the NetoSync program.

Go to: NetoSync > setup, and click on install.wsf

Once installed an “install complete” message will appear > Click OK. Once you click OK, your config file will open.

The following fields at the top of the file will need to be edited, once edited save the file:

RequestURL - URL to your website’s NetoSync Webservice (Default: Https://Yourdomain.Com/Do/AccWS/MYOB )

AccessKey - The secret access key or password to allow access to the above location as defined in your Neto admin control panel

MYOBDSN - You must setup DSN for your associated MYOB driver in Control Panel > Administrative Tools > Data Sources (ODBC). For 64 bit Windows, you must setup the DSN in “windows\sysWOW64\odbcad32.exe”. By default, this value is Myob.

MYOB_LOG_FILE - MYOB data import log file location. For MYOB Premier and Premier Enterprise, by default this is ‘MYOBPLOG.TXT’ and it is in the same directory as your MYOB company file. For MYOB Accounting and Accounting Plus, by default this is ‘MYOPLOG.TXT’ and it is in the same directory as your MYOB company file

RUNAS_USERNAME - Your windows username used to run NetoSync, require to check if NetoSync is running (Must be in lower cases)




Step 7 - Running NetoSync

In order for Neto to communicate with your MYOB company file NetoSync must be turned on. Processes will not run if NetoSync is turned off.

The green and red controls or icons for turning on and turning off NetoSync are located in the “NetoSync” folder. You can place these icons on your desktop or another easily accessible location if you prefer.

Starting NetoSync
To start NetoSync click on the “Start NetoSync Icon”. This is usually located on your desktop or in the NetoSync folder on your C:/ drive.

Stopping NetoSync
To stop NetoSync click on the “Stop NetoSync Icon”. This is usually located on your desktop or in the NetoSync folder on your C:/ drive.

What Happens When NetoSync is Turned On?
While turned on NetoSync polls your website looking for processes to complete. Once a process is available in your “MYOB Process Queue” it will initiate the running of that process.

Example:
You may have a schedule setup in Neto to run the process “Export Sales” every day at 8pm. At 8pm every day Neto will place the process “Export Sales” into your “MYOB Process Queue”.

NetoSync will then poll your “MYOB Process Queue” and initiate the process “Export Sales”. The process will then move from the “MYOB Process Queue” to “MYOB Running Processes”.

You can check on the progress of any process that is running by looking at the “MYOB Process Log”. This is a real time view of running processes and the progress of each process. This includes import and export processes.

You can check on the results of any export process by looking at the “MYOB Export Log”.


Step 8 - Running NetoSync as Scheduled Task

You can setup NetoSync to run on your server as a scheduled task. This will negate the need to start or stop NetoSync manually. When running NetoSync as a scheduled task you must setup a separate user on your server with administrator privileges and install NetoSync under that user.


Step 9 - Configure the MYOB Integration in Neto

Now that you've completed the NetoSync setup, you just need to complete the MYOB integration setup in Neto.


  • Last Modified: 18/11/2016 Neto Version: 6.3