The Item Price Verification Report runs the average price paid for each item in a selected date range per store and then aggregates those averages into lows and highs across all stores to show the variance between the store that is paying the lowest cost versus the one that is paying the highest cost on average. Contract price is also shown for comparison.
This report is useful to hold your Vendor accountable across the city or region they are supplying. If you have a hard contract price in a certain region, but the stores are all paying different prices in that region, there is an inconsistency. Always check for data-entry errors before consulting the Vendor.
This report is best run on 2 or more locations. It’s best to do this by region where the same Vendor warehouse supplies the same items, but can be useful if other Vendors are supplying similar items to find out if a certain Vendor has a better price in the region.
To navigate to the Item Price Verification Report, click 'My Reports' in the Accounting Module and select 'Purch. & Inv.' in the top header. Once opened, a listing of reports will be shown.
Find 'Item Price Verification', as displayed in the image above, and select 'Customize' next to the report. This will open up a listing of all Report Parameters that can be used to define your report.
1) Filter By - A listing of all Location categories
2) Filter - A listing of all Locations based on the selected Location category
3) Start Date - The beginning date for the report
4) End Date - The end date for the report
5) COGS Type - A listing of all COGS types created for the selected Location(s)
6) Key Items Only - This option has the report ran for either only the key items flagged in inventory or for all items
7) Run Button - Runs the report
1) Item by COGS Type - A listing of all Item Categories alphabetically with their Item names listed underneath. The User can drill into these Item records to learn more information about recent or historical transactions by clicking the hyperlinked Item name. Next to this, each item has their Unit of Measure listed
2) Location Columns - The Locations selected from the Report Parameters
3) Contract - The Contract Price set for the item by the Vendor
4) Low - The lowest price paid for the item in the selected date range and from the selected Locations
5) High - The highest price paid for the item in the selected date range and from the selected Locations
6) Variance - The Variance percentage between the highest and lowest prices for each item