Validate Sheet
Validate Sheet checks a bulk record sheet for problems that would cause an upload to fail, without sending anything to NetSuite. Run it after filling in or changing rows and before you upload.
Select Validate Sheet in the Templates and Actions group while the bulk record sheet is active. Hidden rows are unhidden first so every row is checked.
![]()
What It Checks
- Required columns that are blank.
- Values in list columns that do not match anything on the list.
- Numbers, whole numbers, checkboxes, dates, and date/times that cannot be read.
- Internal IDs that are not whole numbers, or that appear in more than one place on the sheet.
- On sheets that match by External ID or allow deletion: rows of one record with different IDs, an External ID on more than one record, and records marked Delete without an ID. The banner counts these records as
withheld. - Body field values that differ between rows of the same record, such as rows that share an Internal ID or a Record Group value.
- Posting periods that are closed or locked, and dates that fall outside their posting period.
- Debits and credits on journal entry record types, including whether each entry balances.
- Line ID values on rows of a new record (no Internal ID), usually left over from copied rows. See Work With Lines.
- Line cells that differ between the rows of one line, on sheets with Inventory Assignment columns.
- Files named in file columns: that each is 10 MB or smaller, that receipts are PDFs or images, and that different files have different names. Files named without a full path are selected when you upload. See Upload Files.
Reading the Results
![]()
- Rows that an upload would send are shaded green.
- A cell with a problem is shaded orange. Hover over it to read the message.
- The Status column shows what an upload would do with each record:
Will create,Will update,Will create or update,Will delete,Will create — review warnings,Will update — review warnings,Warning: review before upload, orNo changes. An unchanged record keeps its last status, such asDownloaded Invoice INV2021, and readsNo changeswhen its Status cell is blank. For existing records the status is a link to the record in NetSuite. Will create or updateis a record with an External ID and no Internal ID: the upload looks it up and creates or updates it. See Match Records by External ID.Will deleteis a record marked Delete. See Delete Records.- The banner summarizes the run, for example
Validation passed — no issues found. 3 to create, 2 to update, 5 unchanged.orValidation warning — 7 possible issue(s) across 3 record(s) — hover highlighted cells for details.On sheets that match by External ID or allow deletion, it addsN to create or update by External IDandN to delete.
![]()
Common messages...
| Message | What to do |
|---|---|
<Field> is required. | Enter a value. |
'<value>' was not found in the <List> list. Check the value or refresh list data. | Pick the value from the dropdown, or refresh list data if the record is new in NetSuite. |
'<value>' is not a recognized date. | Enter the date in your NetSuite date format or as yyyy-mm-dd. |
'<value>' must be TRUE or FALSE. | Enter true or false. |
<Field> differs from the first row of this record; the first row's value ('<value>') will be used. | Make the body field identical on every row of the record. |
Internal ID '<id>' appears in N blocks — each upload overwrites the previous one. | Combine the rows into one record or remove the duplicate. |
Posting Period '<name>' is closed | Choose an open period. |
Date is outside Posting Period '<name>' (<range>) | Change the date or the period so they agree. |
Record is out of balance: debits <amount> do not equal credits <amount>. | Correct the amounts. |
<Sublist>: Line ID '<id>' names a line of an existing record, but this record has no Internal ID — the line will be created new. To edit that record instead, fill in its Internal ID. | To create a new record, leave the Line ID as it is. To edit the existing record, fill in its Internal ID. |
<Field> differs between rows of line <id> — the first row's value is used. | Make the line's cells match, or leave them blank on every row but the line's first. |
NetSuite needs Price Level, Currency, Quantity, Price on every Price line. Add a column for <Field> to the template. | Add the column to the template and create a new sheet. See Item Prices. |
<Field> is required on every Price line. | Fill in the cell. |
Remarks
- Validate Sheet warns about issues Finsyte detects that may affect your upload. Running it is recommended, but its warnings do not stop you from selecting Create or Add/Edit. A record with warnings may be rejected by NetSuite when you upload, so review them first.
- Required line cells are flagged only on rows where that line exists. For example, a row that holds only an expense line isn't flagged for a blank Item.
- Opportunities, estimates, work order completions, customers, items, and other records NetSuite saves without lines can be validated and uploaded without them.
- Fixing a cell does not clear its shading. Validate again to confirm.
- Rows already in NetSuite that have not changed are reported as unchanged and will be skipped by the upload.
- One Undo (Ctrl+Z) removes the shading, the Status text, and the banner.
Next step: Upload Records