calculations on historic prices

[paul.clarke]

I am looking into using some historic prices/rates to calculate values. The trouble is if the rates/prices change, the values will automatically be calculated on the new prices, Is there anyway i can use for example a rate from 2008??

Is not not an option to have a seperate database table for old rates, as there are far to many and change to often.

i.e "price" is generally a field on the "product" table, but as this is subject to change, i do want the cost of an old order based on a old price to change.

Any suggestions.
Thanks

 

[Simon_MT]

The prices need to taken down to the individual items rather than globally from the Product file. The same may also apply to Sales Tax as this can change periodically.

Simon

 

[paul.clarke]

Thanks.

I'll explain a lilttle bit more, I have an enquiry, on this i have different products, these products can have different rates/prices for items like ocean freight, delivery costs, exch rates etc, at the moment these costs are being entered onto spreadsheets, so basically i can have thousands of enquiries and as a result i have thousands of spreadsheets.

So i want to be able to store this prices somewhere in the datatbase tables, and i dnt want them to update when they change, however changes happen frequently.

If i understand you correctly, i need to store each seperate cost on each individual line (if i have the empty fields available on the table) ?

 

[DCrake]

If I understand you correctly you are calculating quotes for orders based on current prices and exchange rates. And the resulting enquiries are saved in a spreadsheet.

If you break down the computation down into the individual elements such as

Product price
Exchange rate
delivery
etc

These act as default values for all new enquiries. If you choose to save the quote then these elements need saving in the database table. The calulation is derived from a query.

Thus maintaining historical costings.

David