Subject Re: [firebird-support] Re: One more sequence related question
Author James N Hitz
Fidel Viegas wrote:
> On Fri, Feb 15, 2008 at 1:08 PM, Adam <s3057043@...> wrote:
>
>
>> 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.
>>
>
> Hi Adam,
>
> 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 dont know whether I understand what you mean when you say "another
invoice... which is the reverse.."

AFIK In Accounting, you do not reverse a "deleted" invoice, and neither
do you delete an invoice to reverse it, you issue a debit/credit note to
"double-enter" the invoice thereby "neutralizing it".

... or maybe I just did not understand what you meant.
> 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.