Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Hide item in Saved Search that doesn't match formula criteria
I am using a Case When formula in a transaction saved search based on Item Fulfillments and Item Receipts. (Criteria: Type=item fulfillment, item receipt)
Basically want to show inventory debits (fulfillments) and credits (receipts).
My issue is with Transfer orders between branches. Each transfer order shows twice in the search, as both an IF and an IR, both showing both the fulfillment qty and the receipt qty.
I have created formulas for the Qty Fulfillment column and Qty Received column so each qty only shows once, but now there are blank lines for the items that don't meet the criteria to display.
0