Forum Discussion

AdminOBT2024's avatar
AdminOBT2024
Contributing User
5 months ago

Sales - Service - Import Errors 14 and 1019

I am trying to do an import of sales using the template provided. I am getting 2 errors each time I try and import the data. Error 14: Invalid account number Error 1019: CardId must be selected   ...
  • Mike_James's avatar
    Mike_James
    5 months ago

    Hi AdminOBT2024 , if you are matching on Card ID, deselect the other two "key" fields, ie co/lastname and record ID. This can confuse the import process. Try this first. 

    Also I prefer to place the Card ID after the company name/s. The import process can be fussy about things like that. I note that the error says "must be selected", not "invalid", so it seems that it cannot find the field in the file.

Mike_James's avatar
Mike_James
Ultimate Cover User
5 months ago

Hi AdminOBT2024 , another issue is that there are line breaks in the description field of the first invoice, so the text following the line break is placed on the next line, and this causes the account number error. 

 

Eg:

...Box of 12

To be sent...

 

Probably best to remove these at source if you can.

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.