[MYOB ODBC] Invalid account number
This error message from the Ostendo - MYOB Link program is due to 'funny characters' being in the Description field of the line record as held in Table FINANCIALPURCHASEINVOICES.
These are accepted by Ostendo and MYOB but the ODBC Driver interprets the 'funny character' as a field separator thus "moving" the remaining content into the next field...and so on.
This results in the expected 'Amount' Field containing alpha characters.
Therefore, for Purchase Invoices the Description field must NOT contain special characters. You should note that special characters can also be 'hidden' (Example: Line Feed Carriage Return) if the Invoice data is imported.
The only way to get rid of the spurious characters is to go into the FINANCIALPURCHASEINVOICES record and amend the Description.
Related Articles
MYOB Activation
These 2 documents describe how to Activate and setup your MYOB file in preparation to linking with Ostendo. Select the appropriate file for your country
MYOB Classic Integration
For Ostendo Versions upto and including 238, use the following link Latest MYOB Classic Link (Current Build: 121): http://www.ostendo.info/downloads/ostendo/myobostlink.exe For Ostendo Versions from 242 and onwards, use the following link (Build 100) ...
09/08/2024 - MYOB Cloud - Invalid Refresh Token
MYOB Cloud - Invalid Refresh Token Late yesterday afternoon we started receiving reports that the integration between Ostendo and MYOB Cloud was failing. The following message was being displayed if a connection was attempted. We immediately ...
[MYOB ODBC] - Supplier not found in MYOB
If you get a message "The Supplier for the Purchase Invoice does not exist in MYOB" even though you have checked they are the same This could be due to 1 of two reasons 1. Ostendo and MYOB allow commas in the Supplier Name but the MYOB-ODBC Driver ...
7/03/2024 - MYOB AccountRight Cloud Integrations - Invalid Refresh Token message
MYOB AccountRight Cloud Integrations - Invalid Refresh Token message Over the last 24 hours we have had reports of Ostendo unable to communicate with MYOB AccountRight Live - Cloud environments. At this stage MYOB AccountRight Live - Desktop ...