Add a saved search to the NetSuite Home dashboard
Add a Custom Search portlet to NetSuite Home, select a fulfillment saved search, set its dashboard title, and review picked or packed orders.
NetSuite guides
Saved searches in NetSuite
Start with the rows you expect to see. Set the record type, criteria, and result columns, then check why a search shows too many, too few, or repeated rows before you schedule it, share it, or pin it to a dashboard.
Add an External Contact to NetSuite Saved Search Email
Create an external person’s Contact, add it under Specific Recipients, and verify the saved configuration without enabling email delivery.
Build an invoice dataset in NetSuite Analytics
Build a NetSuite invoice dataset with Type and Main Line criteria. Add customer, location and currency columns, then save and reopen the definition.
Capture a Selected Ship-to Address ID for Reporting in NetSuite
Validate a sales order’s selected customer address-book reference, store the IDs in custom fields, and report a guarded customer-address display key.
Fix a NetSuite Commission Saved Search That Double Counts Partial Shipments
When one sales order line ships in parts, Applied To Transaction : Amount repeats the whole line on every fulfillment. Prorate it by shipped quantity so Sum of Commission matches what shipped.
Compare Applied To and Applying Transaction Joins in NetSuite
Choose a transaction join relative to the base record, inspect related invoice rows, and avoid totaling a repeated sales-order amount.
Compare Invoice Terms With Customer Terms in a NetSuite Saved Search
Add Customer (Main Line) : Terms to an invoice saved search, put it beside the invoice's own Terms, and spot invoices that don't use the customer's current default.
How to Convert a Legacy NetSuite XML Export to XLSX
Identify a SpreadsheetML 2003 export named .xls, prove that renaming does not convert it, and verify a new XLSX workbook without losing text identifiers, numbers or dates.
Convert text to a number in a NetSuite saved search
Use Formula Numeric with TO_NUMBER, verify text conversion before arithmetic, then calculate amount per package with explicit zero handling.
Copy a NetSuite Saved Search with Save As
Copy a shared NetSuite saved search with Save As, change your copy, and leave the team's original alone. Includes the rename step that stops an overwrite.
Drill Down From a Summary Saved Search Total in NetSuite
Click a grouped value in a NetSuite summary saved search to list the transactions behind that total, check that they add up, and return to the summary.
Email an alert when a new invoice is created in NetSuite
Turn on a saved search email alert so a colleague gets an email each time a new invoice matches, with your own sender, subject, and introduction.
How to Filter a NetSuite Saved Search by Customer Total With Summary Criteria
Group this year's invoices and cash sales by customer, then add a summary criterion so a NetSuite saved search keeps only customers whose combined sales reach 2,500.
Filter a NetSuite Customer saved search by Sales Rep
Set the base Customer criteria, expose Sales Rep as an available filter, and check how selecting and clearing it changes the results.
Filter a NetSuite saved search by a calculated text category
Use one Formula Text criterion and available filter to switch between calculated HIGH and LOW categories. Check prefix matching and blank-input behavior.
Find Sales Orders With the Same Customer PO Number in NetSuite
Build a summary saved search that groups NetSuite sales orders by PO/Check Number and keeps only PO numbers used more than once, then drill into the duplicate and open both orders.
Find the latest date on each purchase order line in NetSuite
Compare three Date fields per PO item line with GREATEST, then handle missing dates with COALESCE while preserving an all-blank result.
Fix Divide by Zero in a NetSuite Saved Search Formula
Guard a saved search denominator with NULLIF, keep a Maximum summary intact, and check that undefined prices stay blank while a real zero stays zero.
Format Dates in a NetSuite Saved Search with TO_CHAR
Add Formula (Text) columns for export-friendly date strings, use the formula helper for a custom date, and keep the original Date column for date logic.
How to highlight overdue invoices in a NetSuite saved search
Add a Highlight if... condition to an open-invoice saved search so invoices more than 30 days overdue show in color and bold, while every open invoice stays in the results.
How to highlight NetSuite saved search rows with a formula
Use a Formula (Numeric) Highlight if... condition to compare two fields on the same row, such as invoices where Amount Remaining is more than half of Amount.
How to create an invoice due-date saved search in NetSuite
Build a NetSuite invoice saved search with Type, Main Line, and due-date criteria. See the results and learn why due date alone doesn’t mean unpaid.
Why a NetSuite Invoice Saved Search Shows More Rows Than Invoices
An invoice saved search returns a main line plus item and tax lines for every invoice. Use Main Line and Tax Line criteria to get one row per invoice or one row per item.
List Every Scheduled Saved Search and Its Recipients in NetSuite
Build a saved search of Saved Search records, filter it to Scheduled is true, and add SearchSchedule : Recipient to see which searches email on a schedule, who owns them, and who gets them.
Relative vs fixed dates in NetSuite saved searches
Choose a moving date period or an exact historical range, then check the criterion and returned dates before using the results.
Why a Customer saved search repeats rows in NetSuite
Compare direct Customer fields with Contact and Address joins, identify the child records behind repeated rows, and choose the intended row grain.
How to show zero instead of a blank quantity in a NetSuite saved search
Replace a nullable Quantity result with NVL({quantity},0), preserve Sum and Maximum settings, then compare the same item groups before and after Save & Run.
Report Purchase Order Line Quantities with an Inbound Shipment Saved Search in NetSuite
Group an Inbound Shipment saved search by Purchase Order Fields > Line Unique Key so lines of the same item stay apart and each line shows ordered, shipped and received quantities.
Fix repeated sales order rows from a purchase order join in NetSuite
Compare purchase order detail and header matches in a sales order saved search, keep separate SO lines, and retain the linked PO document number.
Get Saved Search Email Alerts for Records Created by CSV Import in NetSuite
Saved search alerts don't fire for records added by CSV import or SOAP web services until you check Enable Email Alerts for WS and CSV Imports on Setup > Company > Email Preferences. Records imported before that never alert.
Saved search alerts vs scheduled emails in NetSuite
Choose the right saved search email trigger, check recipients and update fields, set a schedule, and verify delivery with a controlled test.
Schedule a weekly NetSuite saved-search CSV email
Schedule a NetSuite saved search as a weekly CSV email. Set specific recipients, message and timing, then reopen the configuration to check it.
How to schedule an invoice saved search email in NetSuite
Create a transaction saved search for invoice due dates, review its criteria, and configure it for recurring email alerts in NetSuite.
See Who Changed a NetSuite Saved Search and Who Runs It
Use a saved search's Audit Trail to find who changed it and the old and new values, and its Execution Log to see who still runs it. Then confirm your own fix and test run are logged.
How to show a progress bar in a NetSuite saved search
Add a Formula (HTML) column that turns Planned Work and Actual Work into a colored bar and percent, red when a project task runs over plan.
Show a Saved Search in the NetSuite Reports Menu
Find a saved search that's missing from Reports > Saved Searches, check Show In Menu, and confirm it's listed. Show In Menu adds a link; it doesn't share the search.
Show all journal lines after an account match in NetSuite
Collect distinct transaction IDs from matching account lines, then use a manual ID list to retrieve complete journals.
Show all sales order items in one NetSuite saved-search row
Use NS_CONCAT with order-level grouping to show one sales order row and its item list. Keep repeated items and format comma-separated output.
Show applied and unapplied credit memo balances in NetSuite
Find credit memos containing an item, preserve one document row, and show Amount Paid and Amount Remaining as Applied and Unapplied.
Show Customer Credit Context Beside Sales Orders in NetSuite
Add customer Unbilled Orders and Credit Limit to a sales-order saved search. Filter the customer value without confusing it with each order’s billing state.
Show From and To Locations on One Row in a NetSuite Inventory Transfer Search
Verify signed Inventory Transfer detail rows, then group each transfer with conditional From and To Location formulas and Maximum summary types.
How to show a results list when a NetSuite search has one match
Enable Show List When Only One Result under personal Analytics preferences, then rerun the same employee saved search and verify its one-row results grid.
Show More Long Text in NetSuite Saved Search Results
Compare a shortened Long Text result with the record, add a Formula (Text) column for a longer preview, and verify that the stored note remains intact.
Show Subsidiary Hierarchy in a NetSuite Location Dataset
Inspect related Subsidiary fields in a Location dataset, verify whether Full Name shows the hierarchy path, and filter locations by exact subsidiary values.
Sum invoice amounts by customer in a NetSuite saved search
Use Sum and Group in a NetSuite invoice saved search. Compare the grand total with customer totals, then save and verify the summary definition.
Use a Saved Search as a List View in NetSuite
Check Available as List View on an invoice saved search, then pick it from the View dropdown on the Invoices list to see open invoices with collections columns.
Use AND OR and parentheses in NetSuite saved searches
Group AND and OR criteria in a NetSuite saved search, apply a NOT item exclusion to both branches, and compare the resulting transaction lines.