Forum Discussion

Jasonh93's avatar
Jasonh93
Contributing Cover User
2 years ago

I get a -25 Invalid Amount error when importing data.

Hi,   I use a script to sort purchases by part number and then import the sorted data back into MYOB. This process was working fine up until last week where I started receiving a -25 invalid amount...
Mike_James's avatar
Mike_James
Ultimate Partner
2 years ago

i Jasonh93 , assuming you are using AccountRight desktop, there is no way to sort by part number.

 

If you open the imported text file in Notepad, do the amounts look OK?

 

Are you able to attach the import log, and the imported text file (or an extract of it, as this is a public forum)?

  • Jasonh93's avatar
    Jasonh93
    Contributing Cover User
    2 years ago

    Hi Mike_James,

     

    The amounts and headers are taken striaght out of MYOB, they are not edited and they look good in notepad.

     

    I will not be able to send the files at this stage.

     

    What are the possible causes? I will try to diagnose the problem myself for the moment due to this being public.

     

    Thanks.

    • Mike_James's avatar
      Mike_James
      Ultimate Partner
      2 years ago

      Hi Jasonh93 , if you wish, email me the files directly, and I will comment back to you first, then to the forum with your agreement. 

       

      Quite often, the cause is some other reason, even the order of columns compared to a standard exported file.