RE: Add a formula(numeric) as an available filter in a saved search

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

raymondand4 Rookie Asked on September 4, 2020 in Saved Searches.
Add Comment
10 Answers

Here is my search that shows me orders how many items have been sold with just a single line item on them

RE: Add a formula(numeric) as an available filter in a saved search

for the results you see that I have the count of document number to give the number of lines.  So part A has been a single line 200 times, B has been single line 112 times, etc.

RE: Add a formula(numeric) as an available filter in a saved search

 

I have another search that shows me item sales with revenue by item name. What I’d like is to have a single search that I can say Part A has x amount of revenue Part B has y revenue. Cool, now I enter 1 into an available filter and it shows me those single line results where Part A’s revenue is now the revenue only when it was a single line item.

 

Rookie Answered on September 4, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.