MYOB AccountRight Premier/Enterprise Adaptor

Please post in this forum topics that contain tips or advice that is related to the MYOB AccountRight Premier/Enterprise adaptor within the Connector software, and the connectivity between the adaptor and the MYOB AccountRight business systems for the Premier and Enterprise editions. If you wish to post more broader topics related to the Connector then please do so in General Tips and Advice

If you have found a bug in the Connector please post it in the Bugs forum.

If you wish to discuss about an improvement or new feature you would like to see in the Connector then please post in the New Features/Improvements Wish List forum.

 

Please ensure that you do not post any information containing user names, passwords, or any other sensitive information that could compromise the security of a project or website relating to an organisation or person.

Within the Connector if its MYOB AccountRight Premier adaptor is being used to obtain invoice or other record data from MYOB AccountRight Live, the AccountRight ODBC driver that the Connector uses to talk to AccountRight may be returning the error "ERROR [HZ080] [MYOB ODBC] - Cannot connect directly to the driver", what is going wrong?

If the Connector was configured with the MYOB AccountRight Premier/Enterprise v19 system, and its lock files had become corrupted, if the Connector's Host Windows Service was attempted to be stopped then its status remained at "Currently Stopping". Additionally it was not possible to kill the Connector Windows service process using a windows console and running the taskkill command. How can the Connector service be restarted so that data can flow from it again?

One of our customers is having trouble submitting orders into MYOB Account Right Premier due to an "Unable to determine if import has finished" error. Is it possible to modify how the connector works to add in a timeout to the ODBC connection string? (SQL_LOGIN_TIMEOUT=90;)

In version 1.11 of the SQUIZZ.com Connector, when using a MYOB AccountRight adapter, I am unable to import orders due to the product codes missing on the ODBC insert statements that are run when the connector imports the orders into MYOB. What could be causing this?

Is it possible to have a space in the comments of a Sales Order in AccountRight between the 'Submitted By' and 'Instructions'?

A question was asked if the connector's MYOB AccountRightPremier/Enterprise adaptor can export out back orders from a MYOB AccountRight Premier/Enterprise system?

An issue was reported where orders being created in a TOTECS project were being passed across to the Connector application that contained taxes applied to the product pricing, but when the MYOB AccountRight Premier adaptor imported the order into the AccountRight system no taxes or taxcodes were being assigned to the lines and $0 tax was incorrectly getting set for each. So why was this occurring?

An issue was reported where products that were imported from MYOB AccountRight Premier into a TOTECS project through the Connector's adaptor, were displaying the "no stock" icon in the TOTECS project, however these products were set quantities of stock to show that the stock level was high. Specifically the products that were shown as having no stock were products set as being kitted. The question is why is this occurring?

A common cause for this message is the presence of 'lock files' in the location where the company file is stored. These files are created by the system during an MYOB session to manage multi-user. Ordinarily these files are automatically deleted when the session ends, but an abrupt termination of a session can result in one or more of these files remaining in the system.

 

To rectify this, the lock files must be deleted. Xsquizzit Accounting Connector give you tool to remove lock file. Please follow the below mention mitigation steps to remove the lock file.

 

Mitigation Steps