Latest Item Price Report

Modified on Thu, Feb 15 at 11:43 AM

This report lists items purchased in a selected time period with the last purchase price for easy cost tracking, quick inventory counts, and total inventory $ on hand.

Filters

Filter	Description
Group	Group of locations to run a report on Select “All” from the group dropdown to run the report across all groups
Location	Select a Group, then choose a specific location or choose "All" from the Location drop-down
Invoice Date	Choose a pre-filled date range or set a custom date range
Vendor	Items from a specific vendor

Field Description

Field	Description
Location	Invoice Location
Item Name	Invoice Item Name
SKU	Invoice SKU (Stock Keeping Unit)
Unit	Invoice Unit
Pack Size	Invoice Pack Size Label
Latest Price	Invoice Price
Vendor Name	Invoice Vendor
GL Account	GL Account that the item is mapped to
Invoice Number	Invoice #
Invoice Date	Invoice Date

Access Model

Category: Spend Analysis

This is an advanced report. Contact your Account Manager or support@ottimate.com if you do not currently have access to Advanced Reports and would like to add them on.