Skip to main content

Edit Existing Records

Bulk record sheets update existing NetSuite records with the same three steps every time: download, change, upload. This page walks through that cycle and the variations on it.

Warning: Always download a record before you edit it. Never type or paste an Internal ID to edit a record. Rows that were not downloaded have no Line IDs, so the upload deletes the record's existing lines in every sublist the template has columns for and adds the sheet's lines as new ones. This happens even when you change only a body field such as Memo.

Download, Change, Upload

  1. Open a bulk record sheet, set a filter, and select Download. See Download Records.
  2. Change the cells you need to. Every downloaded row already carries its Internal ID, so Finsyte knows which record each row belongs to. A changed cell on a downloaded record
  3. Select Validate Sheet to preview what will be sent. Changed records read Will update; untouched records are counted as unchanged. See Validate Sheet.
  4. Select Add/Edit. Changed records read Updated <Record Type> <number> and untouched records read Skipped (no changes). See Upload Records. Upload results after an edit

Only the fields that changed are sent to NetSuite. Everything else on the record is left as it is.

Note: Expense reports: upload before the report is saved anywhere else, such as on the NetSuite screen, through an approval, or from another sheet. NetSuite gives the expense lines new IDs on every save, so if the report was saved elsewhere, download it again first. See Expense Report Lines.

Add, Change, Replace, or Delete Lines

Two IDs work together here. The Internal ID identifies the record and is the same on every row of it. The Line ID (for example in Items: Line ID) identifies one line within that record, so it differs from line to line. When you upload, the Line IDs decide what happens to the record's lines. In short:

ToDo this
Change a lineEdit its cells. Keep its Line ID.
Clear a field on a lineDelete the cell's contents. Keep the Line ID.
Add a lineInsert a row inside the record, copy the record's Internal ID, body cells, and Record Group (if you use it) onto it, fill in the line, and leave its Line ID blank.
Copy a lineCopy the row and use Insert Copied Cells below it. The copy becomes a new line.
Replace a lineClear only its Line ID. The old line is deleted and the row is added as a new line.
Delete a lineDelete the row. If the row also holds a line of another sublist, clear this line's cells and its Line ID instead.

Work With Lines walks through each of these step by step, and Inventory Detail covers lines with lot numbers, serial numbers, bins, or statuses.

Warning: To delete a line, delete its row. If the row also holds a line of another sublist, clear this line's cells and its Line ID instead. Clearing a line's cells while keeping its Line ID does not delete the line. It clears each field, and NetSuite usually rejects that.

Adding a line to an existing record

Use an Existing Record as a Starting Point

To create a record that closely resembles one already in NetSuite...

  1. Download the existing record.
  2. Copy its rows and paste them below, leaving one blank row between the original and the copy.
  3. On the copied rows, clear the Internal ID cells, and if you use Record Group, give the rows a new value. On a sheet that matches records by External ID, also give the copy a new External ID, or clear it. Leave the Line ID and Inventory Assignment: ID cells as they are. Without an Internal ID every line is created new, and a line that spans several rows stays one line. Validate Sheet warns that each copied Line ID will be created new; that is expected for a copy.
  4. Change whatever should differ, then upload. The copy is created as a new record and the original is left unchanged unless you edited it too.

Remarks

  • If the same Internal ID appears in two separate places on the sheet, Validate Sheet warns Internal ID '<id>' appears in N blocks — each upload overwrites the previous one. Combine them into one record before uploading.
  • After an upload, the sheet is refreshed from NetSuite. Values that NetSuite changed, such as recalculated totals, appear on the sheet.
  • Uploading the same sheet again later sends only what changed since the last upload or download.
  • To update records by another system's IDs instead of Internal IDs, see Match Records by External ID. To delete records, see Delete Records.

Next step: Match Records by External ID