[RESOLVED] Invoice number logic

[praveenp]

We have invoice generation module for customers, we need to give editable option for invoice number while generating invoice.

it should be unique and alpha numeric.

My requirement is when generating invoice, we should display automatically new invoice number in editable mode.

for this is there any logic ( i mean any algorithm ) available.

Invoice number should be like below:

1. If entered invoice number 245 then next number should be 246.
2. If entered invoice number 245A then next number should be 246A.
3. If entered invoice number AAA then next number should be search for max value in database and increment to one value.

Thanks
Praveen

[dabaR]

So you are looking to store in a database what a user's preference for invoice number format is, and use it when auto-generating next invoice numbers?

[praveenp]

dabaR;10954119 wrote:

So you are looking to store in a database what a user's preference for invoice number format is, and use it when auto-generating next invoice numbers?

Thank you dabaR.

We implemented based on last value inserted the same way i explained above.

Thanks
Praveen