I've got invoices where each line item needs to have a corresponding Vendor Bill. There's a script that creates the bill after an invoice is saved. Each invoice requires 1 to 5 bills. There are around 20,000 invoices per month. Does this many bills sound problematic? Each bill will be 'open' for around 12 months as debtors make partial payments each month burning down the bills until they are closed. Payments will need to be generated by a script when a customer pays, the script that generates the payments will be searching through tens of thousands of bills and invoices every time it runs. I could build this solution using custom GL instead of having the source transactions but having the transactions is a far nicer solution assuming volume isn't a deal breaker. Any thoughts?

Not sure I know enough to fully answer your question but what do you have for Monthly Transaction Lines and does this fit without your account limit? Based on our transaction line usage I don't think the count would be problematic. You could add a transaction line filed and when you create the bill you could link the line directly to the bill. That would allow you to interact with it directly if you need to in the payment process. What happens to the bills when the invoice is paid?

Licensing should not be an issue - we can always pay more if required.

i'm assuming there's some entity filtering you can do on the transactions right, so you want be searching through 100s of 1000s

I am validating the design to ensure we never have to run massive searches.

right I was thinking maybe it was all one customer or something like that...if that's not the case the data size wouldn't scare me at all

It's reselling insurance. One invoice has multiple policies from multiple vendors. We keep a commission; the rest of the partial customer payment is split across the other vendors (one per line item on the invoice) There are probably 30,000 invoices per month. maybe 70,0000 bills per month. Maybe 600,000 transaction lines per month. We are on the premium tier.