Why are My Purchase Items Not Appearing in Physical Inventory Counts?

Why are My Purchase Items Not Appearing in Physical Inventory Counts?
by John Laporte, President, RRFMG Technology Services

One of the most common operational issues encountered in Restaurant365 (R365) is when purchase items expected to be counted during inventory do not appear in the physical inventory worksheet. This issue frequently occurs when opening a new location, adding vendors, or creating new items.

Because inventory counts drive food cost calculations, variance analysis, and cost of goods sold (COGS), missing items can lead to inaccurate reporting and operational confusion at the restaurant level.

The Issue

The Issue

Symptoms

Operators, inventory specialists, or accounting teams may notice one or more of the following:

  • A purchase item exists in the item master, but does not appear in the inventory count sheet.
  • The item can be ordered and received, but cannot be counted during inventory.
  • The item appears for some locations but not others.
  • A new restaurant location has been created, but inventory items are missing from the inventory template.
  • Inventory templates cannot add items to storage locations for the new site.

Why This Happens

In Restaurant365, an item will only appear in an inventory count if several configuration requirements are met:

  1. The item is marked as Inventory = True.
  2. The item is assigned to an Inventory Category.
  3. The item is associated with the location where inventory is counted.
  4. The item is tied to a storage location within the inventory template.

However, an additional configuration issue can occur when new locations are created incorrectly in the system.

Why This Happens

Additional Root Cause: Location Type Set Incorrectly

Additional Root Cause: Location Type Set Incorrectly

When setting up a new location, the accounting team may accidentally configure the location as an Accounting Entity instead of a Restaurant within the location record.

When this happens:

  • The system does not allow inventory items to populate into inventory templates.
  • Storage location item dropdown lists will appear empty.
  • Inventory templates cannot properly function.

This configuration prevents the location from behaving as an operational restaurant in the system.

Comprehensive Resolution

Follow the steps below to systematically resolve the issue.

Step 1: Confirm the Location Type

Navigate to:

Administration → Locations

Open the affected location record and review the Location Type field.

If the location is configured as:

  • Accounting Entity

Change it to:

  • Restaurant

Save the record.

Important System Behavior

After changing the location type to Restaurant, the system requires approximately 24 hours for inventory items to fully populate throughout the system.

During this time:

  • Inventory item dropdown selectors will gradually populate.
  • Storage location item lists will refresh.

This delay occurs because the system rebuilds the location-level item relationships in the background.

Step 2: Verify Inventory Item Configuration

Once the location type has been corrected, confirm the item configuration.

Navigate to:

Inventory → Items → Purchase Items

Open the item and verify:

  • Inventory Item = Checked
  • Inventory Category Assigned
  • Location is assigned to the item

Save any corrections.

Step 3: Verify Storage Location Assignment

Navigate to:

Inventory → Storage Locations

Typical storage locations include:

  • Walk-In Cooler
  • Freezer
  • Dry Storage
  • Bar
  • Prep Line

Once the 24-hour refresh period has passed:

  • Open the storage location
  • Add items from the item dropdown selector
  • Save changes

The items should now be selectable.

Step 4: Update Inventory Cost for the New Location

After the item population occurs, a new issue often appears:

All inventory items will display a cost of $0.00 for the new location.

This happens because item costs in Restaurant365 are location specific, and the new location has not yet processed purchasing history.

To correct this:

  1. Navigate to Inventory → Purchase Items
  2. Open each inventory item
  3. Go to the Location Cost field
  4. Enter the appropriate starting cost for the location
  5. Save the record

This establishes the baseline inventory valuation for the first count.

Step 5: Allow Invoice Processing to Update Costs Automatically

Once vendor invoices begin processing for the new location:

  • The system will automatically update the item’s Last Price
  • Inventory valuation will begin using actual purchase costs
  • Manual cost maintenance becomes unnecessary

Over time, invoice automation and purchasing activity will keep costs accurate.

Step 6: Validate Using a Test Inventory Count

After completing the configuration:

  1. Create a new inventory count
  2. Select the location
  3. Confirm:
  • Items appear in the correct categories
  • Storage locations are populated
  • Costs are populated

If all items appear correctly, the issue is resolved.

Comprehensive Resolution

Preventing the Issue in Future Location Openings

Preventing the Issue in Future Location Openings

Organizations using Restaurant365 should implement a new location setup checklist to avoid this issue.

Location Setup Checklist

  1. Create location record
  2. Set Location Type = Restaurant
  3. Assign storage locations
  4. Confirm inventory categories
  5. Populate inventory templates
  6. Enter baseline item costs
  7. Run test inventory count

Operational Impact

Correcting this issue ensures:

  • Inventory counts populate correctly
  • New restaurant openings can conduct accurate inventories
  • Food cost reporting remains accurate
  • COGS calculations begin correctly from day one

For restaurant organizations running inventory and purchasing operations through Restaurant365, correct location configuration and item cost initialization are critical to maintaining accurate financial reporting and operational efficiency across all locations.