Thanks all for the responses. I think I'll have to drop the idea to use Sequences and would rather use a small table for TenantID, LastInvoiceNumber and increment it.

If I have a tenant1 with 10 invoices and then if I add another tenant2, the invoice numbers for tenant2 should start from 1 and not 11.

Alright, it makes sense, I really haven't thought that I am actually sharing invoice numbers between tenants. Can you please explain in a bit more on how to approach? The...

serg-52 (11/17/2015)

---

divyang_dv 42143 (11/17/2015)

---

I am thinking to create a Sequence object for each Tenant to generate an invoice number, because each tenant should have their own set of invoice numbers....