PURCHASING > Reports > Supplier information > Price variance
This report shows how a supplier's prices have changed over time.
The Summary Report lists the items purchased from a supplier along with 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 calculations.
Following the list of items, a summary/total price variance for the supplier is shown.
Noteworthy Questions & Options
•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. |
•When running the Detail Report for all suppliers (that includes a list of specific purchase transactions that went into the price summary calculations), you can include [ORDERS FOR EACH SUPPLIER ONLY] or for . If you select , all purchase order transactions (regardless of the supplier(s) specified for the report) will be considered for price variance calculations (the supplier specified for the report will be highlighted in the purchase transaction details section). Essentially the option produces and overall price variance report as opposed to a supplier-specific price variance report.
•If is chosen, any purchases in foreign currencies will be converted to landed dollars.
