Updating Fees 1

[monkeysee]

I'm in a dilema! We have a fee structure that has been used for the past 5 years, we are now increasing the fees for obvious reasons...

My problem is this... I need to be able to show the new fees AND still keep the record of the old fees, allowing to view the history of invoice amounts billed and paid.

Tables:
1) Table name: Fee
FeeID
Description
Amount

2) Table name: Invoice
InvoiceID
CustomerID
BillingDate

3) Table name: InvoiceDetails
InvoiceID
FeeID
TotalBilled

How Can I add the new fee amounts and still keep the old in the customers files. Just changing the amount in the table will not work as it changes all prior billings to the new amount. Any ideas?

thanks for your help!

 

[JBinQLD]

G'day,

To Fee Table add field

OldFee - Yes/No

1. Copy all your records, paste append them to the same table.
2. To the OLD records, tick the [OldFee] field
3. Adjust the rates of your new fee set to the new values
4. Adjust your data ENTRY forms to only SELECT Fees.* WHERE OldFee=FALSE

This way the old fees are still on the system so reports etc can look them up by Fee_ID, as they do now, but users can only enter records with the new set...

JB