Reporting Explained: Order Guide

Reporting Explained: Order Guide

Business Need:  This report is helpful for users who want a report to show items on hands, available vendors, and pricing for a particular store.  This report is especially useful when looking to compare pricing across vendors. 

How it Works:  An Order Guide report shows a summary of on hand and vendor information for items available to be added to purchasing documents. 

Generating the Report:



Go to the Standard Reports section in Yellow Dog:

  1. Select Standard Reports
  2. Open the folder titled ‘F&B’
  3. Select the folder ‘On Hand’
  4. Select the report ‘Order Guide’
  5. Generate report


Reading the Report:


  1. Shows the filters used to produce the report’s data, including the date selected for the report.
  2. 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.
  3. Store Name: Shows the store that the item and on hand is assigned to for this vendor.
  4. Vendor Code:  Shows the code number that is set for this vendor in Yellow Dog.
  5. Vendor:  Shows the vendor set for the item, if multiple vendors are assigned to the item, this will be the primary or first vendor listed for the item.
  6. Vendor SKU:  Shows the vendor SKU assigned to the item for the vendor assigned to this item.
  7. Level:  Shows the level that this item is assigned to.
  8. Item Description: Shows the name of the item.
  9. Size: Shows the size set for the item.
  10. Vendor Price:  Shows the vendor price set for the item, if multiple vendors are assigned to the item, this will be the primary or first vendor listed for the item.
  11. On Hand:  Shows the on hand for the item from this particular vendor.
  12. Alt Vendor 1:  Shows an additional vendor for this item, if an additional vendor is set.
  13. Alt Vendor SKU 1:  Shows the vendor SKU set for the additional vendor, if an additional vendor is set. 
  14. Alt Vendor Price:  Shows the vendor price set for the additional vendor, if an additional vendor is set.
  15. Other Vendor SKU 1:  Shows the vendor SKU for a child items set for this item.
  16. Other Size 1:  Shows the size for a child item set for this item.
  17. Other Vendor Price 1:  Shows the vendor price, if one is set, for the child item.
  18. Other On Hand 1:  Shows the on hand for the child item if one is set for this item.
  19. This row allows you to save, export, print, or close the current report.

    • 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: F&B :Food Cost: Actual By Item

      Business Need: This report is helpful for users who want a report to show the cost of goods for items sold between two dates. How it Works: A F&B>Food Cost>Actual By Item report shows the actual usage cost for items sold between two dates based on a ...

    • Reporting Explained: Cost Reporting- COGS Detail

      Business Need: This report is helpful for F&B customers using COGS for tracking inventory. It allows clients to see a detailed breakdown of their COGS accounts in relation to sales, purchasing, physical inventories, and manual adjustments. How it ...

    • Reporting Explained: Cost Reporting- Inventory Items with No COGS Account

      Business Need: This report is helpful for F&B customers using COGS for tracking inventory. It allows clients to see which inventory items are not mapped to a COGS account. This is useful for troubleshooting variances in COGS cost reporting 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 ...

    • 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 ...

    • How do I use Par & Re-Order Points?

      What is a Reorder Point? The minimum quantity you would like inventory of the item to be before ordering more. Items must go below this level to trigger reorder. Items set to 0 will not reorder until you go into negative stock. This is not ...

    • 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 ...

    • Food and Beverage Core Features User Manual

      The Food & Beverage Core Functions User Manual is your key to understanding the potential of Yellow Dog. Whether you're a first-time user or a seasoned pro, this detailed manual will help you understand how to best utilize your Yellow Dog Inventory ...