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: Purchase Orders
The Purchase Orders Report provides information on all purchase orders created within a selected time period. It includes quantities, costs, document status, and commit details. Use this report to: Track purchasing activity over time Monitor purchase ...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: Inventory Requests
Use this report to: Track request activity over time Monitor request status and completion Review quantities and costs Standard Reports > Purchasing > Inventory Requests The report pulls all inventory requests based on your selected filters. It ...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: Inventory Adjustments
Use this report to review all manual adjustments made to inventory over a selected period. It helps you: Track waste, damage, and spoilage Monitor production and non-standard inventory activity Validate that all adjustments are recorded before ...
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 ...