nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Import Error 25

Jamie_Walton

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 note that it appears the tabs are not aligned but i have counted the tabs, plus anyway if it was the tabs , all of the transactions would error.

I also note that there is up to 4 trailing zeros in the error log even though the txt file doesnt have this.

I cant see how it is a GST rounding issue as each transaction only has one GST line.

Are you able help me turn my light bulb on my head to solve these errors.

Purchase Misc.txt

importlog.txt

Find more posts tagged with

Accepted answers

Jamie_Walton

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

All comments

olibgoli

I've imported many text files before, but my latest one only imports the first sale on the .txt file, and none of the others. Anyone out there with an explanation please?????

I do not change anything in excel, just import the file directly from our software like I've always done.

Jamie_Walton

Hi Komal,

I have removed all the "$' characters and there is no change for some of the transactions returning a 25 error.

Regards,

Jamie

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.