I need to keep a record of historic prices that my vendors give me, but only show the last update on the reports.
Part Number Price Date Updated
AAA $10.00 2015/07/01
AAA $9.50 2015/07/30
I need to keep a record of both prices, but only show the last price and use it for quotations.