Forum Discussion

Annette_Liotta's avatar
Annette_Liotta
Experienced Cover User
5 years ago

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...
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).  

Mike_James's avatar
Mike_James
Ultimate Cover User

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).  

Annette_Liotta's avatar
Annette_Liotta
Experienced Cover User
5 years ago

Mike_James you are a genius - it worked thank you!

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.