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
Feature Overview: Client ID
What is a Client ID? The Client ID is a unique identifier assigned to each Yellow Dog Inventory system. Who is it for? The Client ID will be used by any user that will access a Yellow Dog mobile or web app. What is it used for? A Client ID is ...Feature Overview: Password Recovery
What is Password Recovery? Password Recovery is a built-in feature that allows Yellow Dog users to securely reset their login credentials independently by answering predefined security questions. This self-service option reduces the need for ...377 Food & Beverage Webinar
Curious about Yellow Dog Inventory version 377? New features, smarter workflows—watch the 377 Webinar now! Want to join the live webinar? We're hosting the 377 Food & Beverage Webinar weekly. Click HERE to sign up.Feature Overview: Retail Price Fields
Yellow Dog offers 3 different retail price fields (Default Retail, Current Retail, Starting Retail) in the item editor to provide different retail price tracking functions. Where: Item Editor > Retail Details tab Who: Retail users who manage retail ...Yellow Dog/Silverware Integration Overview
This document will provide an overview of the Yellow Dog Silverware Integration Integration Approach This can be setup as a 2Way – Push items and Pull sales or a 1Way – Pull sales Sales – Pulled from the Silverware API Codes – Pulled from the ...