Reporting Explained: Summary By Period

Reporting Explained: Summary By Period

Business Need:  A user would like to see a summary of all activity for items between two dates. 

How it Works:  This report will show all movement between two selected dates. This report can filter to as broad as by store, or as granular as by item.  Data includes sales, manual adjustments, transfers, purchases, physicals, etc.  This report is dynamic and may change if backdating documents or adjustments are entered into the system.

Generating the Report:


Go to the Standard Reports section in Yellow Dog:

  1. Select Standard Reports
  2. Open the folder for Inventory
  3. Select the Summary by Period Folder
  4. Select your date range and filters


Reading the Report:



  1. Shows the filters used to produce the report’s data, including the date selected for the report.
  2. Change columns, sorting, and grouping:  This allows users to add or remove data columns to this report as well as organize and group the data.
  3. Store Name: Shows the store that the items are assigned to.
  4. Level:  Shows the level that this item is assigned to.
  5. Vendor:  Shows the default vendor that this item has set.
  6. SKU: Shows the Yellow Dog SKU for this item.
  7. Item: Shows the description of that item.
  8. Starting Cost: Shows the starting cost for the item’s on hand at the start of the selected date range. (Starting Quantity x Calculated Cost as of start of date range)
  9. Manual Adjustment Cost:  Shows the cost for any manual adjustments made during this selected period. (Manual Adjustments Quantity x Applied Cost or Calculated Cost at time of adjustment)
  10. Received Cost:  Shows the cost for any quantities that were received during the selected period. (Received Quantity x invoice or receipt vendor price plus invoice expenses)
  11. Return to Vendors Cost:  Shows the cost for any items included in a Returned to Vendor during the selected period. (Returned to Vendor Quantity x Item Retail at the time of return)
  12. Transfers Accepted Cost:  Shows the cost for any quantity included on an accepted transfer during the selected period. (Transfers accepted Quantity x this store’s Calclualted Cost at the time of issue)
  13. Transfers Issued Cost:  Shows the cost for any quantity included on an issued transfer during the selected period. (Transfers issued Quantity x this store’s Calclualted Cost at the time of issue)
  14. Sales Cost. Shows the cost for any quantity that was sold during the selected period. (Sales Quantity x Calculated Cost at the time of sale)
  15. Returns Cost:  Shows the cost for any quantity that was returned during the selected period. (Returns Quantity x Calculated Cost at the time of the return)
  16. Physical Inventory Variance Cost:  Shows the cost for any variances found for the item on a physical during the selected period. (Physical Inventory Quantity x Calculated Cost at Physical's Effective Date)
  17. Ending Cost:  Cost for the item at the end of the selected period. (Ending Quantity x Calculated Cost as of end of date range)
  18. Print/Save/Export: Are available on every report. Export options: Excel, CSV, PDF. 



    • 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 ...
    • How do I use Par & Re-Order Points?

      What is a Reorder Point? The minimum quantity you would like inventory of the item to be before ordering more. Items must go below this level to trigger reorder. Items set to 0 will not reorder until you go into negative stock. This is not ...
    • 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 ...
    • Food and Beverage Core Features User Manual

      The Food & Beverage Core Functions 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 ...