Forum Discussion

Jamie_Walton's avatar
Jamie_Walton
Contributing User
5 years ago

Import Error 25

Hi,   I recently upgraded to 2020.1 . I have been imported my purchases using miscellaneous lay out for a couple of years now. All of a sudden i am getting Import Error 25.   In my note pad i do ...
  • Jamie_Walton's avatar
    Jamie_Walton
    5 years ago
    Last night i spent two hours trying to compare the differences between an export aed transaction nd what i am importing , then when tiredness kicked i realised the transactions erroring where immediately after two blank lines. For the last two years i have been importing with two blank lines, but it just kicks up a record skipped log but doesnt cause the next transaction to fail. 2020.1 has forced me to say good bye to those blank lines with a few extra formulas to automatically get rid of them out of excel. Thankyou
Komal_S's avatar
Komal_S
MYOB Staff
5 years ago

Hi Jamie_Walton 

 

We have recently noticed that if you have dollar symbols around the amount fields in the import file, the import process can return error 25 in AccountRight 2020.1. Therefore, we would recommend removing the dollar symbol altogether from the import file before attempting to import.

 

Please let me know how you go on. 

    • Komal_S's avatar
      Komal_S
      MYOB Staff
      5 years ago

      Hi Jamie_Walton 

       

      I have tried to import the content from your import file to a sample company file and it's returning the same error -25 for some records.


      As a first troubleshooting step, could you please try entering one of the failed purchases manually into the software, and then export it. Upon comparing the exported file with the import file, do you see any significant differences? If yes, what happens when you try to match the fields in import file exactly to what's in the export file? 

       

      If nothing works, please send me the serial number of your company file by a Private Message so we can investigate further.

      • Jamie_Walton's avatar
        Jamie_Walton
        Contributing User
        5 years ago
        Last night i spent two hours trying to compare the differences between an export aed transaction nd what i am importing , then when tiredness kicked i realised the transactions erroring where immediately after two blank lines. For the last two years i have been importing with two blank lines, but it just kicks up a record skipped log but doesnt cause the next transaction to fail. 2020.1 has forced me to say good bye to those blank lines with a few extra formulas to automatically get rid of them out of excel. Thankyou

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.