I want to use formula (numeric) as an available filter in a saved search. My search can be either a transaction or item search. I want to show the item name, a sum of the sales for it and how many times it was on a sales order. I have the search just fine but I have one for single lines and one for all transactions. I'd like to do it all on a single search. I referenced http://www.netsuiterp.com/2018/09/formula-text-field-does-not-work-as.html and https://www.sikich.com/insight/using-formula-values-as-available-filters-in-netsuite-saved-searches/#:~:text=Using%20Formula%20Values%20as%20Available%20Filters%20in%20NetSuite%20Saved%20Searches,-January%2016%2C%202019&text=Saved%20Searches%20are%20a%20powerful%20tool%20to%20solve%20problems%20in%20NetSuite.&text=So%20the%20trick%20here%20is,as%20on%20your%20Criteria%20tab.
But I cannot get this to work. I have my formula(numeric) as a criteria and when I try to mark the formula as "show in filter region", I am unable to do that.
My formula for single line transactions is: Formula (numeric) {totalamount}-NVL({taxtotal},0)-{shippingamount}-{amount} is equal to 0
It looks like you are new here. Sign in to continue.
Experience NetSuite Next firsthand Bellevue Club Hotel, 11200 SE 6th St, Bellevue, WA 98004 What to expect: Join this interactive event designed for companies exploring modern ERP solutions. Inside the Suite gives you a hands-on opportunity to experience NetSuite through product demonstrations and expert-led discussions.…
Connected data and AI-powered insights for a more resilient nonprofit Which donors sustain your mission—and where is funding at risk? When giving history, pledges, and financial data sit in separate systems, answers take too long. Join this product demo webinar to see how NetSuite Data Intelligence brings together data…
Drive better outcomes with AI built into NetSuite Next The Omni King Edward Hotel,37 King St E, Toronto, ON M5C 1E9, Canada Join NetSuite experts for a free half-day event where you'll get a tour of NetSuite Next, explore AI-powered capabilities built into the platform, and learn practical ways to optimize NetSuite for…
Have questions about NetSuite's procure-to-pay process? Ask an expert! Join our Ask An Expert Live session on November 19, 2026, at 1:00 p.m. ET, featuring @Gaurav Agrawal , Senior Manager at Spaulding Ridge, recognized SuiteMaster, Oracle ACE Associate, and one of our top NetSuite Support Community contributors. Bring…