Subject Re: RE: [firebird-support] how to delayed update in trigger
Author Martijn Tonies
>> Many ways to do this 2 are:
>> 1. I never put the invoice total in. I always retotal the items.
> I don't think that is a viable option. I think the total needs to be as
> the transaction was at the time of sale, not as it would if the sale was
> at the current time (with different prices).

Store the prices with the invoice items, it's easier to give a special
discount for this invoice only as well.

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum: