Skip to main content

Dropdowns

The Dropdowns area sets the dropdown list, if any, on every column and optional filter that can carry one. Dropdowns make data entry faster and keep values valid, because a value picked from a list always matches a record in NetSuite.

The area lists one card per field. A chip shows whether the field is a body column (Column · body), a line column (Column · line), an optional filter (Filter), or both (for example Column · body + Filter).

Dropdowns area

Choose a Source

Set the Source for each field.

SourceUse it when
No dropdownThe person filling in the sheet types the value.
Finsyte listThe field matches one of Finsyte's built-in lists, such as Subsidiary, Account, Item, Class, Department, Location, Currency, Customer, Vendor, Employee, Entity, or Posting Period. Posting Period fields, and custom fields that point at accounting periods, use the Posting Period list by default. These lists are already maintained by list refresh. Standard fields get the matching Finsyte list automatically when the Auto-include dropdown lists for standard fields preference is on.
From NetSuite (fetch a table)The field references any other list record, such as Terms or Payment Method. Enter the Source list name, for example term, then select Fetch from NetSuite.
Fixed code listNetSuite defines a fixed set of codes for the field. The list is built in and needs no fetching.
Manual list (type name/id pairs)You want to limit the choices to a list you type yourself. See Set Up Your Own List.

Which Lists Stay Up to Date

  • Finsyte list: refreshed whenever you refresh list data, with Refresh > List Data or Refresh > Entire Workbook.
  • From NetSuite (fetch a table): fetched from NetSuite again when you select Bulk Records > Refresh Template Definitions, and when you refresh list data while the Refresh templates when refreshing list data preference is on. See Keep Templates Up to Date.
  • Fixed code list: built in. The codes come from NetSuite's definition of the field and do not change.
  • Manual list: never refreshed. To change its choices, edit the template. A fetched list that you edit becomes a manual list and stops refreshing too.

Configure a Fetched List

Select Configure on a field to open its settings, and Hide to close them.

Configuring a From NetSuite dropdown source

  • Source list, Id column, and Name column identify the NetSuite table to read. Leave the columns blank to use the internal ID and display name.
  • Detect from NetSuite looks up the source for a custom field and fills in Source list for you. If it comes back empty, type the source list name.
  • Fetch from NetSuite loads the values, up to the first 1,000 options. If the list is longer, the status line offers Fetch all N instead.
  • The fetched rows can be edited, deleted, or added to. Any change turns the list into a manual list. Select Fetch from NetSuite again to return to NetSuite's values.
  • Do not change the IDs in a fetched list. They are NetSuite's internal IDs, and the upload sends the ID, not the name shown on the sheet.
  • When two values in a list have the same name, the sheet shows each as Name (id_<id>).

Subrecord and Units Fields

  • Any field with a list can have a dropdown, including fields inside subrecords and sublists.
  • Units can have a dropdown, fetched from the account's units of measure.

Set Up Your Own List

A manual list limits a dropdown to the choices you pick, such as the departments your team posts to. It doesn't add anything to NetSuite. Each choice is a value that already exists there, and NetSuite gave it an internal ID when it was created. The upload sends that ID, so every row needs the exact ID NetSuite uses. Finsyte doesn't fill it in, and the template can't be saved while a row has no ID.

There are two ways to build the list.

Start from NetSuite's Values

The IDs come straight from NetSuite, so this is the easier way.

  1. On the field's card, set Source to From NetSuite (fetch a table) and select Configure.
  2. Enter the Source list, for example term, and select Fetch from NetSuite.
  3. Select the trash icon on each row you don't want offered.
  4. To show a value differently on the sheet, change its Name. Leave every ID as it is.
  5. Select Hide. The card's status reads Manual — N options.

Type the Pairs Yourself

  1. Look up the internal ID of each value you want to offer. See Find an Internal ID.
  2. On the field's card, set Source to Manual list (type name/id pairs) and select Configure. The panel reads Manual list — these rows are stored in the template.
  3. Select Add row once for each choice, and fill in the row:
    • Name: the text the dropdown shows on the sheet, for example Net 30.
    • Internal id: the ID you looked up, for example 2.
  4. Select Hide. The card's status reads Manual — N options.

A Terms dropdown set to a manual list with three name and ID rows

Find an Internal ID

List the IDs in Excel with the Query function.

  1. In an empty cell, enter the formula below. Replace term with the list you need, the same name you would enter as Source list, such as department or location. If you don't know the name, find the list in NetSuite's Records Catalog (Setup > Records Catalog). Its script ID is the name to use.

    =FSN.Query("SELECT id, BUILTIN.DF(id) AS name FROM term")

  2. The result spills into two columns under a header row: each value's internal ID, and its name. Copy the IDs you need into the list's rows.

Remarks

  • On the sheet, the dropdown lists the names. On upload, each name is sent to NetSuite as its internal ID, and a download shows the name again.
  • If an ID doesn't match a value in NetSuite, NetSuite rejects the record on upload, and the cell's comment reads Invalid <Column>: "<id>".
  • A manual list is stored in the template and is not refreshed from NetSuite. Update its rows when the values in NetSuite change. Selecting Fetch from NetSuite again replaces your rows with NetSuite's full list.
  • Manual lists are available for columns only. If the field is also an optional filter, the Start cell has no list for it.
  • Fields that NetSuite limits to a fixed set of codes offer Fixed code list instead. Configure it and delete the codes you don't want offered.

Test All

Test all checks every From NetSuite list in one step. It fetches each list from NetSuite to confirm that its source is right and that it has values, then reports Test all finished: X verified, Y failed. Lists you edited by hand are left as they are.

A list fails when NetSuite cannot list its source, usually because the Source list name is mistyped, when the list is empty in this account, or when NetSuite returns an error. The field's status line gives the reason. Correct the Source list, or choose a different source for the field.

Test all with one failed list and its reason on the card

Remarks

  • Status lines describe each list: Ready — built-in Finsyte list, Verified — 1,204 options (first 1,000), Fixed list — 22 codes, Manual — 8 options, Not fetched, or Source needed.
  • Saving is blocked while a list has no options. The message names the field and suggests adding rows, fetching from NetSuite, or setting the source to No dropdown.

Next step: Review and Save