Design Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a product table in my database and every now and then the price of a product changes
This in turn changes all my order and delivery values
What is the best way to archive or adjust my prices without changing them
If I have to archive the prices what is the best way to do it?
 
I generally keep the price paid (either by you or your customer) in the
details of the order or PO. Because that price is different than the
current price, it makes sense to have it in a different place.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
BruceR said:
I have a product table in my database and every now and then the price of a product changes.
This in turn changes all my order and delivery values.
What is the best way to archive or adjust my prices without changing them?
If I have to archive the prices what is the best way to do it?
Click to expand...
Hi
There are 2 ways - record the unit price on the order.
- have a price file with fk-product id, startdate, enddate, unitprice where
current rates have an end date in the future.
Marc
 
You could maintain a price history for each item with an effective date
field to indicate the start date for each change. In the query date field
use "Max" to pick the most recent price update.
 
Back
Top