This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I'm trying to create a saved search for sales order lines that are already paid. I couldn't find the field that determines if an invoice line is paid already. Amount Remaining and Amount Paid do not work.

The purpose of this is to determine which SO lines are fulfillable. We only fulfill items when paid.

Hi <@U5TF1GQ20>. Here's my work. I deleted my original post since I used SO now as a starting point instead of invoice.

you should probably lower your expectations

payments for invoices are applied at the invoice level, not the line level

anything more than checking the status of the billing transaction will probably not work in a saved search by itself

But it's not line level since Payment is on the main level only as you mentioned