Price Variance - Last Purchase

This report shows any variance in price between two consecutive purchases of an item. It can be useful, for example, to provide a quick way to monitor your vendors' pricing and catch any unreasonable increases.

The system does not match vendors for price comparison. If you have purchased the item from multiple different vendors, only the last purchase price is used in this report, regardless of whether the vendor is the same or not.

You can have this report automatically display after posting any invoices or manual checks by checking "Show price variance report after posting invoices and manual checks" in the Other tab of the Other Definitions screen.

Report Options

The options screen appears similar to the following:

image36.jpg

The following options are available to customize the report; all are optional.

Note: Variances are considered absolute values for the purpose of filtering this report.  Negative values cannot be entered as variance limits.  For example: Entering a variance from 5% to 20% would include both positive variances (5% to 20%) and negative variances (-5% to -20%).

Report Data

Each item is identified by its Item # and Description at the beginning of the row. Items purchased for the first time, will not show any variance.