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.

AdminOBT2024's avatar
AdminOBT2024
Contributing User
5 months ago

Mike_JamesThank you for the tip. I have gone through the source data and removed the line breaks. However, I am still getting the 1019 error yet each of the entries has a CardID and that field is definitely matched in the import. Any ideas why it might still be giving that error?

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    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.

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.