Troubleshooting: Inactive Items in Recipes Affecting COGS in Physical Inventory Reporting

Troubleshooting: Inactive Items in Recipes Affecting COGS in Physical Inventory Reporting

End user · F&B  ·  Yellow Dog Inventory 2026

 ISSUE

Cost of Goods Sold (COGS) values are incorrect in physical inventory reporting. This affects Food & Beverage users who build recipes mapped to point-of-sale (POS) menu items for Actual vs. Theoretical (AvT) reporting.

 CAUSE

A recipe contains one or more inactive items. Inactive items are not included in physical inventories, so the revenue attached to those items is excluded from COGS reporting.

 TROUBLESHOOTING

Identify affected recipes

1.   Go to the Home module and open Watchdog (top left).

2.   Run the Watchdog report.

3.   Set Object Type to Recipe, Category to Inactive Item, and Action to Remove.

4.   Review the results. Each row identifies a recipe that contains an item which has been removed or made inactive.

Resolve each affected recipe

1.   Open the recipe flagged in the Watchdog report.

2.   Remove the inactive item from the recipe.

3.   If the item was switched for a different ingredient, replace it with the active item.

Note: Always check the Watchdog report before running physical inventories and resolve any flagged issues first. Running a physical with inactive items still mapped in recipes will reintroduce the COGS discrepancy.

 VERIFICATION STEPS

After resolving each recipe:

1.   Re-run the Watchdog report with the same filters (Recipe / Inactive Item / Remove).

2.   Confirm no recipes remain in the results before starting your physical inventory.

 WHEN TO CONTACT SUPPORT

Contact Yellow Dog Support if recipes continue to appear in the Watchdog report after you have removed or replaced the inactive items, or if COGS reporting remains incorrect after a clean physical inventory.

Phone: 757-663-7514

Email: support@yellowdogsoftware.com

Support hours: Monday–Friday, 9:00 a.m.–8:00 p.m. EST

Emergency support (available 24/7): 757-663-7514, Option 1

Last reviewed: June 2026  ·  Applies to: Yellow Dog Inventory 2026


    • Related Articles

    • Troubleshooting: COGS Numbers

      COGS reporting in Yellow Dog appears inaccurate Possible Causes: COGS Account Mapping COGS accounts are not mapped in the POS Item Map. Items do not have COGS accounts assigned. Purchasing Invoices were not entered in Yellow Dog. Physical Inventories ...

    • Reporting Explained: Cost Reporting- Inventory Detailed Usage by COGS Account

      The Usage Cost report shows the cost of inventory usage during a selected period. It includes detailed costs related to: Manual adjustments Invoices (received items) Returns to vendors Issued and accepted transfers Use this report to understand how ...

    • Reporting Explained: Inventory Items with No COGS Account

      Use this report to identify inventory items that are not mapped to a COGS account. This helps you: Prevent inaccurate COGS reporting Identify missing mappings Troubleshoot cost variances Note: COGS accounts are store-specific, so mapping must be ...

    • Reporting Explained: Food Cost by COGS Department/Category

      The Food Cost by COGS Department report shows food cost summarized by COGS department. Use this report to compare inventory costs with sales revenue and monitor food cost performance by department. Reports > Standard Reports > F&B > Food Cost > COGS ...

    • Reporting Explained: Cost Reporting- COGS Detail

      The COGS Reporting report helps food and beverage (F&B) customers track inventory costs. It provides a detailed breakdown of Cost of Goods Sold (COGS) accounts and shows how costs relate to: Sales Purchases Physical inventories Manual adjustments Use ...

    • 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 (Base Unit) Size

      End user · Yellow Dog Inventory 2026 WHY IT'S IMPORTANT The on-hand (parent) size is the base unit—the unit Yellow Dog Inventory uses to track on-hand quantity and to convert every purchasing and counting size. When an item with multiple sizes is set ...

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