I want to create a vendor bill for every creditor on an invoice. I am looking at around 80,000 bills per month (20,000 invoices) to start with; growth ambitions take us up to 160,000 per month (40,000 invoices). I am being challenged by a functional consultant about the volumes being too high for NetSuite. I somewhat agree (standard report performance, etc.), but does this raise alarms for anyone else? The bills will be paid in instalments. I expect 12 monthly payments to close one bill. This means there might be up to 80,000 bills open at any point, assuming the lowest-volume estimate. As long as the scripts, searches, etc. don't have to consider all open bills at once, I can only think performance might be an issue with the standard reports (A/P ageing, etc.).

What is the relation between Invoices and Bills? why 20k Invoices generate 80k bills?

An invoice contains multiple lines, each line is a service that we are reselling from a vendor: (insurance company A, insurance company B, ancillary A, ancillary B). We do not pay for the services upfront; the customers will pay monthly for the services, and we will forward part of that payment to the vendors. This means one vendor bill will be open for 12 months. That's 80,000 bills open at any one time.

I would worry about two things: • NetSuite tier monthly Transactions Lines -> Monthly Transaction Lines ◦ Setup -> Company -> Billing Information • Investigate if you can do consolidated billing, if insurance company A is used across 500 Invoices then you may be able to consolidate. 1Bill instead of 500.

We're good from a license perspective. (2mil/month) I can do consolidated bills but I'm worried about: reporting, audit, number of lines

The Bill could have individual lines, each one linked to the corresponding Invoice, 1 bill with 500 lines instead of 500 Bills. That should give you enough for audits, but if you want to consolidate the lines then you will need to think about a custom record with the break out of the lines.

Consolidating the lines sounds like a nightmare.

I would only do 500 lines, more than that becomes crazy painful for NetSuite to handle.

I like the line-level links back to the invoices, that might just about get past the stakeholders, since they are currently leaning toward individual bills.

The odds are that they want to apply one single payment, this is true and pretty standard in both sides, A/R or A/P.

I'm still leaning towards the multi-bill solution as I don't see any major impediment assuming good indexing and use of well built m/r scripts for processing.