Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
How do figure out total of not overdue invoices
Hi,
We accept payment on account for future tech support work (with a 20% discount). We also work which we bill on the day it's done.
When we enter time, we need to know if the customer has a credit with us.
I've written a script to show the balance of the customer on the time entry form. This is not adequate though.
What I need is "balance" - "total of unoverdue invoices". We need this figure so that if this number is negative, then we can bill use the prepay service item to bill the work with in the timesheet entry. If not, we need to select the COD item.
0