Import errors
Description

You can use the Sage 50 Accounts import wizard to import data into the software. If you receive an error when you import data, most of these errors refer to a specific line and field. This makes it easy to find the issue within your import file.

Click on the error you're getting below to find out how to resolve it.

TIP: If you have headers in the file you must check the line after the one which appears in the error.

Cause
Resolution


NOTE: Before following the steps on this guide, if you access the import file over a network, re-save the file locally and attempt the import again. 

Error

Cannot read the file, as it is open in another application
Country of VAT: Country of VAT included. Tax code not flagged as using OSS/IOSS reporting.
Country of VAT: The Country of VAT must be in the EU.
Disk access error or File access error
Disk error or File error
Error in record x: Account Reference: Bank account type is not valid for the transaction type
Error in Record X: Account Reference: Reference to NON-BASE Customer/Supplier/Bank not allowed on this transaction
Error in record x: Account Reference: Illegal Nominal Ledger Account Reference
Error in record x: Account Reference: Illegal Sales/Purchase Ledger Account Reference
Error in record x: Account Reference: Reference to non-existent Sales/Purchase Ledger account
Error in Record x: Cannot import a zero-value transaction
Error in record x: Contributes to an unbalanced journal for date (credits exceeds debits by x.xx)
Error in record x: Cost Code Refn: Reference to non-existent project cost code
Error in record x: Date: Bad Value for Date
Error in record x: Default Nominal: Reference to non-existent Nominal Ledger account
Error in record x: Exchange Rate Illegal transaction type for foreign currency import
Error in record x: Fund: Charity / Non - Profit accounting is not enabled
Error in record x: Fund: Reference to non-existent fund record
Error in record x: Illegal Transaction Type
Error in record x: IntraStat Duty Code: Invalid data for IntraStat Duty Code field
Error in record x: Invalid Data for Actual field
Error in record x: Nominal A/C Ref: Reference to non-existent Nominal Ledger account
Error in record x: Postponed accounting tax code can't be used in file import
Error in record x: Stock Code: Illegal Stock Account Reference
Error in record x: Stock Code: Reference to a non-existent Stock record
Error in record x: Stock Code: Cannot post stock transactions for non-stock or service items
Error in record x: Supplier A/C Ref: Reference to non-existent Purchase Ledger account
Error in record x: Unable to reduce the quantity in stock due to the amount currently allocated
Error in record x: Sales Price: Invalid data for Stock Sales/Cost Price field
Error in record x: Tax Code: Flagged as an import tax code which can't be used on Bank Payment transactions
Error while writing data
Field too long for input buffer
Incomplete record
Insufficient disk space to import this file completely
Invalid data for...
Line too long for input buffer
Missing comma
OSS Report type: Invalid data for Transaction OSS Report type field.
OSS Report type: The Report type must be valid (Union OSS = 1, Non-Union OSS = 2, IOSS = 3).
Out of range value for...
Quotes out of sequence
Nominal A/C Ref: Bank or Control account nominal code not permitted
The number of fields in the input record is greater than the expected number of fields error number
There appears to be no records to import. Please check your data file
Unable to read any fields from the data you're trying to import

Other useful articles

How to remove hidden line breaks from a import file in Microsoft Excel

[BCB:19:UK - Sales message :ECB]




Steps to duplicate
Related Solutions