Description
An issue has been identified in the ODBC driver release for MYOB Version 19.7.
The ODBC driver originally installed with your AccountRight v19.7 software will not return an error if an error is encountered during an ODBC import. This means the ODBC driver will advise that an import has been successful even if an error is encountered.
You should install this update if you:
use AccountRight v19.7 (Plus, Premier or Enterprise), and
use an add-on solution with your AccountRight v19.7 software, or
use a write back key to import data via the MYOB ODBC driver into your AccountRight v19.7 software.
After you have updated you will need to perform some WMS/MYOB maintenance.
Detail Steps
Close all open programs, including AccountRight.
Click to download the AccountRight v19.7 ODBC Update.
Save the file to your Desktop.
Double-click the downloaded file.
Click Yes to install the ODBC update.
Click OK when the installation is complete.
Ensure you install the ODBC update on all computers using AccountRight v19.7. To do this:
Copy the update file from your Desktop to a removable storage device, such as a USB stick.
Insert the USB stick into the other computer.
Repeat from step 4 above to install the update.
Workflow Restrictions Once the update has been installed as described above, you will no longer need the update file which can be safely deleted. |
After you have updated you will need to perform some WMS/MYOB maintenance.
Failing to do this maintenance could result in lost sales revenue and stock reconciliation issues.
Run the sales reconciliation report.
Manually delete duplicate MYOB entries and resend WMS closed sales which do not appear in MYOB (Drill to order > Create MYOB Order)
Please view the WMS support note below for further details.
Sales Reconciliation Support NoteReplicate in Maintenance Mode.
Run the Stock Reconciliation Report
Resolve Errors by manually resending transactions to MYOB or removing duplicate transactions from MYOB or
Please view the WMS support note below for further details.
Stock Reconciliation Support Note
Related Information
Issue Details for the advanced user - MYOB are not returning a response for failed Transactions via the ODBC Drive in version 19.7 (The internal software which connects WMS to MYOB). This means we are unable to determine whether Transactions are being received into MYOB correctly and also are unable to display the error in the status reporter.
This can cause Transactions to import into MYOB twice or be closed in the WMS without being sent to MYOB at all.