Welcome back to another SuiteTip!
If you’ve ever created a transaction saved search and noticed duplicate rows, missing transactions, or unexpected totals, there’s a good chance the issue is related to the Main Line filter.
Understanding how the Main Line field works is one of the most important skills for building reliable transaction saved searches in NetSuite.
What Does Main Line Mean?
In transaction saved searches, NetSuite stores data at two levels:
Setting | Result Behavior |
|---|
Main Line = True | Returns one row per transaction |
Main Line = False | Returns individual transaction line items |
For example:
Transaction Example | Search Result |
|---|
Sales Order with 5 item lines + Main Line = True | 1 row returned |
Sales Order with 5 item lines + Main Line = False | 5 rows returned |
This behavior is especially important when working with:
- Sales Orders
- Invoices
- Purchase Orders
- Item Fulfillments
- Vendor Bills
Using the wrong Main Line setting can dramatically change your search results.
When Should You Use Each Option?
Use Main Line = True when you want: | Use Main Line = False when you need: |
|---|
One row per transaction | Item-level detail |
Header-level information | Quantities |
Transaction counts | Rates |
Summary dashboards | Item-specific reporting |
Approval or status tracking | Revenue or fulfillment analysis |
Common Mistake to Avoid
A common mistake in transaction saved searches is leaving the Main Line filter undefined or using the wrong setting for the reporting requirement.
For example:
- Using Main Line = False in a dashboard search may create duplicate transaction rows.
- Using Main Line = True in an item analysis search may hide important line-level details.
Because transaction searches can return both header and line data, it is important to decide early what level of detail your search should display.
Before saving or sharing a search:
- Verify whether you need transaction-level or line-level results
- Review totals carefully for duplicated amounts
- Compare results against standard NetSuite reports when possible
Taking a few extra minutes to validate the Main Line setting can prevent reporting issues later.
The Main Line filter is a small setting that can have a major impact on the accuracy of your transaction saved searches. Understanding when to use transaction-level versus line-level results can help you build cleaner reports, more reliable KPIs, and more meaningful dashboards.
The next time a transaction search returns unexpected results, duplicate rows, or inflated totals, reviewing the Main Line filter is a great place to start.
Happy searching!
---
Stay tuned for our next SuiteTip, where we’ll explore more tips and best practices for navigating NetSuite Reports and Saved Searches!
We encourage you to share your own tips, ask questions, and engage with fellow community members. Your experiences can help others on their journey to becoming NetSuite analytics experts!