Show/Hide Toolbars

SpendMap User Guide (v14.8)

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.

 

Noteworthy Questions & Options

The report can be based on either [PURCHASE ORDER] prices or [INVOICE] 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.