The NetSuite connector will deploy standard lists when the connector is installed. After the install, additional lists can be added using a SuiteQL script.

Create a SuiteQL script

First you will need to create a SuiteQL script to use in Popdock. The easiest way to find the table and field names for your Popdock environment is to use the Records Catalog in NetSuite.

1. In NetSuite navigate to Setup and then to Records Catalog.

2. Search for the table you want to use for your list.

3. Expand the table and select SuiteScript and REST Query API.

4. Here you can see all standard and custom fields on your table that you can use in your query.

5. Create a query based on the table name and fields as shown in the below example.

SELECT
    Id,
    currencyPrecision,
    exchangeRate,
    externalId,
    isInactive,
    isBaseCurrency,
    symbol,
    lastModifiedDate,
    name,
    overrideCurrencyFormat,
    displaySymbol,
    symbolPlacement,
    fxRateUpdateTimezone
FROM
    Currency

Add the list to Popdock

Next, you will add this script as a new list in Popdock.

1. Log into Popdock. From the main menu, select Connectors.

2. Edit your NetSuite Connector and then select Lists. Select Add and then select Add script.

3. In the Add script window add a Name for the list.

4. Paste in your SuiteQL script.

5. Select a Group.

6. Select Validate.

7. Once the list is validated, select Add.

Modify field display names

By default when a Popdock list is added the technical names for the fields will be used as the display names. You can modify these to make the list easier for the user to understand.

1. Find your newly created list and then select Edit.

2. Select Fields from the left navigation pane.

3. Modify the Name and Field type columns to allow easier viewing and filtering.

Before customization:

After customization:

You can now preview this list or add a new tab in the Popdock homepage to display your NetSuite list.

If you have questions about adding a NetSuite list, contact support@eonesolutions.com.