Skip to main content

Getting Started with Bulk Records

Bulk Record Templates live in the Finsyte ribbon under Templates and Actions. This page shows where to find them and what each control does.

The Bulk Records Menu

Select Templates and Actions > Record Edit > Bulk Records.

Bulk Records menu

The menu contains:

  • A list of templates available to you, sorted by record type.
  • Refresh Template Definitions: reloads templates and their dropdown values to keep your data up to date.
  • Manage Templates: opens the Template Portal inside Excel, where templates are created and edited. See Manage Templates.

Buttons on a Bulk Record Sheet

When a bulk record sheet is the active worksheet, the Templates and Actions group shows three buttons: Download, Create or Add/Edit, and Validate.

Bulk record sheet buttons in the Templates and Actions group

ButtonWhat it does
DownloadPulls matching records from NetSuite into the sheet based on the applied filters. See Download Records.
Create or Add/EditSends the sheet to NetSuite, updating existing records with changes and creating new records for additions. See Upload Records.
Validate SheetChecks the sheet for problems that might stop an upload, and lists how many records will be updated or created. See Validate Sheet.

Right-click a cell under the header and select Attach File... to add an image, PDF, or other file to it. On a cell that names a file on this computer, the menu also offers Open File and Remove File. See Upload Files.

Data Retrieval > Dropdowns > Bulk Records lists the template's own dropdowns, the lists fetched from NetSuite or typed by hand, that can be added to the active bulk record sheet. See Fill in the Sheet.

Bulk Records entry in the Dropdowns menu

Next step: Manage Templates