AnsweredAssumed Answered

Keep old prices

Question asked by kasenofonte on May 8, 2015
Latest reply on May 8, 2015 by kasenofonte

Good Morning

 

I have a very simple invoice system, in one table I list all the products and their prices.

 

At times the price will change, but I want to keep an history of the older prices, date when put in place and date of when it expired.  Then I need they invoice to pick up the newest price.  Is there a way to do this without fields for oldPrice1, oldPrice2, etc and newPrice?

 

 

Thanks

 

kathy

Outcomes