>> 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
http://www.upscene.com

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

Database questions? Check the forum:
http://www.databasedevelopmentforum.com