Import Error message 25 Invalid amount and 27 A non-zero amount requires an account.
Could someone please assist to explain how to fix these. We have been getting these error messages when importing Purchases. The amounts appear to be correct with 2 decimal places and all line items have an account.
Thanks
Hi met , I recommend removing the blank line below the heading row.
Just tried to select 'Data Only' instead of 'Headers or Labels' in the 'First line of file contains' field, and this worked.
Therefore will try that when we have another large batch and see if it works for all transactions. Could you let me know what the criteria is for the two different selections for 'First Line Contains'.
Thanks Mike
Hi met , When "Data Only" is selected, the import program will read everything from the first line of the file to the end, and attempt to import every line. I would have thought this would fail, since line 1 of your file contains headings. When "Headers or Labels" is selected, the program will ignore the first line. If the second line is blank, it appears that the import program can't handle it and throws the error.
Using headers in the file makes the import easier, to my mind, as the user can see column headings when matching, and the program can auto-match if the correct column names are used.
I will try another larger batch next week Mike and let you know how it goes.
Thanks
