---
title: Customizable Columns and Filters - New (NetSuite)
slug: commercebank/customizable-columns-and-filters-new-netsuite
docTags: bSho0M8HRjDvZq9EBIWDy
createdAt: 2026-09-16T07:45:43.762Z
---

Customizable Columns and Filters help you personalize the Pay Bills table to focus on the information most relevant to your workflow. Customize which bill fields display in your table and apply filters to narrow the list to specific bills. Your customizations save to your user profile and persist across sessions.

:::hint{type="info"}
**NOTE:** If you can access Pay Bills, you can customize columns and filters. No additional permissions are required.
:::

***

## Customizing Columns

Use the column customization panel to control which bill fields display in your table and their order.

:::::WorkflowBlock
:::WorkflowBlockItem
### Opening the Column Panel

Navigate to **Payments → Pay Bills**

Click **Customize Columns** in the table toolbar

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/6wOnAy95o_UWzCGRHWGHx_customizecolumnbills.jpg" size="80" isUploading="false" position="center" width="800" height="409" darkWidth="800" darkHeight="409" alt="Accessing Customize Columns" showCaption="false"}

**Panel sections:**

- **Additional Columns (left):** Fields available to add to your table
- **Selected Columns (right):** Currently displayed fields in display order
- **Total counter:** Shows selected columns out of 30 maximum

Columns marked with a lock icon (🔒) are required and cannot be removed or moved.

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/ZuwRRDhyj-cn2RaNtB4-R_customizecolumnspanel.jpg" size="80" isUploading="false" position="center" width="800" height="1064" darkWidth="800" darkHeight="1064" alt="Customize Columns Panel" showCaption="false"}
:::

::::WorkflowBlockItem
### Adding Columns

1. **Locate the field** in Additional Columns
   - Use the search box to filter by name
   - Browse the complete list
2. Click the** + icon** next to the column name or **Drag and Drop** the column to your preferred order in the Selected list
3. **Repeat** to add multiple columns

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/QF_jYBZiXVUY3DRGpmPRe_addcolumnsbutton.jpg" size="80" isUploading="false" position="center" width="800" height="1061" darkWidth="800" darkHeight="1061" alt="Adding Custom Column to the Panel" showCaption="false"}

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/qhL04_3uQFM31_i6fHSIx_addcolumnsdrag.jpg" size="80" isUploading="false" position="center" width="800" height="1064" darkWidth="800" darkHeight="1064" alt="Drag and Drop Column" showCaption="false"}

4. Click **Save Changes** to apply

:::hint{type="info"}
**NOTE:** The Commerce Connections plugin supports standard bill fields and custom transaction body fields (custbody\_\*). Custom fields must meet specific requirements—see Custom Field Support below.
:::
::::

::::WorkflowBlockItem
### Removing Columns

1. **Locate the column** in Selected Columns
2. **Hover** over the column name
3. Click the** (-) icon** that appears
4. **Click Save Changes** to apply

The field moves back to Additional Columns.

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/BfvYq-P6v68F6cseGRwi1_removecolumns-1.jpg" size="80" isUploading="false" position="center" width="800" height="1060" darkWidth="800" darkHeight="1060" alt="Remove Column" showCaption="false"}

:::hint{type="info"}
**NOTE:** Locked columns (marked with 🔒) cannot be removed. Required columns include Bill Number, To Pay, and Payment Method.
:::
::::

::::WorkflowBlockItem
### Reordering Columns

Change the display order of columns using either method:

**Drag and Drop:**

1. Hover over the field in Selected Columns
2. Click and hold the drag handle (⋮⋮)
3. Drag up or down to the desired position
4. Release when positioned correctly
5. Click** Save Changes**

**Arrow Controls:**

1. Hover over the field in Selected Columns
2. Click** ↑** to move left in the table
3. Click** ↓** to move right in the table
4. Click** Save Changes**

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/lV4kehpShpghx9sjlAkuT_movecolumn.jpg" size="80" isUploading="false" position="center" width="800" height="1061" darkWidth="800" darkHeight="1061" alt="Re-Order Column" showCaption="false"}

:::hint{type="info"}
**NOTE:** Locked columns cannot be reordered.
:::
::::

:::WorkflowBlockItem
### Resetting to Default

1. Click** Reset to Default** in the panel header
2. **Confirm** the reset

Your columns return to the standard Intacct layout and save automatically.

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/c0KZkYO-35jk2L-RWDs6S_resettodefault.jpg" size="80" isUploading="false" position="center" width="800" height="978" darkWidth="800" darkHeight="978" alt="Reset to Default" showCaption="false"}

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/jPhe-7CpZqCfQyXNNokz-_column-resetted.jpg" size="80" isUploading="false" position="center" width="800" height="1060" darkWidth="800" darkHeight="1060" alt="Reset to Default Completed" showCaption="false"}
:::
:::::

### Column Limitations

- Maximum 30 columns can be selected
- Required columns (🔒) cannot be removed or moved
- Column width is automatically determined and cannot be adjusted
- User-specific settings do not transfer to other users
- Custom fields cannot be sorted
- **Custom field support:** NetSuite supports custom transaction body fields (custbody\_\*). See below for requirements.

***

## Custom Field Support

The Commerce Connections plugin supports custom transaction body fields (custbody\_\*) as both columns and filters. Custom fields must meet specific requirements to appear in the column and filter lists.

### Requirements

**1. "Store Value" must be checked in NetSuite:**

- Go to **NetSuite → Customization → Transaction Body Fields**
- Find your custom field
- Verify **"Store Value"** checkbox is **checked**
- Fields with "Store Value" unchecked cannot be displayed or filtered

**2. Field type must be supported:**

**Supported field types:**

- **Text:** TEXT, TEXTAREA, EMAIL, PHONE
- **Numbers:** INTEGER, FLOAT, DECIMAL, CURRENCY, PERCENT
- **Boolean:** CHECKBOX
- **Date:** DATE (without time component)
- **Dropdown:** SELECT (single selection only)

**Not supported:**

- Date/Time (only DATE without time is supported)
- Multi-Select (only single-select dropdowns are supported)
- Rich Text
- Image
- File
- Password

:::hint{type="info"}
**NOTE:** Custom fields cannot be sorted. Clicking a custom field column header does not sort the table due to performance constraints.
:::

***

## Customizing Filters

Use filters to show only bills matching specific criteria. Filters apply immediately without requiring a save action.

:::::WorkflowBlock
:::WorkflowBlockItem
### Opening the Filter Panel

Navigate to** Payments → Pay Bills**

Click** Filters** in the toolbar (top right)

The filter panel opens from the right side of the screen.

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/8GqqPaVe-dZv3U-_fpthi_showfilters.jpg" size="80" isUploading="false" position="center" width="800" height="408" darkWidth="800" darkHeight="408" alt="Show Filters" showCaption="false"}

**Panel sections:**

- **Search dropdown**: Add new filters
- **Pinned section**: Saved filters that appear every session
- **Active section**: Temporary filters for current session
- **Clear All / Reset buttons**: Manage filter values

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/tKpZK2SD8jYsj6WhcdK_s_filterpanel.jpg" size="40" isUploading="false" position="center" width="800" height="1269" darkWidth="800" darkHeight="1269" alt="Filter Panel" showCaption="false"}
:::

::::WorkflowBlockItem
### Adding Filters

1. **Click the search dropdown** (Search Filter to add)
2. **Type** to find a filter or scroll the list
3. **Click the filter name** to add it

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/ESSA_tjidsjUOXYh968-H_addingfilter.jpg" size="40" isUploading="false" position="center" width="800" height="1299" darkWidth="800" darkHeight="1299" showCaption="false"}

4. The filter appears in **Active section**
5. **Enter your criteria** in the filter control

The table updates immediately as you enter values.

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/6sBW_gD9b5L4ib3_mv865_applying-filters.jpg" size="80" isUploading="false" position="center" width="800" height="408" darkWidth="800" darkHeight="408" alt="Applying Filters" showCaption="false"}

:::hint{type="info"}
**NOTE:** Custom transaction body fields (custbody\_\*) are available as filters if they meet the same requirements as columns. See Custom Field Support above.
:::
::::

::::WorkflowBlockItem
### Pinning Filters

Pin frequently-used filters to save their structure (not values) to your profile.

**To pin a filter:**

1. **Locate the filter** in Active section
2. **Hover** over the filter
3. **Click the pin icon** (📌)
4. Filter moves to **Pinned section**

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/tKpZK2SD8jYsj6WhcdK_s_filterpanel.jpg" size="40" isUploading="false" position="center" width="800" height="1269" darkWidth="800" darkHeight="1269" alt="Filter Panel" showCaption="false"}

:::hint{type="warning"}
**IMPORTANT:** Pinned filters save filter field only. Values are cleared when you close the panel and must be re-entered each session.

**Maximum 15 pinned filters.**
:::

**To unpin a filter:**

1. **Locate the filter** in Pinned section
2. **Hover** over the filter
3. **Click the pin icon** (📌)
4. Filter moves to Active section and values clear
::::

:::WorkflowBlockItem
### Clear All vs Reset

**Clear All:**

- Removes all filter values
- Keeps filters visible
- Use to apply different criteria with same filters

**Reset:**

- Removes all active filters
- Clears pinned filter values (structure remains)
- Use to return to baseline
:::
:::::

***

## FAQs

:::ExpandableHeading
**Do my settings save when I log out?**

Column layouts save completely. Pinned filter fields saves, but values are cleared.
:::

:::ExpandableHeading
**Can other users see my customizations?**

No. Settings are user-specific.
:::

:::ExpandableHeading
**Why can't I remove certain columns?**

Required columns (🔒) are essential for bill processing and cannot be removed.
:::

:::ExpandableHeading
**Can I add NetSuite custom fields?**

Yes. NetSuite supports custom transaction body fields (custbody\_\*) as both columns and filters. The field must have "Store Value" checked in NetSuite and be a supported type.
:::

:::ExpandableHeading
**Can I filter by custom fields?**

Yes. Custom fields that meet the requirements (Store Value checked, supported type) are available as filters. Filter by custom field the same way you filter by standard fields.
:::

:::ExpandableHeading
**Why doesn't my custom field appear in the column list?**

Check these two things:

"Store Value" is unchecked in NetSuite - Go to NetSuite → Customization → Transaction Body Fields and verify "Store Value" is checked
Unsupported field type - Only Text, Number, Boolean, Date, and single-select Dropdown are supported
:::

:::ExpandableHeading
**Why can't I sort by my custom field?**

Custom fields cannot be sorted due to performance constraints.
:::

:::ExpandableHeading
**What's the difference between Clear All and Reset?**

Clear All removes values but keeps filters. Reset removes active filters and clears pinned values.
:::

:::ExpandableHeading
**How do multiple filters work together?**

All criteria must match (AND logic).
:::