PURCHASING > Reports > Item information > Price variance
This report shows how an item's prices have changed over time.
The Summary Report lists summary pricing information for the date range specified, including the minimum, maximum, average, and current price for each item, as well as how much the pricing has changed during the period as both a percentage and dollar amount.
The Detail Report lists all of the above plus a list of specific purchase transactions (with itemized pricing) that went into the price summary calculation.
•The report can be based on either prices or prices (if you are using the optional Invoice Approval Module). However, due to the way invoice information is stored for item history (the source of data for this report) the invoice price differs slightly in meaning from that of the PO price, as follows:
Value |
PO Price |
Invoice Price |
UNIT PRICE |
Price entered on PO |
Average of all invoices processed for the PO line item |
INCLUDED CHARGES |
Not included in price |
Included in price |
DATES/DATE RANGE |
Based on PO date |
Based on PO date |
In addition, in the case of PO unit price option, any purchase orders with no value (unit price is zero) are not included on the report. Similarly, if using the invoice price option, any non-invoiced purchase orders are not included on the report. |