Contact Us
A netsuite developer motioning to his open laptop while a netsuite consultant holds an iPad nearby.

Instructions

  1. Create a new Transaction search
  2. Criteria

saved transaction search criteria standard

  • Type: sales order
  • Status: Partially Fulfilled, Pending Billing/Partially Fulfilled, or Pending Fulfillment
  • main line: false
  • Account Type: Income
  • Shipping Line: false
  • Tax Line: False
  • Closed: False
  • Purchase Order: none
  • Formula Numeric: Formula (Numeric)

3. Results

netsuite saved search results columns customer po number

  • Absolutely important results
    • Item : Name
    • Document Number
    • Name
    • Quantity in Transaction Units
    • Formula: NVL({item.totalquantityonhand},0)
    • Formula: ({quantityuom} - NVL({item.totalquantityonhand},0) - NVL({item.quantityonorder},0) - NVL({quantityshiprecv},0) - NVL({quantitycommitted},0))
    • Item: On Hand
    • Formula: NVL({item.quantityonorder},0)
    • Quantity Fulfilled/Received

Got stuck on a step in this article?

We like to update our blogs and articles to make sure they help resolve any troubleshooting difficulties you are having. Sometimes, there is a related feature to enable or a field to fill out that we miss during the instructions. If this article didn't resolve the issue, please use the chat and let us know so that we can update this article!

Oracle NetSuite Alliance Partner & Commerce Partner

If you have general questions about SuiteCommerce or more specific questions about how our team can support your business as you implement NetSuite or SuiteCommerce, feel free to contact us anytime. Anchor Group is a certified Oracle NetSuite Alliance Partner and Commerce Partner equipped to handle all kinds of NetSuite and SuiteCommerce projects, large or small!

Horizontal Anchor Group logo orange anchor icon navy Anchor Group text

Related Articles

NetSuite Saved Searches: How to Create, Customize & Schedule Reports

NetSuite saved searches are one of the most useful no-code reporting tools in NetSuite. They let you pull real-time data from transactions, customers, items, vendors, employees, and custom records using filters, result columns, formulas, and scheduled delivery. A well-built saved search can replace recurring manual reporting, support workflows, and surface live operational data on dashboards. If standard NetSuite reports do not give you the exact view you need, saved searches usually fill the gap. You can build searches for overdue invoices, inactive customers, inventory below reorder point, purchase orders past due, pending approvals, and many other use cases without writing code. This guide explains how to create a NetSuite saved search, customize it with formulas and joins, schedule it for email delivery, add it to a dashboard, and avoid common performance and configuration mistakes.

Read the Article Two netsuite consultants seated at a table, reviewing a notebook, with a closed laptop and papers laid out in front of them.

Tagged with Training