Reporting Explained: Order Guide
Deprecated Documentation This article applies only to legacy versions 372 and prior.
Use this report to review on-hand quantities, vendor options, and pricing for items in a specific store.
This helps you:
- Compare pricing across vendors
- Make informed purchasing decisions
- Identify preferred and alternate vendors
Standard Report > F&B > On Hand > Order guide
This report lists items available for purchasing, along with:
- Current on-hand quantities
- Primary vendor details
- Alternate vendor options (if configured)
- Associated pricing and SKUs
The report reflects item and vendor setup in Item Management and supports purchasing workflows.
| Column | Description |
|---|---|
| Store Name | Store associated with the item and on-hand quantity |
| Vendor Code | Vendor identifier in Yellow Dog |
| Vendor | Primary vendor assigned to the item |
| Vendor SKU | Vendor-specific item number |
| Level | Item level (department/category structure) |
| Item Description | Item name |
| Size | Item size |
| Vendor Price | Price from the primary vendor |
| On Hand | Current quantity available in the store |
| Alt Vendor 1 | Secondary vendor (if configured) |
| Alt Vendor SKU 1 | SKU for the alternate vendor |
| Alt Vendor Price 1 | Price from the alternate vendor |
| Other Vendor SKU 1 | SKU for related or child item |
| Other Size 1 | Size of related or child item |
| Other Vendor Price 1 | Price for related or child item |
| Other On Hand 1 | On-hand quantity for related or child item |
Related Articles
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: 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: Summary By Period
The Inventory Summary by Period report provides an overview of inventory activity for a selected date and time range. It shows the starting inventory cost, all inventory movements during the period, and the ending inventory cost. Reports > Standard ...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: 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: ...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 ...