Reporting Explained: Inventory History Calculated Cost

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 shows how item costs change over a selected date range.

  • Costs are based on the system’s calculated cost method
This report can be run by:
  1. Day
  2. Week
  3. Month

Generate the report

  1. Go to Reports > Standard Reports
  2. Open Inventory > History
  3. Select Calculated Cost
  4. Select a report type:
    • Day
    • Week
    • Month
  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
Dated ColumnsCalculated cost for each selected date interval (day, week, or month)
VarianceChange in calculated cost between the start and end of the selected period
MinimumLowest calculated cost during the selected period
MaximumHighest calculated cost during the selected period
DeltaDifference between the maximum and minimum cost
Ending On HandQuantity on hand as of the end date
Extended VarianceTotal cost impact of variance across quantities


    • 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: 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 - 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 ...
    • Reporting Explained: Cost Reporting- Inventory Detailed Usage by COGS Account

      The Usage Cost report shows the cost of inventory usage during a selected period. It includes detailed costs related to: Manual adjustments Invoices (received items) Returns to vendors Issued and accepted transfers Use this report to understand how ...
    • Reporting Explained: Inventory Adjustments

      Use this report to review all manual adjustments made to inventory over a selected period. It helps you: Track waste, damage, and spoilage Monitor production and non-standard inventory activity Validate that all adjustments are recorded before ...
    • 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 ...