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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Calculating total of not overdue invoices?
Hi,
We accept payment on account for future tech support work (with a discount). We also perform work which is billed 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. And as some work is billed with credit terms, we need to allow for this, rather than have the credit used up by invoices that don't need to be paid yet.
0