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

So Trying to make a saved search to search customers with overdue balances that have not made a payment in 45 days.  Any ideas?

Type invoice, Main line true , due date &gt; 45 days , status open 
Result : name 

But that won't show if they paid on old invoices yesterday.  trying to filter by both...

I have the invoice one made just need a way to then check to see if they made a payment even if it was on a different invoice

Billing transaction... date &gt; 45 days

Edit : applied to transaction ...date &gt;45 days

Ok that makes sense I am getting no results though

Not sure How I got the applied to transaction to set to date now... lol this is strange

So that returns customers with outstnading invoices over 45 days but they have paid more recently than 45 days...