Does NetSuite have a feature where it automaticall...
# accounting
a
Does NetSuite have a feature where it automatically creates and emails Invoices according to the Billing Schedule on Sales Orders? I've been creating a script that does this, but I want to know if I am "re-inventing the Wheel".
r
I believe if you fill in the email address on the custom record and check "To Be Emailed" on the customer record, that will check the box and fill in the email address for every invoice created, regardless of source (meaning whether it's hand-keyed or if it comes from a Billing Schedule, etc) and that when you save the invoice, an email will be fired off to whoever's email is in that box.
a
But will it create the invoice when its Next Bill Date arrives?
r
I've not seen that used too often though because I want to say that it will also send an email (or it used to) when someone would make some manual change to an invoice and re-save it. which a lot of times people don't want. Also, IIRC you can't set multiple emails in the email box on the customer record, so if you want it to go to multiple people, you're SOL.
👍 1
But will it create the invoice when its Next Bill Date arrives?
I'm definitely not an expert on Billing Schedules, but isn't that the whole point of the feature? Are you seeing that not work?
Or is that some batch process you have to run to make them generate? I can't remember the details. it's been several years since I've dealt with them. And it's been several years since I've dealt with that native email functionality too. The no multiple emails thing was always a sticking point when I tried to use it. Maybe that's been fixed, I dunno. You'd have to test.
a
Well I didn't see anything in the documentation on how to use Billing Schedules, that didn't also require some kind of manual action to cause the Invoices to be created.
r
Ok you piqued my curiosity a bit. I did a little bit of digging to refresh my memory and it looks like yeah the 'standard' way of using Billing Schedules is something you have to manually push a button for. Though presumably you could hit that button via a script. Could also try this Schedule Billing Operations thing to avoid the script. I don't know that I've ever used it and the 2 minute readthrough on SA I did on it implies it only works on "Invoice Groups", but I don't know if you could use that in conjunction with Billing Schedules to where you could have this function generate your invoices automagically. Probably worth a few minutes to test out if you're really wanting to avoid scripting. Good luck!
👍 1
a
Thanks I'll check it out!
c
Billing Operations does do this
a
I tried out the Billing Operations Feature and it's really nice, but it looks like although it will run on a regular basis, we'll have to change the "Next Bill Run As Of Date" on a regular basis to make sure it doesn't create Invoices whose next bill date is in the future, while still having it create them when the current date reaches those future dates. Unless I'm misunderstanding how it works. My client also wants it to wait until the first business day of each month, rather than always creating the Invoices and emailing them on the 1st calendar date of the month if it lands on a weekend or holiday.