Skip to main content

Setting up NetSuite fields in Kolleno

Choose the NetSuite fields Kolleno pulls, how their values show, and use them as columns and filters.

The Fields tab of the NetSuite settings page sets which NetSuite fields Kolleno pulls for each record type. It also sets how Kolleno shows each value, and if the field is a column and a filter in Kolleno.

To open the tab, go to the NetSuite settings page and click Fields.

Only company admins and the Kolleno team can open the NetSuite settings page. It is turned off by default. Contact your Customer Success Manager or Kolleno Support to enable it for your account.


The Fields tab

  • Use these fields: when this switch is on, Kolleno pulls the fields on this tab. When it is off, Kolleno pulls the fields that Kolleno set up for your company. The chip shows Using your fields or Using fields set by Kolleno.

  • Record type tabs: Customer, Invoice, Credit memo, Customer payment and Contact.

  • Pull extra fields: turn this off to stop pulling the extra fields of the record type. Kolleno continues to sync the records.

  • Your fields: the fields that you added, or standard fields that you gave a name.

  • Standard fields: the fields that Kolleno always pulls. You can choose how they show, but you cannot remove them.

When you turn on Use these fields, Kolleno asks you to confirm. From the next sync, Kolleno pulls the fields on this tab. Records that Kolleno already pulled get a new field only after a full sync with Overwrite records in Kolleno on. Click Preview on each record type first, to see the first rows that NetSuite returns. The preview does not save anything.

If a record type uses a custom query, the fields on this tab do not apply to it. Contact Kolleno Support to change that query.


Add a field

  1. Click Add field.

  2. Search the list by name, ID or type, and pick the field. If the field is not in the list, type its ID in NetSuite field ID. See Find a NetSuite field internal ID.

  3. Optional: type a Name in Kolleno.

  4. Click Use this field.

  5. Choose how the field shows and review its values.

  6. Click Save.

The list shows when Kolleno read it from NetSuite, for example Read from NetSuite just now. If you just made a field in NetSuite and it is not in the list, click Refresh from NetSuite.

Records that are already in Kolleno get the new field after a full sync of that record type. Click Run a full sync… in the notice. The sync dialog selects that record type and turns on Overwrite records in Kolleno.


How a field shows

To change a field, click the pencil icon on its row. For a field that points to another record, choose an option under Show as:

Option

What Kolleno shows

NetSuite name

The name that NetSuite shows for the record, for example "Net 30".

Another field of the linked record

A different field of the record, for example the symbol of a currency or the legal name of a subsidiary.

Internal ID

The number that NetSuite uses for the record.

Your own names

A name that you type for each value. Values without a name show their Internal ID.

For a field that does not point to another record, Kolleno shows the value As in NetSuite.


Name and hide values

The Values section lists the values of the field, with the time that Kolleno loaded them.

  • Type a name in Your name to rename a value. Names apply to every field that uses these values.

  • Click Paste names to add many names at once.

  • Select Only values without your name to find the values that you did not name yet.

  • Clear the Show check box of a value to hide it from filters and pickers. Records that hold the value still show its name.

  • Click Refresh from NetSuite to load the values again.

In the fields table, a label such as 1 without a name tells you that Kolleno has values that have no name to show. Click Add names to name them.


Columns and filters

  • Show as a column and filter: Kolleno adds the field as a column and a filter in its table. Columns and filters put [NS] before the name, so users can tell the fields that come from NetSuite.

  • Columns and filters that the Kolleno team set up for your NetSuite fields also show here, with Show as a column and filter on. To remove a column and its filter, turn it off.

  • Filter as: choose List of values when possible, or Free text for a field with too many values.

  • Also show on: choose other tables that show the field, for example Invoices, Payments or Credit notes. Choose Own table only to show it only on its own table.


Stop pulling a field

Click the bin icon on the row, then confirm Stop pulling.

You cannot remove a field with the label Always pulled. You also cannot remove a field with the label Used by settings until you change the setting that uses it.


If some NetSuite details are hidden

Kolleno reads NetSuite with the role that was used to connect it. If that role does not have some permissions, the notice Some NetSuite details are hidden shows above the fields table. Syncs work without these permissions, but some options are missing. For the full list of permissions that the role needs, see How to connect your NetSuite instance with the correct permissions.

  1. Read the permission that each line names. Click the copy icon to copy the permission name.

  2. Log in to NetSuite as an administrator.

  3. Add the permissions to the role. In NetSuite, go to Setup > Users/Roles > Manage Roles, edit the role and open the Permissions tab. Most permissions are on the Lists and Setup subtabs. If the notice shows Open the role in NetSuite, click it to open the role.

Then, in Kolleno, click Check again.

Did this answer your question?