Hello, does anyone know a better way to get unapplied/remaining amount for Vendor Prepayments via saved search? There is weirdly no native field available and SuiteAnswer suggesting a formula which could potentially be compromised if prepayment is applied to multiple bills.

Amount remaining maybe

It doesn’t work with prepayments

Use criteria main line is false Result : formula numeric : amount - amount paid