Hi, I tried to import data to MYOB, importlog shows there is a summary error with invalid amount. Can anyone help me figure out what is going on? Thanks

Hi Cxpril Typically, that import error means that the amount listed in the transactions doesn't match up to the calculated amount. In your case, I've added some additional columns to that report that should allow for that purchase to be imported. As you have not defined a tax code in the transaction, I've added to FRE. You will need to make sure that you do have the appropriate tax code listed and that the Tax amount listed in the import file matches the calculated amount of that tax code and the Amount includes that tax code amount. For example, $53.45 + $0.00 = $53.45 (FRE being a $0 tax code).

Purchase import data error

Steven_M
Former Staff
5 years ago
Hi Cxpril

Typically, that import error means that the amount listed in the transactions doesn't match up to the calculated amount. In your case, I've added some additional columns to that report that should allow for that purchase to be imported.

As you have not defined a tax code in the transaction, I've added to FRE. You will need to make sure that you do have the appropriate tax code listed and that the Tax amount listed in the import file matches the calculated amount of that tax code and the Amount includes that tax code amount. For example, $53.45 + $0.00 = $53.45 (FRE being a $0 tax code).
ITEMPUR.TXT0 KB
- Cxpril
  5 years ago
  Hi Steven,
  
  Thanks for your help. I noticed that when import data contains billed and received, there are always some errors. I tried to export data from my existing purchase bills, and found billed 1 received 37 (I entered billed 1, received 1 in my purchase bill). I am wondering how MYOB identify the received quantity. Thank you!
- Cxpril
  5 years ago
  Hi Steven_M
  
  I tried to use your template to import data, but there are some errors I cannot identify. Could you please help me take a look? Thank you very much!
  3.txt0 KB
  importlog.txt0 KB
  - Steven_M
    Former Staff
    5 years ago
    Hi Cxpril
    
    The import log indicates what is causing the errors with those import records. In this case:
    
    Error -25: Invalid amount.
    Error 0: Unexpected import error - Item is null or not purchased item!
    
    Error -25: Invalid amount.
    Just testing the import file it does correctly import into my company file without the quote marks contained around the currency values. As such, the recommendation would be to open the file in NotePad and do a find and replace to replace the quote marks with nothing. This should remove those quote marks from the amounts so it can be imported without them.
    
    Error 0: Unexpected import error - Item is null or not purchased item!
    
    You have extra lines at the bottom of the import file, these are attempting to be read by AccountRight as separate transactions and thus is expecting information. As it is not able to find those amounts, it is throwing an error. Remove those extra lines prior to import and it should resolve that one.

Forum Discussion

Purchase import data error

Looking for something else?

Related content

Importing Error 4077

Import timesheet error

Import Error 25 - Purchase Item

Import Item Error

IMPORT PURCHASE Error -225: Insufficient quantity at Location specified.

Payment receipt import error

IMPORT ITEM ERROR LOG- 4077

4066 Errors for price import