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: Inventory Requests: Summary
Business Need: This report will provide users with an overview of all Inventory Requests that have been created over a period, when they were committed, and can be filtered by document status’ How it works: This report displays the commit date and ...Reporting Explained: Sales By Day
Business Need: This report is helpful for users who want a summary of sales by location over a period. How it Works: A Sales>By Item report shows a summary of sales for your stores in Yellow Dog. Generating the Report: Go to the Standard Reports ...Reporting Explained: Invoice Records: By Invoice
Business Need: This report will provide users a summarized list of all invoices, and their status’ over a period. How it Works: This report displays the dollar value, and quantity count for every invoice for the selected period. This report will also ...Reporting Explained Physical Inventory Summarized by Store
Business Need: This report is helpful for users who want to view Physical Inventory data summarized to a single line per location. How it Works: The Physical inventory report Summary by Store will provide information on the Stores total on hand going ...Reporting Explained: Inventory Adjustments Manual by Store and Accounting
Business Need: This report is helpful for users who want a report to show what manual adjustments were made in the system for a selected period of time summarized by store and accounting code. How it Works: An Inventory>Adjustments>Manual by Store ...
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 ...