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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Saved Search - Why can't I use average cost or last purchase price as criteria?
I'm trying to search for all items over the value of 200 and it's just not working. It should be simple, so I'm really not sure what I'm missing?
Average Cost and Last Purchase Price are fields returned by the search, and there are plenty over 200, really not sure why it doesn't return any results.
The Search
Results with the criteria. If I add 'Purchase Price' it returns 2 results, but we don't set the purchase price, so it's unreliable field to search for.
Without the criteria, there are plenty of results where LPP and Average Cost are > 200.
0