price list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yakakose - 05 Feb 2007 18:34 GMT

I am working on a database to track inventories, sales, orders etc... but i
am facing a problem, my pricelist changes from times to times (different
prices for the same product - same reference). In fact the price change once
or twice a year so i need to enter these different pricelist in my database.
Problem? How to make it simple to choose the right pricelist? I was thinking
of putting a date as start date to use this or that pricelist.
Does anybody worked on something similar, what was the solution found (easy
to create, use)?

Thanks in advance for your help.

Reply to this Message

Bruce Meneghin - 06 Feb 2007 17:28 GMT

Rather than using "different lists", I would suggest that all prices be in
one table with start_date and end_date. Then, the lookup for a price has an
item and date as the criteria. The only extra work is updating the master
price table. This could be a two step process
1. update query changing end_date to current_date where end_date is NULL
and item is found on new price list.
2. append new records from new price list to master price list making
start_date = current_date and end_date = NULL

> I am working on a database to track inventories, sales, orders etc... but i
> am facing a problem, my pricelist changes from times to times (different
[quoted text clipped - 6 lines]
>
> Thanks in advance for your help.

Reply to this Message