Reporting Explained: Summary By Period
The report calculates inventory activity using the on-hand quantity and calculated cost at the start of the selected date/time range. It then summarizes all activity that occurs between the start date/time and end date/time.
You can run the report:
-
By Store
-
By Item
-
Summarized by Department, Category, or Subcategory
The report includes cost impacts from the following inventory activities:
-
Invoiced costs
-
Issued and accepted transfer costs
-
Manual adjustments
-
Returns to vendor
-
Physical inventory variance
Steps
-
Go to Reports > Standard Reports.
-
Select Inventory.
-
Click Summary by Period.
-
Apply the required filters.
-
Run the report.
Filters
Required
-
Date/Time range
Optional
By default, the report includes all stores, levels, and vendors.
Optional settings include:
-
Combine Stores
-
Include Items with No Activity
-
Include No Count Items
|
Column |
Description |
Calculation |
|
Starting Cost |
Inventory cost at the beginning of the selected date range. |
Starting quantity × calculated cost at the start of the range |
|
Received Cost |
Cost of items received during the period. |
Received quantity × vendor invoice or receipt price (+ invoice expenses when applicable) |
|
Transfer Accepted Cost |
Cost of inventory accepted from another store. |
Accepted transfer quantity × issuing store calculated cost at time of issuance |
|
Transfer Issued Cost |
Cost of inventory transferred out to another store. |
Issued transfer quantity × issuing store calculated cost at time of acceptance |
|
Sales Cost |
Cost of items sold during the period. |
Sales quantity × calculated cost at the time of the transaction |
|
Returns Cost |
Cost of items returned during the period. |
Return quantity × calculated cost at the time of the return transaction |
|
Manual Adjustment Cost |
Cost impact of manual inventory adjustments. |
Adjustment quantity × applied cost (positive adjustments) or calculated cost at time of adjustment (negative adjustments) |
|
Return to Vendor Cost |
Cost of items returned to a vendor. |
Return-to-vendor quantity × vendor price on the document |
|
Physical Inventory Variance Cost |
Cost impact of differences found during a physical inventory count. |
Variance quantity × calculated cost as of the physical inventory effective date and time |
|
Ending Cost |
Inventory cost at the end of the selected date range. |
Ending quantity × calculated cost at the end of the range |
Related Articles
Reporting Explained: Invoice Records
Use the Invoice Records report to review all invoices within a selected time period. The report helps your team verify invoice status, quantities, and costs. Reports > Standard Reports > Purchasing > Invoice Records The Invoice Records report lists ...Reporting Explained: Purchase Orders
The Purchase Orders Report provides information on all purchase orders created within a selected time period. It includes quantities, costs, document status, and commit details. Use this report to: Track purchasing activity over time Monitor purchase ...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 ...Reporting Explained: Inventory Transfers
Admin / power user · Yellow Dog Inventory 2026 WHY IT'S IMPORTANT The Inventory Transfers Report provides an overview of transfers issued and accepted within a selected time period. It shows the issuing and accepting locations, the issued and ...Reporting Explained: Sales By Day
Use this report to view total sales by day across one or more stores. This helps you: Track daily sales performance Identify trends over time Compare activity across locations Reports > Standard Reports > Retail > Sales > By Day This report ...
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: ...How To: Install the Zebra ZD411 Printer Driver
End user · Yellow Dog Inventory 2026 WHY IT'S IMPORTANT When you install the correct driver, Windows can communicate with your Zebra ZD411 printer so it prints labels and tags reliably from Yellow Dog Inventory. Without the driver, the ZD411 will not ...FAQs: What are Bins?
End user · Yellow Dog Inventory 2026 Question: What are Bins? Answer: Bins are optional location identifiers that specify exactly where an item is stored. The Bin field is free text, so you can use letters or numbers. You don’t need to create bins in ...Food and Beverage User Manual
The Food & Beverage User Manual is your key to understanding the potential of Yellow Dog. Whether you're a first-time user or a seasoned pro, this detailed manual will help you understand how to best utilize your Yellow Dog Inventory system. Download ...