Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to 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.