Subject | Re: [firebird-support] Re: One more sequence related question |
---|---|
Author | Fidel Viegas |
Post date | 2008-02-15T12:32:17Z |
On Fri, Feb 15, 2008 at 1:08 PM, Adam <s3057043@...> wrote:
I think they have simplified things a bit. If an invoice is cancelled,
then it has a flag that says it is cancelled. No deletions are
permitted (for audit trails reasons). What happens when an invoice is
cancelled another invoice, which is the reverse of the one that was
cancelled, is created. .
I guess that with this, the solution presented in
http://www.ibobjects.com/TechInfo.html#ti_AuditableSeries, will work.
Anyway, thank you all for the input given.
Fidel.
> Fidel,Hi Adam,
>
> 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.
I think they have simplified things a bit. If an invoice is cancelled,
then it has a flag that says it is cancelled. No deletions are
permitted (for audit trails reasons). What happens when an invoice is
cancelled another invoice, which is the reverse of the one that was
cancelled, is created. .
I guess that with this, the solution presented in
http://www.ibobjects.com/TechInfo.html#ti_AuditableSeries, will work.
Anyway, thank you all for the input given.
Fidel.