I'm creating a transaction saved search whose type is Payment to show the amount paid by each customer payment per invoice. I tried Paid Transaction Amount and Applied to Transaction Amount but both show the total invoice amount. It won't work if we have partial payments. What field should I be using?

I encountered similar issues, ended up using SuiteQL and the

nexttransactionlinelink

table to pull data

It's disappointing. Thank you! I'll probably be able to use SuiteAnalytics Workbooks. Did you try it too and didn't work?

Applied To Link Amount

for saved searches

That worked! Thank you!