MYOB AccountRight - Legacy ODBC

MYOB ODBC Activation Key (Developer Partner Client ID): 9097371

MYOB ODBC writeback key file

Copy 
65C816FA3CD6188B4F72847D6E9CDAC21D4E30A4F946A3D7A8F374CACB019C82AB59AB6932835CFD8F8A58AC722F8DE10204572C55E054AD1B3CFEB7F885E40A

  1. Install the MYOB ODBC connector.

    By default, the connector is installed in C:\EnterpriseClassic\ODBCDirect10\setup.exe.

  2. Activate the customer's MYOB file for ODBC access using the My.MYOB.com.au portal.

    Use the activation key above.

  3. In MYOB:

    1. Go to Setup > Company Information > License > Enable Online.

    2. Go to Setup > Preferences > Sales.

    3. Make sure that the Retail Original Invoice Number on Backorders field is DISABLED.

  4. Disable the READ ONLY flag on C:\MYOBODBC\ and C:\MYOBODBCAU10\ and sub-directories.

  5. Create an ODBC DSN (32-bit) for the MYOB connector.

  6. Install Microsoft SQL Server 2017 Express (or utilise an existing SQL server, if possible. It is only being used as a metadata store.).

  7. Create a database in the Microsoft SQL Server.

    1. CREATE TABLE [dbo].[Documents]([DocID] [bigint] NOT NULL,[DocType] [nvarchar](10) NOT NULL,[DocHash] [nvarchar](200) NOT NULL);

    2. GO

    3. CREATE INDEX Documents_DocID_DocType ON Documents (DocID, DocType);

  8. Copy the connector release files on to the server in an appropriate location.

  9. Configure the Log4net.config file to suit the customer's requirements.

  10. Configure DWMS MYOB AccountRight v19 Connector.exe.config to suit the customer's requirements.

  11. Create a scheduled task to periodically launch DWMS MYOB AccountRight v19 Connector.exe.