Item Categories

Prev Next

This article covers the Smart Ops Item Category Form. 

Up to three separate Item Categories can be assigned to each Purchased Item record and are used in various reports to create subtotals or filters. Additionally, Item Categories can be assigned to Recipes that have been marked as 'Available in Inventory'.

Item Categories are organized in the following way:

  • Item Category 1 - Broad

    • Example: Food (Cost Account = Food Cost; Inventory Account = Food Inventory)

  • Item Category 2 - More specific

    • Example: Dairy (Cost Account = Dairy Cost; Inventory Account = Blank)

  • Item Category 3 - Very specific

    • Example: Cheese (Cost Account = Cheese Cost; Inventory Account = Cheese Inventory)

These then fall into a hierarchy when entering them on an Item record. Therefore, if all three Item Categories are entered on an Item record, the Cost account will be used accordingly: Item Category 3 will override Category 2, and Category 2 will override Category 1.

This hierarchy will follow in this order when the most specific account has both the Cost Account and Inventory Account entered.

Item Categories are different than Menu Item Categories and should be created and structured differently as well. Click here for more information on Menu Item Categories.


Item Category Form

Field

Description

1

Name

Name of the item category.

Item Category 1 should be broad, item category 2 should be more specific, and item category 3 should be very specific.

2

Cost Account

The COGS cost of goods sold) account that will be assigned to this item category.

During item creation, when an item is assigned to this item category, this account will auto-populate into the proper GL Account field.

This field is required for Item Category 1.

If an item is part of an item category 2 or 3 that each do not have a linked cost account, the item will assume the cost account of the item category 1.

3

Waste Account

The GL Account that will be debited upon entering an item from this category on a waste log.

4

Acceptable Variance %

The set positive variance cap allowed for this category. This also works in conjunction with the Variance Cap Type (#5).

If no variance cap is desired, ensure, leave this field blank. If a 0 is entered, the system will recognize it as a 0% acceptable variance cap. Learn more about item category variance caps.

5

Inventory Variance

The acceptable Variance threshold for inventory discrepancies.

When the variance of a counted item exceeds this threshold, users will receive a theoretical review notice on the 'Variance Review' tab of inventory counts. Read more about inventory count variances.

6

Item Prefix

A prefix assigned to the item category that helps to search and sort Items. Ex.: PROD for Produce. This prefix will be auto-filled to the name of newly created items assigned to the category. New items will take only one assigned item category prefix.

The item categories will be considered in the following order: Item Category 3 → Item Category 2 → Item Category 1

R365 recommends using ALL CAPS for item prefixes to easily distinguish item prefixes from item names.

Item Prefix Examples:

Item Category Prefix

Item

Item Name

PROD

Apple

PROD Apple

MEAT

Chicken Breast

MEAT Chicken Breast

BEER

ABC Beer

BEER ABC Beer

7

Inventory Account

The inventory account that accounts for this item category.

During item creation, when an item is assigned to this item category, this account will auto-populate into the proper GL Account field.

This field is required for Item Category 1.

If an item is part of an item category 2 or 3 that each do not have a linked cost account, the item will assume the cost account of the item category 1.

8

Donation Account

The GL Account that will be debited upon entering an item from this category on a donation log.

9

Actual as Theoretical

Determines whether to use the actual usage for this item category in place of the theoretical usage (via recipes mapped to menu items) on the Actual vs Theoretical (AvT) Report.

10

Counted

Default selection is yes. When set to yes, users will receive a New Items warning when New Items/Recipes are detected in inventory counts.

When set to no, this item category will not be available on inventory templates and inventory counts. New Items warnings not be prompted.

New Items Detected

When new items are detected, a New Items Available notice will appear when creating a new inventory count.

  1. To continue, click Update to update the inventory count template.

  2. Manage the new items detected. Dismiss new Items by clicking dismiss/remove button beside the Item name. Click Add to add the new Item to an inventory count storage location.


  3. After clicking Add,  select which storage location(s) to add the item to.
     

  4. Click Add to apply the storage location(s).

  5. Click Apply to continue.

  6. The inventory count template will be updated.

11

Exclude From Order Suggestions

When marked 'Yes,' all the items in the item category will be excluded from the Suggest QTY calculation when creating a purchase order. The Order QTY for these Items will need to be entered manually.

12

Save

Saves the item category.

The Save dropdown has the Save & Create Another option. When clicked, this will save the current item category and promptly open a new item category form for more efficient item category creation.

Item Category Examples and Naming Recommendations 

Item Category 1

These typically represent broad level categories.

  • Food

  • Liquor

  • Beer

  • Wine

  • Supplies

  • Retail

Item Category 2

Typically, these represent the more detailed categories within each Category 1. Category 2s usually line up with P&L Accounts in the food categories (but not always).

  • Food:

    • Meat

    • Seafood

    • Dairy

    • Produce

    • Dry Goods

  • Liquor:

    • Vodka

    • Tequila

    • Gin

    • Rum

  • Beer:

    • Bottle Beer

    • Draft Beer and

  • Wine:

    • Red

    • White

    • Sparkling

  • Supplies:

    • Paper

Item Category 3

These are used less often but can come in handy if an organization has a large selections of an item category 2, such as an extensive Wine or Beer list (or a lot of different Meats).

  • Bottle Beer:

    • IPA

    • Stout

    • Amber

    • Ale

  • Wine:

    • Merlot

    • Cabernet

    • Chardonnay

  • Meat:

    • Beef

    • Pork

    • Poultry

    • Deli

R365 Recommends

For item categories, users should enter item prefixes in all caps, like LBW (liquor, beer wine), BEER, BEER BTL, MEAT, POULTRY, WINGS. This will make item category prefixes easily distinguishable from the item name.


Create Item Categories

Item categories can be created using the following methods:

From the Item Category Page

Navigate to the Item Category list page, and click the +Create button

Select the Item Category (1, 2, or 3). This will open the New Item Category form.

Via the Import Tool

Open the import tool.

In the Options field, select, 'Item Category.’  In the Type field, select ‘Create New.’

Download the template by clicking Download Template and proceed to complete the template in a preferred spreadsheet application

 

The Type column on the template should be filled with the Item Category Number Type: 1, 2, or 3.


View and Edit Existing Item Categories

To view and edit an existing item category, navigate to the item categories grid. Locate the item category. Click the item category name to open the item category form.

Edit the item category fields as needed. Any edits will enable the Save button. Click Save to save any changes before closing the form.


Popular Reports that Utilize Item Categories