Coupling Product Number and Date togather on AREV 3.12 (AREV Specific)
At 21 APR 2000 06:06:59PM John Abru wrote:
I was given this task before heading into the weekend. My boss wants me to some how attach the Date to the Product number, so when pulling old invoices, it will bring up the proper price on that date, and not the price from the current date. I think the approperate action would be creating an Relational index, and the going from there. But any additional ideas would be greatly appricated.
At 21 APR 2000 09:05PM Steve Smith wrote:
As the invoice is written, you could write the product and pricing details to the invoice record. Many systems I work on operate this way. The other way is to keep a product price history, and determine the price based on invoice date.
Steve
At 22 APR 2000 03:46AM Curt Putnam wrote:
Keeping all relevant details in the invoice record allows one to reproduce the invoice, at will, regardless of subsequent changes.
At 22 APR 2000 08:57PM Richard Hunt wrote:
The theory is very simple. I would do this…
Create a folder (file) (unless one already exists) for the product. Have multivalued associated fields for the DATE and the PRICE. Now every time the price changes, you enter the effective DATE and the PRICE. That will handle the complete history of the price changes.
Now you have to sort thru the DATEs everytime you want to get the date effective PRICE.
I use this technique all the time for effective dates.