Skip to main content

Download Records

Download pulls existing NetSuite records into a bulk record sheet. Use it to review records, to change them and upload the changes, or to copy existing records as the starting point for new ones.

Set a Filter

The filter cells are above the column headers. Filter By is the sheet's optional filter: pick the field to filter on, or None (no optional filter applied) to download all records. Start and End hold the value or range for that field. For example, with tranDate (the transaction date) in Filter By, Start and End are a date range; with tranId (the document number), Start holds a number such as INV2021 and End stays blank. Filter By offers the template's optional filters. A new sheet starts with the one the template preselected, and you can change it at any time.

  1. Choose a field in Filter By. The list offers None plus the optional filters defined in the template.

    Filter By list with None and the template's optional filters

  2. Enter a value in Start. For a date or number range, enter the end of the range in End. When the filter the sheet opens with has a list, Start offers a dropdown of its values. After switching Filter By to another filter that has a list, select Start and apply that list from the ribbon's Dropdowns menu. A list fetched from NetSuite or typed by hand is under Bulk Records. A Finsyte list, such as Posting Period, has its own entry, for example Financial > Posting Period. A filter's list is set on the Dropdowns step of template creation.

    Switching Filter By to terms and applying its list to Start from Dropdowns > Bulk Records

  3. The Download button becomes available when the combination is valid.

Filter cells and the Download button

Filtering by document number with tranId

Filter field typeStart onlyStart and End
Date or Date/TimeRecords on that date.Records from Start through End, inclusive.
NumberRecords equal to the value.Records from Start through End, inclusive.
ListRecords with that value. Pick it from the Start dropdown.Use Start only.
TextRecords whose value matches exactly.Use Start only.
Checkboxtrue or false.Use Start only.

Remarks

  • To download every record the template's default filter allows, set Filter By to None and leave Start and End blank. On a template without a default filter, this downloads every record of the type.

    Filter By set to None with the default filter summary

  • When Filter By names a field, enter a value in Start or End to make the button available. To download without a condition, switch Filter By back to None.

  • Filter By id filters on the Internal ID, including on a sheet that matches records by External ID.

  • The template's default filter is always applied in addition to whatever you choose. Its summary is shown after the filter cells. To change or remove it, edit the template in the Template Portal and create a new sheet.

Download

Select Download in the Templates and Actions group.

Warning: Copy anything you want to keep to another sheet before you download. Download clears every data row on the sheet before writing the results. There is no confirmation.

Rows appear as NetSuite returns them. The banner reads Download in progress — X of Y records (<filter>)… while it runs, then Download complete — N records (<filter>).

Download in progress

Each downloaded record has...

  • Its Internal ID on every one of its rows. On a sheet that matches records by External ID, its External ID is in column A, blank when it has none, and its Internal ID in column B.
  • Group 1, Group 2, and so on in Record Group, when the template has that column.
  • One row per line, with body fields repeated on each row. Lines of different sublists share rows side by side.
  • Each line's ID in its sublist's Line ID column, such as Items: Line ID. See Work With Lines.
  • On templates with Inventory Assignment columns, one row per assignment row, each with its Inventory Assignment: ID. See Inventory Detail.
  • Its files, such as images, PDFs, and receipts, as each file's name linked to the file in NetSuite. See Upload Files.
  • A Status link reading Downloaded <Record Type> <number> that opens the record in NetSuite.
  • Alternating shading so each record's rows are easy to tell apart.

Download complete

Cancel a Download

Select Cancel in the status dialog. Records already received are kept, and the banner reads Download cancelled — kept X of Y records (<filter>).

Messages

BannerMeaning
Download — no <Record Type> records found (<filter>).Nothing matched. Check the filter and the template's default filter.
Download failed — Filter By '<field>' takes a single value — enter it in Start and leave End blank.The field does not support a range. Clear End.
Download failed — No match found for '<value>' on '<field>'.The Start value is not on the field's list. Pick it from the dropdown.
Download failed — The field '<field>' is not available for filtering on this record type.NetSuite no longer accepts the field as a filter. Edit the template's filters.
Download — this sheet is from an older add-in version. Create a new sheet from the template.The sheet predates the current sheet format and cannot be upgraded.

Note: Large downloads take time. NetSuite returns records in pages, and Finsyte fetches them in parallel up to the Max Outstanding Requests setting in Advanced preferences.

Next step: Validate Sheet