Hello,
We have a very large monthly intercompany invoice which i would like to import rather than manually enter. I have attempted to import it several times but keep getting the same error message - Error -25: Invalid amount.
The process I have used is saving the changes to an Excel template that I set up and then saving it as a text tab-delimited file.
I have attached the import log as well as the text tab delimited file.
I would be grateful for any help.
Thanks.
Hi Yanike,
Thanks for making contact. I have managed to work it out myself after a lot of trial and error and many lessons learnt.
Cheers.
Hi ED70
The point of a community forum is not only to help you resolve an issue, but also to assist others who might have the same issue. It would therefore be helpful if you posted how you solved the problem and or about the lessons learned.
Regards
Gavin
Hi ED70
Open the import file in excel and check Freight Amount and Freight Tax Amount from line 111 down. This may not be the cause, however it looks odd.
Try adding {} to the first line. Otherwise AR2022 will assume the import is an export from v19.
Do an export and see how the file should be created. It is also best if column headings match exactly the export file and are in the same order. Sometimes these things don't matter, other times they do. FYI the error message MYOB provides is often unrelated to the actual issue, so may not have anything to do with the Amount.
Regards
Gavin
Hi ED70 , adding {} as a new line 1 won't help, as the fields are designed for an import into v19. AR Live "should" handle this format OK.
I would also remove the empty line 2.
Morning Mike_James gavin12345
Thank you both for your help.
I have removed the first line as suggested and reduced the file to just a couple of lines as a test and it has imported perfectly.
However, when I added back the additional lines I received a new error message - Error 0: Unexpected import error - Attempted to divide by zero.
Any suggestions?
Cheers.
