CODEWITHSUNDEEP
netsuite
Isabella Bailey
Isabella Bailey

Reputation: 11

How to have only preferred vendor pricing appear in NS saved search results

In a report showing sales of an item, I only want the price to appear for the preferred vendor.

Under the criteria, I am using formula(numeric) 

case when {vendor} = {othervendor} then 1 else 0 end 
with greater than or equal to 1

but when I submit the search, it gives me an error:

Your formula has an unrecognized field in it. Please go back and correct the formula and resubmit.

Upvotes: 0

Views: 644

Answers (1)

michoel
michoel

Reputation: 3783

I had almost exactly this issue. In the filters side you can use ispreferredvendor (though for the result columns it's not available and you need to use a formula like the above).

Upvotes: 1

Related Questions