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:
- Select Standard Reports
- Open the folder for Inventory
- Select the Summary by Period Folder
- Select your date range and filters
Reading the Report:
- Shows the filters used to produce the report’s data, including the date selected for the report.
- 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.
- Store Name: Shows the store that the items are assigned to.
- Level: Shows the level that this item is assigned to.
- Vendor: Shows the default vendor that this item has set.
- SKU: Shows the Yellow Dog SKU for this item.
- Item: Shows the description of that item.
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- Ending Cost: Cost for the item at the end of the selected period. (Ending Quantity x Calculated Cost as of end of date range)
- 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: Purchase Order Summary
Business Need: This report will provide an overview of all purchase orders for an organization summarized by document. How it Works: Users will filter to a specific date range and have the option to include or exclude certain Status’ as needed. The ...Reporting Explained: Inventory Transfers: Summary
Business Need: This report will provide a summary of all transfers for an organization summarized by document How it works: This report will display the issuing and accepting locations, the issued, and accepted quantities, and document status. ...Reporting Explained: ReOrder
Reporting Explained: Re-Order Business Need: This report will show items that are either at or below the re-order point assigned, and include the quantities needed to bring the items back up to Par. How it works: To best utilize this report users ...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 ...
Recent Articles
FAQs: Watchdog Report
This article addresses frequently asked questions related to the Watchdog Report in Yellow Dog Inventory. General Questions Q: What is the Watchdog Report? A: The Watchdog Report scans your Yellow Dog database for errors and inconsistencies that ...Feature Overview: Watchdog Report
The Watchdog Report in Yellow Dog Inventory helps identify data issues that may affect inventory accuracy. Where: The Watchdog report is located under Home > Watchdog or can be found under your saved reports 201 – ALR – CHECK Watchdog When: Use this ...How To: Use the Watchdog Report
The Watchdog Report in Yellow Dog Inventory helps identify data issues that may affect inventory accuracy. Why It Matters: Reviewing and resolving issues identified in the Watchdog report regularly—especially before physical inventory— allow you to ...Troubleshooting: Event Not Started
This article explains what to do if your forgot to start your event. It is intended for Concession clients who manage events through the Stand Sheets module. Issue Event was not started on time. Solution Adjust your event’s Start Date/Time to the ...Invoice Staging Features
Main Page Overview <br> Right-Hand Buttons Bottom Buttons Learn more by checking out the Invoice Staging Guide Previous : Invoice Staging Workflows