Normally, Briefcase and MYOB work together without a problem. On rare occasions, however, errors may occur when exporting invoices to MYOB. If an error occurs, the MYOB software will alert the user to the failed import.
If the pop up in the image above says that records have been imported with warnings, there is no issue with the data you've imported into MYOB. Where records are skipped however you'll need to to determine the nature of the error by reviewing the 'Import Log.txt' MYOB log file. Depending on your operating system, the location of the 'Import Log.txt' file may differ. Please ensure you follow the path that MYOB shows in the error.
Navigate to the bottom of the log file to find the error. In the example below, the log shows that Error 183 had occurred.
If you are exporting multiple invoice items and an error is occurring, you will need to isolate the problem invoice/s. As in the image above, for any invoice item causing an error, the error code will be shown at the beginning of the invoice line item.
Tip - If you are exporting a large number of invoices, it may be helpful to open the log file in Excel.
Use the following guides to help resolve the error.
Common Error Messages
Error -25: Invalid Amount
This error most commonly occurs when a quantity or invoice rate is either empty or has a value of 0. Some versions of MYOB, for example, will attempt to multiply a rate by a 0 quantity, resulting in an error. Whilst Briefcase itself does not require these fields to be completed and accepts 0 amounts, MYOB may not. Commonly, these fields will be blank when a line is being used as a heading, but they may be empty for other reasons. To resolve this problem, within Briefcase enter valid data for both fields. If you are using the line as a heading, we recommend removing the heading, even if only temporarily in order to export the invoice.
Error -90: Ex-Tax Amount and Inc-Tax Amount are Invalid or blank
This error most commonly occurs when an invoice line item has a blank value for tax rate. MYOB will not accept an empty tax amount. To resolve this error, ensure that every line item in an invoice has a tax rate. ’N-T’ may be used if there is no tax. As per Error -25 above, the use of headings may sometimes cause this error. If you are using the line as a heading, we recommend removing the heading, even if only temporarily in order to export the invoice. The tax-rate may also need to be amended or added to the rate the Rates Matrix (available in the Settings tab).
Error -107: The Tax Code is invalid
This error occurs when an exported invoice includes a tax rate that does not exist in MYOB. Ensure that the Tax rates match the codes supported by MYOB. You may go to the Company details record within Briefcase to change the tax-rate to prevent future errors. Also check that the correct codes have been entered in Briefcase Settings: these may be edited in the section under ‘Taxes’ on the Accounting Tab within Settings. The tax-rate may also need to be amended or added to the rate the Rates Matrix (available in the Settings tab).
Error -183: Duplicate Invoice Number
The invoice has already been exported to MYOB. Locate the existing invoice in MYOB, delete, and then export again from Briefcase.
Error -190: Customer not found. Sale invoice not imported
This error occurs when the Customer referenced in the exported invoice does not exist in MYOB. For MYOB to match imported records, the Company Name or Last Name must match exactly. Check that the names in both Briefcase and MYOB are the same.
Error code: -235 Co./Last Name may not be blank. Sale invoice not imported.
Error code: -236 Co./Last Name may not be blank. Purchase order not imported.
Error code: -264 Co./Last Name may not be blank. Card not imported/updated.
These errors are usually caused by a Company name including special characters that MYOB has difficulty importing. To resolve this issue, check that the Contact associated with the invoice does not include special characters such as the following: ! = < > " "
The above list describes only the more common errors encountered when exporting to MYOB. If you encounter other errors, or are unable to resolve any issues with exporting to MYOB, please contact our support team.