Any NetSuite list can be edited to include additional fields, tables and filters. This article will show you how these lists can be customized in Popdock.

Add a field to a list

There is a two step process to add a new field to an existing list on a NetSuite Connector.

1. Add the field to the SuiteQL script.

2. Add the field to the Fields list.

The field is now added to the list and you can modify the display name or field type as needed.

Add a joined table to a list

The SuiteQL query language allows you to add joins to related tables if the detail you need isn’t available on a single table. You can add multiple joins to any new or existing table.

1. Navigate to NetSuite, Setup and then 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 fields and joins on your table.

5. Select the information icon on the join you want to add.

6. Copy the JOIN PAIRS value.

7. Add the desired join with your link defined as shown below.

8. Add any fields required from the joined list by prefixing them with the table name.

SELECT
    Id,
    currencyPrecision,
    exchangeRate,
    externalId,
    symbol,
    lastModifiedDate,
    displaySymbol,
    isInactive,
    Currency.name,
    CurrencySymbolPlacement.name as SymbolPlacementName
FROM
    Currency
    LEFT JOIN CurrencySymbolPlacement ON Currency.symbolplacement = CurrencySymbolPlacement.key

9. Finally, you can add any field references as shown in the Add a field to a list section above.

Add a filter to a list

You have two options when adding filters to a list:

1. Add a Restriction like you do with other connectors.

2. Add a WHERE clause directly to the SuiteQL script.

Using Restrictions

1. Open the list you want to edit.

2. Select Restrictions.

3. Select Click here to add a restriction.

4. Add your restriction.

5. Select Add.

Using a SuiteQL WHERE clause

1. Open the list you want to edit.

2. Select Settings and then go to the Edit script section.

3. Add a WHERE clause to the end of the script to apply the filter.

4. Select Validate.

If you have questions about updating your NetSuite list, contact support@eonesolutions.com.