On a Payment Event saved search, is there a way to...
# general
r
On a Payment Event saved search, is there a way to add a filter for Amount or Transaction:Amount? I opened a case with Netsuite and they said no, and tagged it to Enhancement #153588. This seems basic...but maybe I'm missing something obvious. It would be nice to use this when you know the amount but not necessarily the date it took place.
d
If you're reasonably technically savvy and just trying to address a business need (ie. searching for exceptions/chargebacks or similar) it might be worth getting to grips with Tim Dietrich's SuiteQL query tool https://timdietrich.me/blog/netsuite-suiteql-query-tool-suitelet/
👍 1
SELECT doc,paymentstatus,eventdate FROM paymentEvent WHERE (paymentEvent.amount= '0.99') returns all matching events in our account in just over 2s (and our record counts are in the millions).