Hi There
I am trying to do the following:
I have multiple invoices for a single customer in any given period.
The invoices are created from an integration with another system.
I am trying to group the invoices together in consolidated invoices.
The invoices are consolidated on the basis of those with the same purchase order and for a given invoice date range.
This works correctly when I do that using the following screen
However, I was wanting a way to do this in bulk. i.e. generate invoices as at a certain date and consolidated by purchase order for all customers
The closest thing I could find in Netsuite to billing in bulk is the 'Process Billing Operations' screen. There are two limitations I have found with this though:
- The 'next bill run as of date' field does not filter the individual invoices by date for grouping. For example, I had 4 invoices entered.
i.) Invoice 1, date: 15/09/2022
ii) invoice 2, date 30/09/2022
iii.) invoice 3, date 14/10/2022
iv.) invoice 4, date 25/10/2022
If I entered 30/09/2022 in the "next bill run as of date", I would expect on invoice 1 and invoice 2 to be included.
However all 4 invoices appear and are grouped together
2) The next limitation is related to there being no option to group/consolidate the invoices by purchase order in this screen.
My question is: is there a way to consolidate/group invoices in the manner I have described (by date range of the individual invoices and by purchase order) in bulk and at a set schedule?
thanks