Batch Transaction Search Tool

A reusable Suitelet that searches 100+ transactions in seconds -- zero code changes for new transaction types

100+

Transactions Per Search

5/5

Reusability Score

9.5 hrs

Total Dev Time

Code Changes for New Types

Suitelet Wholesale / Apparel

The Challenge

An operations team at a wholesale apparel company needed to look up transaction details for 100+ document numbers at once. The existing workflow required manually entering values one-by-one into NetSuite's saved search filter UI.

One-at-a-Time Lookups

Looking up 100 item fulfillment document numbers required 100 individual searches. Each lookup took 30-60 seconds including navigation time. A batch of 100 took over an hour.

Multiple Transaction Types

The same pattern was needed for item fulfillments, transfer orders, and sales orders. Building a separate tool for each type was wasteful.

The Solution

Paste, Search, Results

Users paste up to 200 document numbers into a text area using any format (commas, spaces, newlines, OR-separated). Click Submit. Results appear in a table matching the saved search columns.

Zero-Code Reusability

A single Suitelet script serves every transaction type. Each deployment has script parameters pointing to a different saved search. Adding a new transaction type requires only: (1) a saved search exists, (2) create a deployment, (3) set parameters. No code changes.

Admin-Maintainable Columns

Column display is controlled by the saved search definition. Any NetSuite admin can add, remove, or reorder columns without touching code.

View Interactive Demo

Technical Architecture

Search Query

Smart Lookup

Instant Results

Script Parameter Architecture

Parameter	Purpose	Example
Saved Search ID	Which search to load and filter	customsearch4376
Transaction Type	Display label for the UI	Item Fulfillment
Page Title	Browser title	Wholesale IF Lookup
Document Field	Which field to filter on	tranid (default)

Deployment Matrix

Deployment	Transaction Type	Code Changes
Deployment 1	Item Fulfillment	None (initial)
Deployment 2	Transfer Order	None (parameters only)
Deployment 3	Sales Order	None (parameters only)
Deployment N	Any transaction type	None (forever)

Value Delivered

60x

Faster Than Manual Lookup

98.5%

Governance Headroom

Training Time Required

Technologies Used

SuiteScript 2.1 Custom Suitelet N/search N/runtime Script Parameters HTML/CSS Rendering anyof Filter Operator

Explore the Source Code

The Parameter-driven reusable search tool with pagination and CSV export from this project is available as an anonymized, reusable reference implementation with tests.

View on GitHub