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 |