Restaurant Inventory Items

The Restaurant Inventory Items screen allows you to define inventory unit, purchase unit, location, par level, vendor information, and bar code information for master inventory items used by a specific restaurant.

Note: To add or create items, use the Master Inventory Items screen or the Inventory Item Wizard. The Restaurant Inventory Items screen should only be used to add restaurant-specific information. While you can delete items from this screen, it only removes the restaurant-specific information from the master item. Master items can be removed only on the master screen.

The "Add Items to Restaurant Inventory" security setting (under Setup > Security > Groups > Screen Access tab > Restaurant Inventory Items list) determines whether each user can select master inventory items to add to the restaurant inventory items. If this security option is not selected for the group to which a user belongs, that user will not be able to select items from the Master Inventory to add to the restaurant inventory. Also, access to each individual tab of this screen can be turned on or off for the group.

To find a particular item, use the search functionality in the main toolbar. You can alternatively view either all of the items in inventory or only the items for a your restaurant by toggling between Show All Items and Show This Entity's Items Only at the top of the screen.

Visit the Compeat Support Website for additional information on this topic and more.

Master Information

Click to view/hide picture.

The screen header— the top portion of the screen— provides basic information about the selected item, read from the Master Inventory Items record, and cannot be modified in the Restaurant Inventory Items screen. To change the master information values, go to the Master Inventory Items screen.

Restaurant Information Tab

Click to view/hide picture.

Restaurant Info Fields

Many items are not sold directly, but are ingredients in menu items and prep items. For example, bottles of wine are often sold directly, but butter typically is not; butter is usually an ingredient in a menu or prep item. For items that are ingredients, when a menu item containing it is sold, or a prep item is created, the theoretical quantity on-hand is decreased by:

(number sold x amount of the ingredient in the recipe) / recipe unit to inventory unit conversion factor.

For example, assume there are 2 ounces of butter in the menu item grilled tuna, there are 10 grilled tunas sold in a day, and that butter is inventoried by the pound. The theoretical quantity on-hand decreases by (10 x 2) / 16 (16 ounces per pound) = 1.25 pounds.

Note: When an inventory count is posted, Compeat will update the theoretical quantity on-hand with the posted count. However, if the inventory count post date is not the current date, Compeat will automatically make adjustments for any sales or receipts of the item that have occurred since the post date. For example, if you enter a count of 10 for ABC item on July 1, then on July 2 sell 3 units of ABC item, when the count is posted on July 3, the theoretical quantity on-hand will be updated to 7 (10 from the count – 3 sold), not 10.

The theoretical quantity on-hand is also decreased for items that are portioned; the whole item’s quantity is decreased, while the portioned items’ quantities are increased.

Checkboxes

Note: Permission to change this check box can be granted or denied using the "Allow Changing Active/Inactive Item Status" checkbox in the Restaurant Inventory Items section under Setup > Security menu > Groups screen > Screen Access tab.

Note: Preferred vendor (Par Levels/Vendor Info) is overridden by lowest price for bid items when using Suggest Orders by Par Levels and Suggest Orders by Shopping List.

Detail Area

Note: If the item is a Catch Weight item as defined on the Master Inventory Items screen, you need to define a container identical to the inventory unit (container = 1 inv unit), in addition to the normal "container = x inventory units" purchase unit definition. This allows you to receive the inventory unit; and this second purchase unit definition— which has a ratio of 1 that Compeat seeks when receiving Catch Weight items— will appear on AP Invoices and Manual Check screens.

Example
You might order cheese by the wheel, even though it is priced by the pound. Each wheel has a different weight, so how can you receive it by the pound? After checking the "Catch Weight" box in the Master Inventory Items screen, define Wheel=5 Lb and Pound=1 Lb here on separate lines (assuming the inventory unit is Lb) to effectively make a container conversion factor. When you order cheese, you can place your order for 2 wheels of cheese. When the order is received, Compeat will automatically convert it to a quantity of 10, of the purchase unit definition Pound=1 Lb, on the AP Invoices or Manual Checks screen. If no "container = 1 inv unit" definition for the catch weight item is found, Compeat will prompt you to create one. You can then change the quantity to, say, 11.25 pounds, if that is the actual weight of the two wheels, and thus account for it properly.

Locations Tab

Click to view/hide picture.

Each restaurant can define an unlimited number of locations within the restaurant for each inventory item. Locations are helpful in streamlining the process of performing an inventory count when it comes time to count your inventory.

Note: An item can be at multiple positions in the same location. For example, if Scotch is at positions 15, 45, and 81 in your bar, you would add a location of BAR with position 15, another location of BAR with position 45, and a third location of BAR with position 81. Now, when you go to count your bar, Scotch will appear three times at the specified locations. When you post your counts, Compeat will automatically add all the quantities together for you.

Note: You can also set positions or bins in the Inventory Positions screen. This screen allows you to view location and positions of all items together.  To assign bins in the Inventory Positions screen, right click on an item and click ‘Assign Bin’.

Par Levels/Vendor Info Tab

Click to view/hide picture.

Par Levels

Compeat can suggest orders based on par level. A suggested order will include all of the items with any defined par values— even a stock or reorder level of zero— for the specified par level.

However, only those items whose reorder level is greater than the theoretical quantity on-hand will have a quantity included on the suggested order. You can edit any of the quantities on the suggested order. Then, when a suggested order is saved, only the items with a quantity will be included— items with a zero quantity will be removed at this point.

Note: If you are defining par levels for all of your inventory items, you might find it easiest to use the Par Maintenance feature instead of opening each Restaurant Inventory Item and entering the par levels here.

Depending on your business needs, you may not use all seven of the available par levels. The descriptions of the par levels are customizable for each restaurant from the Setup menu > Other Definitions screen > Other tab.

If you add a vendor record here, new orders for this vendor will pre-fill with this item (when "Prefill New Orders" is checked in the Vendors setup screen).

Vendor Options

Vendor Info

You do not have to explicitly add the vendor information for each item; Compeat will automatically update this as vouchers including the inventory item are entered or as new vendor prices are added through Vendor Price Maintenance. However, if you have yet to process any vouchers, and want Orders to be pre-filled with vendor information, you can enter it here.

For example, assume you typically buy and inventory cooking oil by 5 gallon cans. 5 gallons is both your inventory unit and your purchase unit; the conversion unit is 1. If one day, your vendor can only provide 1 gallon cans, when you enter the voucher, you will need to add a new purchase unit (1 gallon) and a new conversion factor (0.20).

Note: This field will update automatically when you import an order guide with a new price for this item or update through Vendor Price Maintenance.

Note: Checking more than one item (with the same item code) will result in ambiguity between the two.

Bar Codes Tab

Click to view/hide picture.

Enter bar codes if you plan to use an electronic bar code scanner for inventory. If not, this information is unnecessary.

Most products are available from a number of different suppliers (e.g., milk can come from many suppliers, so you may have multiple bar codes). The Bar Code Tab allows you to enter as many bar codes as are needed to count inventory.

If there is only one supplier for an item (e.g., Stoli Vodka is only produced by one company), you can enter a Universal Product Code in the UPC field of the Master Inventory Items screen.

Notes

Optionally enter any notes associated with the item.

Portioning Tab

Click to view/hide picture.

This tab allows you to set schedules and stations for portioned items that are used in Prep-to-Shelf calculations. Entering portioning information for an item will enable you to include portioned items in the Prep-to-Shelf Worksheet when "Include Portioned Items" is checked on that screen.

Commissary Tab (commissary entities only)

Click to view/hide picture.

Check the "This item is available to be ordered" checkbox if you want the item to appear on the list of items that can be ordered from the commissary. Restaurants and customers can only order items from your commissary if they are marked as available to be ordered either here or on the Commissary Items screen.

Note: An item must have a purchase unit defined under the commissary entity before it can be selected as available to order.

Choose either Never Tax, Always Tax, or Depends on Customer as the sales Tax Status of this item. If the third category (Depends) is chosen, the item will only be taxed for customers who have a sales tax defined on their A/R Customers screen.

Cost Adjustments

Commissaries can establish a selling price or mark-up the cost of any restaurant inventory item differently depending on whether it is an Inside Order or an Outside Order. For either kind of order— you cannot do both— entering a fixed Selling Price overrides any markup data you may enter.

Outside orders use the Base Price assigned to the item. Outside Orders can use any defined Price Level, depending on the Price Level definition assigned to the particular A/R Customer.

Selling Price
Specify a fixed Selling Price as a dollar amount (in the first box) per inventory unit (selected in the second box). Items will post to the accounts specified on Levels screens.

Markup
You can mark up the item cost by a dollar value, by a percentage of shipping unit cost, or both. On the first line, specify any dollar amount (in the first box) per inventory unit (selected in the second box) you wish to mark up the item.

Outside Order Offsets

If defined, these offsets will be subtracted from the sales amounts when the Outside Orders are posted and credited to the GL accounts specified. For example, if an item has a selling price of $10 and an offset defined to a freight account for $1, the item will be sold to the customer for a total of $10. When the order is posted, $9 will go to the sales account and $1 will go to the freight account. You can define multiple offsets per price level for each item.