Skip to main content

Upload Errors

When NetSuite rejects a record, Finsyte shows where the problem is so you can fix it on the sheet and upload again.

How Errors Are Shown

  • The record's Status reads Error: upload failed.
  • The cell NetSuite complained about is shaded red. Hover over it to read the full message.
  • The banner lists the affected records: Upload complete — N failed (Internal IDs: 1042, 1043, row 12) — hover each Status cell for its record's error. New records that have no Internal ID yet are cited by row number. When only one record failed, the banner shows its message instead: Upload complete — 1 failed (1042): <message>.
  • When NetSuite names the line, the mark goes on that line's row, found through its Line ID. When it names several fields on the line, each field's cell on that row is marked. When NetSuite names the line but no field, the line's first cell is marked.
  • When NetSuite reports a problem on a line without saying which one, every line of the record is marked and the message ends with — one of these lines.

An upload error on a Posting Period cell, with its note

The banner after two invoices failed, with their Posting Period cells marked

Common Errors

MessageWhat to do
<Field> is required. or Location, Department are required.Fill in the cell. If the field is not on the sheet, add it to the template and create a new sheet.
Invalid Department: "<value>"Pick the value from the dropdown. If the record is new in NetSuite, refresh list data first.
NetSuite requires an id for <Field> — enter id_<internal id> (this field can't be set by name).Enter id_ followed by the record's internal ID, for example id_7.
Record has no line items — enter at least one line.Add at least one line row for the record.
Record is out of balance — debits must equal credits.Correct the amounts.
Date is outside the Posting Period's range — make them match.Change the date or the posting period so they agree.
The Posting Period is closed — records in a closed period can't be edited.Choose an open period.
The Posting Period is locked for this transaction type — unlock it in Manage Accounting Periods or choose an open period.Unlock the period in NetSuite or choose another one.
<Field> differs between rows of record <id> — body fields must match on every row.Make the body cells identical on every row of the record.
Internal ID '<id>' is not a NetSuite internal id (whole number).Enter the record's Internal ID as NetSuite shows it, or clear the cell to create a new record.
Marked Delete, but there's no Internal ID to delete it by.Enter the record's Internal ID, or clear its Delete mark. See Delete Records.
External ID <X> belongs to record <N> in NetSuite, not to Internal ID <M> on this row. Correct one of them. and other External ID messagesSee Match Records by External ID.
Field must contain a value on a lineA line's required field was cleared while its Line ID was kept. Fill the field in, or to delete the line, delete its row. See Work With Lines.
NetSuite could not set this line's inventory detail… on a Quantity cellThe line's lot numbers, serial numbers, bins, or statuses could not be set. Hover over the cell to see what to check. See Inventory Detail.
File '<name>' wasn't found on this computer…Upload again and select the file, or open the folder that has it. You can also enter its full path. See Upload Files.
Upload stopped — different files share a name (<names>)…Give each file its own name, or a path that includes its folder, such as Jan\scan.pdf. Validate marks the cells.
File '<text>' isn't a file Upload can find…Enter the file's name with its extension, its full path, or id_<internal id>, or use Attach File....
File '<file>' must be 10 MB or smallerUse a smaller file.
File '<file>' on row N couldn't be uploaded: <reason>NetSuite didn't save the file to the File Cabinet. Fix the cause NetSuite gives, and upload again. Your role needs the Documents and Files permission.
NetSuite didn't accept '<file>' as a file for <Column>. <reason>The field doesn't hold files, or NetSuite refused this file for it. Clear the cell, or name a file the field takes.
File '<file>' must be a PDF or image file (PDF, PNG, JPG, GIF, TIF or BMP)Attach the receipt as a PDF or image.
NetSuite won't attach file <id> to the expense line: it isn't in a folder NetSuite accepts for expense report files…The file is in Attachments Received, or, with Enhanced File Security on, outside the employee's Expenses folder. Attach the receipt from this computer instead. See Expense Report Receipts.
<Field> is required on this <Sublist> line — this template has no matching <Sublist> column for it…NetSuite needs a line field the template does not have, such as Location on item lines. Add the column to the template and create a new sheet.
<Field> is required on this <Sublist> line — fill in its <Field> cells on this row.A line needs a group of fields the row left blank, for example a new Address Book row with only a label (Address is required…). Fill in those cells.
Expenses: Line ID <id> is no longer on this record. NetSuite gives these lines new ids every time the record is saved, so download the record again before making changes. Nothing was sent.The expense report was saved somewhere else after you downloaded it, or an expense line's Line ID was changed. Copy your changes to another sheet, download the report again, and make them again. See Expense Report Lines.

Fix and Upload Again

  1. Correct the marked cells.
  2. Optionally run Validate Sheet to confirm.
  3. Select Add/Edit (or Create). Only records that failed or changed are sent. Records that already succeeded are skipped, and a successful upload clears every mark.

Saved With a Warning

Some updates are saved but need a second look. The banner turns orange and names the record. Hover over the record's Status cell for the details.

NetSuite Didn't Save Every Change

NetSuite accepted the update but kept the old value of some fields. The Status ends with — NetSuite didn't save every change (hover for details), its note lists the fields, and each of their cells is marked: NetSuite accepted the update but didn't save this value; the cell shows what NetSuite kept.

An update NetSuite saved without a line Description, with the orange banner, the marked Description cell, and the Status note

The usual cause is a field the record's form doesn't have, for example a line Location or Description on a sales order form without them, or a line Description on the standard outsourced purchase order form. In accounts that use Cross-Subsidiary Fulfillment, sales order lines use Inventory Location and Inventory Subsidiary instead. Change the record to a form that has the field, or use the field the form has.

A Changed Line Was Already Processed

When a changed line had already been picked, packed, shipped, fulfilled, received, billed, or invoiced, NetSuite saves the change and sends a note. The Status ends with what happened, for example — a changed line had already been picked; check the pick in NetSuite if the change affects it, and its note keeps NetSuite's words. Any other note NetSuite sends shows as — NetSuite: <text>.

Other Messages

MessageMeaning
Download — this sheet is from an older add-in version. Create a new sheet from the template.The sheet was created before the current sheet format and cannot be upgraded in place. Create a new sheet and copy your rows into it.
Batch result missing — verify in NetSuite (see log)NetSuite accepted a batch but did not report this record's outcome. Check NetSuite for the record before uploading again.
No response from NetSuiteThe request timed out. Check connectivity and try again.

Hover messages show the first 1,000 characters. The complete NetSuite response is written to the Finsyte log, available from Help.

Next step: Edit Existing Records