--- In firebird-support@yahoogroups.com, "Fidel
Viegas" <fidel.viegas@...> wrote:

>
> On Fri, Feb 15, 2008 at 10:13 AM, Uwe Grauer
> <uwemailmeister@...> wrote:
>
> > There is a technical paper on this.
> > Read "An Auditable Series of Numbers":
> > http://www.ibobjects.com/TechInfo.html#ti_AuditableSeries
>
> I have looked into that, and that doesn't seem to satisfy

requirement 2)

>
> That is why I have come to ask for a suggestion here.
>

Fidel,

Make sure you learn what exactly the regulations entail. With what
you have posted, the only possible implementation is to serialise the
invoice generation process. I doubt this is practical or required.
More usually, you need to be able to account for every invoice
number, including noting the fact that a given invoice is cancelled.

Adam