Forum Discussion

Cxpril's avatar
Cxpril
5 years ago

Purchase import data error

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
  • Steven_M's avatar
    Steven_M
    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).

Cxpril's avatar
Cxpril

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!

Steven_M's avatar
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.

  • Cxpril's avatar
    Cxpril
    5 years ago

    Hi Steven_M 

     

    I removed the quote marks and it works. Thanks for your help.

     

    Kind regards,

     

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.