MYOB Export Log File

After importing the job, contact and invoice file into MYOB, you may receive errors. Below are explanations for these errors and solutions. 

The MYOB results window

As you select Import within MYOB, a results window will appear.  

ClosedResults descriptions:

There will be 3 descriptions that outline the success of the records that were attempted to be imported:

Records imported without errors

This is a great result, as the records have been imported.

Records Skipped

The record was not imported and action is required to get the record into MYOB

Record imported with warnings

The record was imported though some of the data may not be placed in relevant fields - review only required
  1. If there's records skipped or records imported with warnings you must review the log file.
  2. Browse to the location of the MYOBLOG.txt or MYOBPLOG.txt file. This is located in the same directory as your MYOB data file. 
  3. Review the errors and make relevant changes as outlined below.

Tip: A new LOG.txt will be created for each import file - Jobs, Contacts and Invoices - overriding the file each time, so ensure you review errors after each import.

Understanding the MYOB error log

Errors and warnings will appear at the end of the log file. Match the error or warning to the record in the file - this will pinpoint exactly which record has been skipped or imported with warnings. 

The following table details more information on the MYOB errors found in the log:

Job file import

 

 

Warning 464

Job Number may not contain more than 15 characters; truncated

Synergy allows a 20 character job number. Because the job number has been truncated, the invoice will not be matched to the job. Ensure your project numbers in Synergy are no longer than 15 characters.    

Warning 466

Job Name cannot be more than 25 characters; name truncated

Synergy allows a 100 character job name. Because the job name has been truncated, the invoice will not be matched to the job. Ensure your project names in Synergy are no longer than 25 characters.    

Card file import

 

 

Error -24

Duplicate Card

The card already exists in MYOB. This is OK however it is best that during the import of the Contact file, select the option Update existing record instead of reject duplicates. Read more  

Error -172

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

MYOB Import file settings are set to Identify records by Card ID. During Import of Card File, select the option Identify records by Co./Last Name

Error -242

More than 1 customer found. Sale invoice not imported

Duplicate cards exist in MYOB - customer/supplier/employee/personal. For the import routine to identify the Card, they must be unique. Either combine existing customer cards, make all other card types different to the custom card type, or utilise Card ID's in Synergy and MYOB. Read more   

Error -269

Card ID may not be blank. Card not imported/updated

MYOB Import file settings are set to Identify records by Card ID. During Import of Card File, select the option Identify records by Co./Last Name

Warning 594

Invalid Invoices/Purchase Orders Delivery; current Invoices/Purchase Orders Delivery substituted

This field is not recorded within Synergy, therefore the default is added within the Card record in MYOB. This is OK. 

Warning 292

Invalid A.B.N.; ignored

Remove spaces from the Contact within Synergy. This will be updated on the next invoice created and the error will no longer occur. 

Sales file import

 

 

Error -15

Account number not found in list of postable accounts

The MYOB Account Code entered does not exist in MYOB.

  1. Restore your MYOB backup create prior to the import.

  2. Delete the most recent Accounting Interface file in Synergy.

  3. Go to MYOB Export Settings > Invoices. Make sure the Account Code Value listed under Export Account exists within MYOB. 

  4. Recreate Interface.

Error -127

Transactions dated before your "Lock Period" date may not be imported

The invoice is dated prior to your locked period.  

  1. Restore the backup created before importing the records.

  2. Reimport Jobs and Contacts.

  3. Select Setup | Preferences | Security. Either uncheck the Lock Period or change the date to the earliest invoice being imported. 

  4. Attempt the reimport of Invoices.

The reason you need to restore is if you attempt to import the invoices again, any that were imported the first time round will be added again. If you are unable to restore a backup, then Import the Invoices and delete any duplicates that should not be there. 

Error -183

Duplicate Invoice Number

Invoice number already exists in MYOB. Ensure during the import of Sales file, Duplicate Records option is Add them, not Reject them. This is required to Import Cancelled and Write Off Invoices. 

Warning 85

Job not found in list of detail jobs; job ignored

The job doesn't exist in MYOB. Add the job and assign to the Sales record in MYOB. 

Warning 114

Salesman not found; ignored

The project manager in Synergy will come across as the Salesman in the Invoices/Sales file. Ensure employee record type names are spelled exactly the same as Synergy. 

Warning 253

Invalid or blank Discount Days/Date; default substituted

This field is not recorded within Synergy, therefore the default is added within the Sales record in MYOB. This is OK. 
 

Making changes in Synergy/MYOB

In regards to warnings, by making necessary changes, the error won't appear next time. The changes you make will be affected in the next Export created from Synergy. 

Though with records skipped, it is very important the problems are resolved right away and an attempt to import the record is carried out.  

Want to learn more?

Looking for more help? Try reviewing the following topics: Concept Link IconView Topics

 

© 2019 Total Synergy Pty Ltd

 

Open topic with navigation