Reporting Explained: Inventory - History - Vendor Price

Reporting Explained: Inventory - History - Vendor Price


Use this report to review vendor pricing over time. It helps you:

  • Track price changes by vendor
  • Identify cost trends
  • Validate purchasing consistency


Standard Reports > Inventory > History> Vendor Price


The Vendor Price History report shows the price paid for items over a selected period.

  • Includes vendor details and pricing changes
  • Highlights minimum, maximum, and variance in price
  • Displays pricing trends over time

You can run the report by:

  • Day
  • Week
  • Month
  • Item


Generate the report

  1. Go to Reports > Standard Reports
  2. Open Inventory > History
  3. Select Vendor Price
  4. Select a report version (day, week, month, or item)
  5. Enter the Start Date and End Date
  6. Apply filters as needed
  7. Click Generate      

Filters

  • Date Range (Required)
    Enter a start and end date (relative date filters are not available)
  • Stores (Optional)
    Includes all stores by default
  • Levels (Optional)
    Filters by item level
  • Vendors (Optional)
    Filters by vendor

ColumnDescription
Primary VendorDefault vendor assigned to the item
Item Current RetailRetail price listed as “Retail 1” in the item record
Date ColumnsPrice paid for each selected time interval (day, week, or month)
VarianceChange in vendor price over the selected period
MinimumLowest price paid during the selected period
MaximumHighest price paid during the selected period
Ending On HandQuantity on hand as of the end date
Extended VarianceTotal cost impact of price variance based on quantity on hand



    • Related Articles

    • Reporting Explained: Inventory On Hand Report

      Use the Inventory On Hand report to see how much inventory you have available at a specific date and time. Standard Reports > Inventory > On Hand > By Item You can generate the report in multiple formats: By Dimension By Level By Store By Style The ...
    • Reporting Explained: Inventory Chart on Hand by Selected Dimension

      Use this report to visualize on-hand inventory totals by dimension. It helps you: Compare inventory across categories (for example, size, type, or location) Identify concentration of inventory value Support purchasing and inventory balancing ...
    • Reporting Explained: Inventory History Calculated Cost

      Use this report to track calculated cost changes over time. It helps you: Monitor cost fluctuations Identify pricing trends Validate purchasing and cost accuracy Standard Reports>Inventory>History>Calculated Cost The Calculated Cost History report ...
    • Reporting Explained: Summary By Period

      The Inventory Summary by Period report provides an overview of inventory activity for a selected date and time range. It shows the starting inventory cost, all inventory movements during the period, and the ending inventory cost. Reports > Standard ...
    • Reporting Explained: Inventory Requests

      Use this report to: Track request activity over time Monitor request status and completion Review quantities and costs Standard Reports > Purchasing > Inventory Requests The report pulls all inventory requests based on your selected filters. It ...
    • Popular Articles

    • How To: Find Your Yellow Dog Inventory Version

      Understanding which version of Yellow Dog Inventory you're using is essential when exploring new features, as some enhancements and functionalities are specific to certain versions. All client types can benefit from knowing their Yellow Dog Inventory ...
    • Feature Overview: Par & Re-Order Points

      Par levels and reorder points help streamline purchasing in Yellow Dog. Par level is the ideal quantity to keep on hand. Reorder point is the minimum quantity that triggers reordering. You can update par and reorder points in the following locations: ...
    • Tips & Tricks: How do I download and install drivers for my Zebra Printer?

      **As a note: Admin rights will be required to complete this task. If you do not have admin rights on your PC, please contact your IT for assistance** ZD410 Desktop Printer Support Site 1. Navigate to Drivers: 2. Select Zdesigner V. 5 Driver for ...
    • How To: Swap the On-Hand/Parent Size (Edit Base Unit)

      When managing items with multiple sizes, it’s essential to configure them correctly. The on-hand/parent size should always represent the base unit or smallest measurement, while additional sizes should be created for purchasing or counting sizes. If ...
    • FAQs: What are Bins?

      Question: What are Bins? Answer: Bins are optional location identifiers that specify exactly where an item is stored. You don’t need to create bins in advance. You can assign them: In the Stores tab of the item editor Through a Balto import Bins ...