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.

gavin12345's avatar
gavin12345
Ultimate User

Hi AdminOBT2024 

You need {} on the first row this will help with automapping.

 

Else nothing obviously wrong. I assume account 40230 exists?

Most likely cause is bad mapping. Physically check AccountNo. column in import is mapped to the Account # field - check all are mapped correctly.

 

If this fails, enter these 3 invoices manually, export them and study the export file - this is what MYOB is expecting for the import file.

 

Regards

Gavin

AdminOBT2024's avatar
AdminOBT2024
Contributing User
5 months ago

Thanks gavin12345 

 

I tried this and it still didn't work.

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.