Fix AP invoice import errors
Most AP invoice import errors have one of three causes: the file is still open, a date isn’t valid, or the file’s columns don’t match the import template. Find your error message below and try the fix before you contact support.
Why this happens
Section titled “Why this happens”Nexsyis staff set up each AP import template to read a file with a specific layout: which column holds the vendor, invoice number, date, amount and so on. If a vendor changes its file, or a file is built by hand, the columns may no longer match the template.
Error messages and fixes
Section titled “Error messages and fixes”“The process cannot access the file … because it is being used by another process.”
The file is still open, usually in Excel. Close it everywhere, including OneDrive or other sync previews, then select Browse and choose the file again.
“The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.”
At least one date in the file isn’t a real date. Look for typos such as two periods in a row (10..2.2026), missing parts of a date, or text in a date column. Make every date in the file use the same format, then save the file, close it and import again.
“Cannot find column 2” or “String or binary data would be truncated.”
The file layout doesn’t match the template you chose.
- Make sure you chose the right template in Import Template.
- Compare your file with one that imported successfully before: it needs the same columns, in the same order, with the same header row.
Long text in a short field, such as an invoice number or folder number, can also cause the “truncated” error.
An error when saving a new or edited import template
Make sure you have the latest version of Nexsyis, restart it and try again. If it still fails, send Nexsyis Support a screenshot of the template and the error.
Example
Section titled “Example”A shop starts importing a new type of vendor file with an existing template and gets “truncated” errors. The new file has different columns from the old one. Nexsyis Support creates a second version of the template to match the new layout, and asks the shop to put the folder number in the expected column. The file then imports.
When to contact support
Section titled “When to contact support”Contact Nexsyis Support at nexsupport@nexsyis.com if the file is closed and the dates are clean but you still get an error, or if your vendor has changed its file layout. Include:
- The whole file you’re trying to import.
- The exact name of the template you chose.
- A screenshot of the error.
Support may need to update the template’s mapping or create a new version of the template for the new layout.
