Forum Discussion

Annette_Liotta's avatar
Annette_Liotta
Experienced Partner
5 years ago
Solved

Importing Sales into MYOB AR 2020.2 Error code 25 if over $1000

We have been testing importing invoices into MYOB and if we keep the  value to anything under $999.99 inc or plus GST they import no problem but as soon as the sale reaches $1000 it goes to the error code 25 - Invalid amount.

Is there any issues that anyone knows of - we have over 500 invoices to import.

Thanks 

import
  • Mike_James's avatar
    Mike_James
    5 years ago

    Hi Annette_Liotta , are you saving a file to text from Excel? If you open the text file you will probably find that amounts over $1000 look like "$1,234.56". Excel adds quotes around values with commas in them, so format the amounts as general before saving the file. (Change all the amount columns including GST amounts).  

2 Replies

Sort By
Replies have been turned off for this discussion
  • Mike_James's avatar
    Mike_James
    Ultimate Partner
    5 years ago

    Hi Annette_Liotta , are you saving a file to text from Excel? If you open the text file you will probably find that amounts over $1000 look like "$1,234.56". Excel adds quotes around values with commas in them, so format the amounts as general before saving the file. (Change all the amount columns including GST amounts).