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 row 5 banner lists the affected records: Upload errors (N) — 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 error (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.

Common Errors

Message	What 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.
Field must contain a value on a line	A 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 cell	The line's lot numbers, serial numbers, bins, or statuses could not be set. The note says what to check. See Inventory Detail.
<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.

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.

Other Messages

Message	Meaning
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 NetSuite	The request timed out. Check connectivity and try again.

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

Next step: Edit Existing Records