CatalogueLINK for MYOB AccountRight Classic (Setup and Configuration)

CatalogueLINK for MYOB AccountRight Classic (Setup and Configuration)


MYOB AccountRight Classic Connection Requirements

The following is required to facilitate a connection between CatalogueLINK and MYOB AccountRight Classic.

  • Access to a local installation of the MYOB AccountRight Classic

  • Access to a local installation of the MYOB ODBC driver software

  • Local or network access to an ODBC enabled MYOB data file

IMPORTANT: To enable ODBC connectivity please contact MYOB on 1300 555 123 and quote the Straightsell partner number: 618006823007


CatalogueLINK Upload Connection Settings

The following information is mandatory for CatalogueLINK Upload connection configuration:

IMPORTANT: Please supply the information below to Straightsell in order to have CatalogueLINK Upload connected to MYOB AccountRight Classic

  • Folder path to the MYOB AR executable (MYOB install folder)

  • Folder path to the MYOB AR company file

  • MYOB Username and password (admin rights)

  • MYOB client availability either local or on the terminal server account

The following settings are configurable in Setup - MYOB in CatalogueLINK Upload version 'CL 3.0.12.0 - MYOB 3.0.6.0'.

Setup - MYOB

MYOB Datasource Information

Data Type

Example Data

Definition

MYOB Product

Drop down

AccountRight Enterprise v19

The MYOB AccountRight version

MYOB Exe Location

File path

C:\PremierClassic\Myobp.exe

The path to the MYOB executable

MYOB Data File Location

File path

C:\Users\Straightsell\Desktop\clearwtr.myo

The path to the MYOB Data File

MYOB Integration Username

Text

admin

A MYOB AccountRight username

MYOB Integration Password

Text

securepassword123

A MYOB AccountRight password



The following settings are configurable in Setup - Catalogue Account Details in CatalogueLINK Upload version 'CL 3.0.12.0 - MYOB 3.0.6.0'.

Setup - Catalogue Account Details

Account Details

Data Type

Example Data

Definition

User Name

Text

administrator

Your Straightsell username

Password

Text

password123

Your Straightsell password

Short Name

Text

UMARC

Your Straightsell short name

Straight Sell SOAP Server

Data Type

Example Data

Definition

URL

Text

https://interface.straightsell.com.au:443/soap/soapserver_5_0.php

SOAP Server URL: Same for everyone

Email Settings

Data Type

Example Data

Definition

Mail Server

Text

yourmailserver.yourmailserver.com.au

The mail server of your email address(es)

Email Address

Text

email@emailadress.com.au

Your email



The following settings are configurable in Setup - MYOB in CatalogueLINK Upload version 'CL 3.0.12.0 - MYOB 3.0.6.0'.

Setup - MYOB

MYOB Datasource Information

Data Type

Example Data

Definition

MYOB Product

Drop down

AccountRight Enterprise v19

The MYOB AccountRight version

MYOB Exe Location

File path

C:\PremierClassic\Myobp.exe

The path to the MYOB executable

MYOB Data File Location

File path

C:\Users\Straightsell\Desktop\clearwtr.myo

The path to the MYOB Data File

MYOB Integration Username

Text

admin

A MYOB AccountRight username

MYOB Integration Password

Text

securepassword123

A MYOB AccountRight password


CatalogueLINK Download Connection Settings

The following information is mandatory for CatalogueLINK Download connection configuration:

IMPORTANT: Please supply the information below to Straightsell in order to have CatalogueLINK Download configuration to MYOB AccountRight Classic

  • Account (debtor) code to use for test of order and payment export to MYOB AccountRight Classic

  • Payment Settings:

    • Account Number to be Credited (MYOB >> Lists >> Accounts)

  • Customer Settings:

    • Australian Tax Code (MYOB>>Lists >> Tax Codes)

    • International Tax Code (MYOB>>Lists >> Tax Codes)

Export Locations in MYOB AccountRight Classic:

  • Orders            - MYOB ‘Command Centres’ menu item >> ‘Sales’ >> ‘Sales Register’

  • Customers      - MYOB ‘Command Centres’ menu item >> ‘Card File’ >> ‘Cards List’

  • Payments        - MYOB ‘Command Centres’ menu item >> ‘Banking’ >> ‘Find Transactions’. Filter by the account you have placed the payments against. (The “Payment Account Code” below…)

The following settings are configurable in Setup - MYOB in CatalogueLINK Download version 'CL 3.0.7.0 - MYOB 3.0.6.0'.

Setup - MYOB

MYOB Datasource Information

Data Type

Example Data

Definition

MYOB Product

Drop down

AccountRight Enterprise v19

The MYOB AccountRight version

MYOB EXE Location

File path

C:\PremierClassic\Myobp.exe

The path to the MYOB executable

MYOB Data File Location

File path

C:\Users\Straightsell\Desktop\clearwtr.myo

The path to your MYOB data file

MYOB Integration Username

Text

admin

A MYOB AccountRight username

MYOB Integration Password

Text

securepassword123

A MYOB AccountRight password

Payment Settings

Data Type

Example Data

Definition

Account Number

Text

1-1140

The account number to store payments against

Order Settings

Data Type

Example Data

Definition

Export Item Names in Orders

Checkbox

Y/N

Item names are exported to MYOB in orders

Let MYOB Round Totals

Checkbox

Y/N

Totals are rounded when exported to MYOB

Order Number Prefix

Text

web

Appends orders with a prefix to differentiate web orders from regular orders

Export Orders As:

Drop down

Order/Invoice/Quote

Where web orders are exported into MYOB

Customer Settings

Data Type

Example Data

Definition

Use Anonymous Reference

Checkbox

Y/N

Enable/disable reference for anonymous customers

Anon Reference

Text

Anon

How anonymous online sales are identified

Australian Tax Code

Text

GST

An Australian Tax Code (e.g. GST)

International Tax Code

Text



An International Tax Code (e.g. VAT)

Currency Code

Text



Only required when multi-currency is enabled in MYOB AccountRight and MYOB AccountRight is installed on Windows Server 2003

Export customers as individuals

Checkbox

Y/N

Exports customers into the Card File as Individuals (export as Companies if disabled)

The following settings are configurable in Setup - Catalogue Account Details in CatalogueLINK Download version 'CL 3.0.7.0 - MYOB 3.0.6.0'.

Setup - Catalogue Account Details

Account Details

Data Type

Example Data

Definition

User Name

Text

administrator

Your Straightsell username

Password

Text

password123

Your Straightsell password

Short Name

Text

UMARC

Your Straightsell short name

Straight Sell SOAP Server

Data Type

Example Data

Definition

URL

Text

https://interface.straightsell.com.au:443/soap/soapserver_5_0.php

SOAP Server URL: Same for everyone

Email Settings

Data Type

Example Data

Definition

Mail Server

Text

yourmailserver.yourmailserver.com.au

The mail server of your email address(es)

Email Address

Text

email@emailadress.com.au

Your email