In order for MYOB to function with CRM you must have version 4.7 or above of QoS-IT. If you are unsure of what version you have installed contact us to find out.

Installing MYOB ODBC Direct

When you install your AccountRight software, the MYOB ODBC Direct driver is installed automatically. If you have uninstalled the driver, and need to reinstall it, complete the following procedure. If you already have it installed go to “Defining a company file as an ODBC data source”

To install MYOB ODBC Direct

1. Log in to Windows as the Administrator or Power User if your computer only allows people with administrator privileges to install programs.
2. Using Windows Explorer, open the AccountRight program folder, and open the ODBCDirect subfolder.
3. Double-click the setup.exe installer file.
   The Welcome window appears.
4. Click Next. The License Agreement window appears.
5. Read the agreement and if you accept it, select the I accept the terms of the license agreement option.
6. Click Next. The Choose Destination Location window appears.
7. Select the folder into which you want to install the driver. If you want to select:
   - the default folder, continue with step 8 below.
   - a different folder, click Browse, locate and select the desired installation folder, and then proceed with step 8 below.
8. Click Next. The Select Program Folder window appears.
9. Click Next. The Start Copying Files window appears.
10. To accept the installation settings, click Next. When the installation is complete, the InstallShield Wizard Complete window appears.
11. Click Finish.

Defining a company file as an ODBC data source

To connect to a company file using the MYOB ODBC Direct driver, you must first define the file as a data source and set up a Data Source Name (DSN). A DSN identifies your company file as a database to which other ODBC-compatible applications can connect.

To define a company file as an ODBC data source

NOTE: If you are using the 64-bit version of Windows... Do not complete the first two steps in this procedure. To access the ODBC Data Source Administrator window, you will need to open the C:\WINDOWS\SysWOW64\ folder on your hard drive and double-click the odbcad32.exe file. You can then continue with step 3 below.

1. Go to the Start menu and choose Control Panel.
2. Double-click Administrative Tools and then double-click Data Sources (ODBC).
   The ODBC Data Source Administrator window appears.
    
3. Click the System DSN Tab.
4. Click Add. The Create New Data Source window appears.
   
5. Select MYOAU1001 and then click Finish.
   The ODBC Setup Configuration window appears.
    
6. In the top section of the ODBC Setup Configuration window, enter a unique Data Source Name and a description. (For example, you could enter “MYOBDB” as the Data Source Name and “AccountRight company file” as the description.)
7. In the AccountRight Company File section of the ODBC Setup Configuration window, click Browse. The Select file for ODBC source window appears.
    
8. Locate and select the AccountRight company file you want to connect to.
9. Click Open. The ODBC Setup Configuration window appears showing the company file’s path.
10. In the User Name field, enter a user name that you have set up in the company file.
    
    NOTE: To gain full access to the company file... Enter a user name that is not restricted from
    accessing any windows or functions in the company file, for example, Administrator.
    If you enter a user name that has been restricted from accessing windows and functions, the user
    will not be able to access the tables related to those functions via ODBC.
    
11. If you have set a password for the user name entered in the previous step, enter it in the Password field. If you have not set a password, leave the field blank.
12. Check the Enable checkbox under Developer Access.
13. Click Browse and select the myob.exe or myobp.exe executable in your MYOB AccountRight installation directory.
14. Select the “Multi-user Access” radio button.
    
15. Click OK. The ODBC Data Source Administrator window appears.
16. Click OK.

Setup in Microsoft CRM

1. Open Microsoft CRM.
2. Click the Settings area.

If you have setup units and unit groups in Microsoft CRM then please skip to step 5.

1. Click Product Catalog.
2. Click Unit Groups
3. Click New on the tool bar to create a new Unit Group with its Primary Unit.
   Example:
   
4. Click OK to create. A new window will open up to further exit the unit group if you wish. You may safely close this window having created the minimum required for MYOB.
5. Select QoS-IT Settings on the left hand side menu.
6. Click the Accounting Setup tab.
7. Select MYOB Australia from the Accounting Software drop down list.
   The following options will appear.
   
8. Enter the DSN Name as created in the ODBC Data Source Administrator.
9. In the Default Product box enter a product name from AccountRight that will be used in the event that a given product in Microsoft CRM is not found in your AccountRight company file. Preferably this item should not be an inventoried item to prevent out of stock errors.
10. Select the Unit Group and Default Unit created earlier. These will be used when importing items (products) from your AccountRight company file.
11. Select the number of decimal places to use in the pricing of imported products.
12. Click Save to save your settings.

Download and Install Async Service

Download the Async Windows Service required to integrate your MYOB AccountRight package to QoS-IT for Microsoft CRM from the following link.

Download

Install Async Package

1. Double click the AsyncSetup.msi file to start the installation.
2. Click Next on the welcome screen
3. Optional : Select the Folder to install the necessary files into by clicking the Browse button
4. Keep a record of where you are installing the service and click Next.
5. Click Next again to confirm the installation.
   The service will now install the windows service.
6. During the installation you will be prompted with this dialog.
    
   This is the user that the windows service will run under. Please specify a domain\username and password for a user that has access to start your AccountRight package and the company file and click OK.
7. Click Close when the installation completes.

Changing Settings and Running the Async Service.

1. Go to the folder you installed the Async Service above.
2. Open the Settings.xml file in your favourite text editor.
3. There are 11 settings described below you must set before starting the service.
   
   MYOBInvoiceEnabled : specify true or false if you would like the service to create invoices in AccountRight from Microsoft CRM.
   MYOBPaymentEnabled : specify true or false if you would like the service to check for payments on invoices created in AccountRight from Microsoft CRM.
   MYOBProductsEnabled : specify true or false if you would like the service to import and\or update items (products) from AccountRight into Microsoft CRM.
   MYOBInvoiceRepeat : specify (in minutes) how often you would like to process Invoices.
   MYOBPaymentRepeat : specify (in minutes) how often you would like to check for Payments.
   MYOBProductsRepeat : specify (in minutes) how often you would like to import and\or update items (products).
   CRMDomain : specify the domain name for the user that will be used to access Microsoft CRM.
   CRMUsername : specify the username for the user that will be used to access Microsoft CRM.
   CRMPassword : specify the password for the user that will be used to access Microsoft CRM.
   CRMOrg : specify the organisation unique name of your Microsoft CRM organization.
   CRMDiscoveryService : specify the url of the Microsoft CRM discovery service.
   
4. When you have completed all settings save and close the file.
5. You may now start the services by going to the services applet.
6. Open the start menu and select run (or press Windows Key + R)
7. Type in services.msc and click ok
8. Find the service named “QoS-IT Async for Microsoft CRM” and start it.

Creating a workflow to queue Invoices for Creation into MYOB AccountRight.

1. Open Microsoft CRM
2. Click the Settings area
3. Click Workflows
4. Click New on the toolbar
5. Specify a Workflow name. eg. Create Invoice in MYOB AccountRight.
6. Select Invoice in the Entity drop down list.
7. Click OK
   The main workflow editor window will appear.
    
8. Specify a Scope of Organisation as we would like all invoices to be created automatically. This will ultimately depend on your own needs.
9. Select one or more items from the Start when list. We recommend Record is created so that invoices are created in MYOB AccountRight as soon as you create then in Microsoft CRM.
10. If you tick the On demand tick box if you wish to create old invoices in MYOB AccountRight by running the workflow manually.
11. You may specify criteria for which invoice will get created in MYOB AccountRight by using the Condition steps in the Add Step menu but for the purposes of this document we will assume all invoices will get created.
12. Click Add Step
13. Select the Create Record item\step
14. In the Create drop down list select Background Queue
15. Click the Set Properties button
16. Enter a name for the Queue Entry eg. Create Invoice {Name(Invoice)}  in MYOB Account Right
17. Select MYOB Invoice as the Type
18. Enter 0 (zero) as the Number of Attempts
    You do not need to fill out any of the other items on the General tab but may do so if you wish.
19. Click the Related Entities tab
20. Click inside the Related Invoice field so the Form Assistant will focus on the field
21. The form assistant should look like this
    
22. Click the Add button and then the OK button to create the slug in the Related Invoice field
23. Click Save and Close to return the the main workflow editor screen.
24. Click Publish when you are ready to make the workflow active.