I need to identify Payments with unapplied amounts in a Saved Search.
The FieldID says it is 'unapplied'
But this is not listed in the drop down fields in a Saved Search, nor can you use a formula with {unapplied}
Suite Answers has this article:
https://netsuite.custhelp.com/app/answers/detail/a_id/43024/kw/payment%20amount%20remaining/related/1
Which implies 'Amount Remaining' shoudl be used, but looking on my system this is 0 for all Payment records (even where they have unapplied amounts as per above).
This field works for Credit Memos, but I need the equivalent for Payments.
Any ideas?