Navigation:  55    A:  How do I export my Clients and Invoices to my Accounting Software >

55.3 Fixes for MYOB Errors

Previous pageReturn to chapter overviewNext page

55.3.1 Error:

List two invoices same reference number and each invoice has amount is double the original invoice

 

Possible Cause:

You tried to export an invoice but the report generated by Latitude displays two records – same invoice# & the invoice amount is double the original amt

 

FIX:

Check contacts. It must only have one main contact

 

55.3.2 Error:

1270_thumb

click here to zoom

Message: Error occurred while writing to the Import Log File. Click OK to continue importing without creating the Log File

 

Possible Cause:

You encountered an I/O error. Check if you’ve got the MYOBLOG.TXT open

You tried importing myobinvs.txt; modified so that Salesman Last & First name contains Job Captains First/Last Name

You tried importing myobinvs.txt; modified so that Job field contains Latitude Job number

 

FIX:

Close MYOBLOG..TXT

Make sure Salesman exist in MYOB

 

55.3.3 Error:

1275_thumb

click here to zoom

I/O Error in Rewrite Routine

 

Possible Cause:

You tried importing invoices in MYOB but myobinvs.txt is opened by excel or notepad

 

FIX:

Close notepad or excel and do the import again

 

55.3.4 Error:

Invoices for Clients which have no ‘Main Contact’ set cannot be exported

 

Possible Cause:

No main contact identified in the contacts tab

 

FIX:

Business Contacts -> Contacts tab -> assign a main contact

 

55.3.5 Error 3:

Account number must be numeric

 

Possible Cause:

You tried to export a receipt but the Chart of Accounts Account Number is name of Bank

 

FIX: Make sure it’s the account number and not the name of the bank

 

55.3.6 Error 10:

Invalid date

 

Possible Cause:

Incorrect import Data selected (e.g. Item Sales, Professional Sales, etc.)

 

FIX:

When doing Import, select:

Receipts ->Receive Payments for myobReceiptAccrual.txt

Sales -> Service Sales for myobinvs.txt

Cards -> Customer cards for myobcard.txt

Check Regional Settings -> English (XXXX) where XXXX is the name of your country

 

55.3.7 Error 11:

Transactions dated before the beginning of your financial year may not be imported

 

Possible Cause:

You exported an invoice that is dated before financial year

 

FIX:

Check if the invoice date is correct and change it to current year

 

55.3.8 Error 14:

Invalid Account number

 

Possible Cause:

GL Account No in Invoice is incorrect

 

FIX:

Finance->Invoice->find the invoice no -> go to invoice details and correct the GL Account No

Check if the GL code is using dashes instead of dots eg. 4.1000 and not 4-1000

 

55.3.9 Error 15:

Account number not found in list of postable accounts

 

Possible Cause:

GL Account No in Invoice does not match any GL Account in MYOB

 

FIX:

Check GL account in Invoice Details against the GL Account in MYOB if its existing

 

55.3.10 Error 24:

Duplicate card

 

Possible Cause:

Customer already exist in MYOB

 

FIX:

If customer exist in MYOB, ignore message. If importing invoices, with multiple GL Account No use Duplicate Records: Add Them

 

55.3.11 Error 26:

Card not found

 

Possible Cause:

Card was not imported from Latitude or there is no existing card

 

FIX:

Do import for myobcard.txt

 

55.3.12 Error 29:

Invalid tax amount

 

FIX:

Check if there is an extra line in the invoice line items that has no amount. If not required, delete this empty line or make sure the GL Code is the same at least with one of the invoice lines

 

55.3.13 Error 42:

Deposit Account must have cheque privileges

 

Possible Cause:

You entered a non asset/cheque GL account when processing Receipts

 

FIX:

Check Bank Account used during processing of receipts. Check Bank Accounts and Chart of Accounts Account Number

 

55.3.14 Error 90:

Ex-Tax Amount and Inc-Tax Amount are invalid or blank

 

Possible Cause:

Export of an invoice with multi-lines that don’t have any amounts

 

FIX:

Tick Consolidate GL Account and Tax Type

 

55.3.15 Error 132:

Invoice # not found

 

Possible Cause:

Import of payments before invoices

 

FIX:

Do import for myobinvs.txt before myobReceiptAccrual.txt

 

55.3.16 Error 134:

Payments are not allowed on quotes & credits

 

Possible Cause:

Negative values on payments

 

FIX:

Do Manual adjustment on MYOB Bank & AR (see below)

 

55.3.17 Error 172:

A valid entry must exist within either the Co./Last Name or CardID field

 

Possible Cause:

Use of wrong import file of either invoice or receipt

 

FIX:

Try again & select the correct import file

 

55.3.18 Error 190:

Customer not found

 

FIX:

Check Latitude and MYOB to be sure the client code and name are the same

 

55.3.20 Error 3170:

Couldn't find installable ISAM

 

Possible Cause:

Import Cards from a MYOB card CUST.TXT