'Incomplete record' when importing into Sage Accounts

Solution Properties

Solution ID:

200427112357893

Last Modified Date:

Fri Nov 04 12:00:49 UTC 2022

Taxonomy Path:

Case category//I have a problem with...//import/export

Author:

[email protected]

'Incomplete record' when importing into Sage Accounts

Description

Cause

Resolution

NOTE: For a list of other file import errors. Read more >

This message appears when the specified field starts with a quotation mark, ", but has no closing quotation mark, ".

To fix the error, edit the import file in notepad to add the missing quote then import the file again.

Still having an issue?

If you are still having an issue it could be due to a record being across multiple lines within Excel.

For example:

service Invoice
meetings
19/06/2022

Which should look like this, service Invoice meetings 19/06/2022.

You can resolve this by highlighting all the data in Excel and then click Wrap text, you'll now be able to identify any records that show across multiple lines and update them.

Steps to duplicate