4Reports and Inquiry
Option 18Price and Purchase History Inquiry
For a given product and vendor, this inquiry function shows the quoted purchase price; lead time; unit of measure; date price was updated; last purchase price and date; month-to-date, year-to-date, and lastyear totals for units, purchases, and average purchase price; prices and inflation rates for 1 to 6 months ago and last price paid; annual inflation rate; and current quoted price.
Here is a sample Price and Purchase History Inquiry:
********************** Price & Purchase History Inquiry *********************
Product 10 #10 3-1/2" White Round
Vendor 00000020 Pool and Associates
Quoted Pur Price Lead Time U/M Price Updated Last Pur Price Last Pur
110.250 10 EACH 07/31/85 100.250 05/29/89
Pricing Units Purchases Avg Pur Price
Month-To-Date 0.00 0.00 0.000
Year-To-Date 1500.00 120000.00 80.000
Last Year 5000.00 250000.00 50.000
Price 6 Months Ago = 0.000 Inflation Index = 0.0
Price 5 Months Ago = 92.000 Inflation Index = 19.8
Price 4 Months Ago = 96.000 Inflation Index = 14.8
Price 3 Months Ago = 95.000 Inflation Index = 16.1
Price 2 Months Ago = 97.000 Inflation Index = 13.7
Price 1 Month Ago = 110.250 Inflation Index = 0.0
Price Last Paid = 100.250 Inflation Index = 10.0
Annual Inflation Rate = 0.0