Forum Discussion

dan7's avatar
dan7
3 years ago

Error -14: Invalid account number

Hi, I'm trying to upload the first attachment, but keep getting an error saying Invalid Account number. I've attached the message here in the 2nd attachment. It's really frustrating, becuase it doesn't actually say which row the error is on, but apparently, there are 2.

 

I've checked the format to make sure it's not converting to date format and I've also tried uploading with and without the "-" between the first and 2nd numbers. Since there are only 3 account numbers (I'm just reallocating costs between job codes), I've also tried copying and pasting the account numbers down with no luck.

 

Any help would be greatly appreicated.

 

Thanks,

Daniel

2 Replies

Replies have been turned off for this discussion
  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    3 years ago

    Hi dan7 

     

    Welcome to the Community forum. This error message usually occurs when the account number is invalid or doesn't exist in your file.

     

    I recommend checking your file has the account number entered in the import file, and it's not missing any information. For example, sometimes when opening a document in Excel, it might display the information incorrectly then that gets saved. e.g. it displays 1-1000 as 11000 and then when trying to import, AccountRight does not recognize the changed account number as a valid number.

     

    If the account numbers are indeed the same, could you send through a screenshot of your account list and the file you are attempting to import so I can assist you further? 

     

    Best regards 

    Genreve
     

  • gavin12345's avatar
    gavin12345
    Ultimate User
    3 years ago

    Hi dan7  and Genreve_S 

     

    Your import was successful. There was only one journal, which was imported. The rejected journals or errors relate to blank lines you left at the bottom of the import file. Each journal is separated by a blank line. You have one journal plus 4-5 blank lines on the end, that's why there are no details next to the error code. Check your file, you should see the Journal there.

     

    Regards

    Gavin

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.