Print Friendly

Items Available for Inventory (Purchased Items and Recipes) have the option of utilizing multiple Count U of Ms for the purpose of Stock Counts.  For example, the Purchased Item ‘Romaine Hearts’ could be counted three different ways: ‘Case – 12/3 CT’, ‘Bag – 3 CT’ and ‘Bag (Chopped) – 2 LB’.  These Units of Measure are set on the ‘Inventory Cost’ tab of the Purchased Item Record, and when assigned, will appear as additional ‘Qty’ boxes on Stock Counts.  In order to utilize Multiple Count U of Ms, follow the steps outlined below.  Click here for more information on Stock Counts in Restaurant365

Step 1: Update Purchased Item / Recipe Records

Each Purchased Item will have the Inventory Cost tab visible upon opening the record.  To update Inventory U of M, and Count U of Ms on Recipes, the ‘Available In Inventory’ box must be checked on the ‘General’ tab of the Recipe Record.

Update Manually

Navigate to the ‘Inventory Cost’ tab and update, as needed, the U of M values in the ‘Count U of M 2’ and (if necessary) ‘Count U of M 3’ fields.  If a new U of M is needed, follow the steps to creating a New U of M. Click to watch an animated GIF example of Updating Count U of M

 

Update via Import

Export the Data

Navigate to the ‘Items’ list under the ‘Inventory’ subsection of the ‘Operations Module’.  Upon loading the ‘Items’ list view, click the export button in the top right corner to export the full list of Items (Purchased Items / Recipes).  If you prefer to filter the data before exporting that is also acceptable.  Click here for more information on Exporting data, and Using Filters in Restaurant365

Prepare the Template

Once the data has been exported, open the CSV file and begin by removing unnecessary data.  When performing updates to records, it is recommended that only the data being updated (and the required data locator, typically the ‘Name’ value) be included on the update file.  For this update, the only columns that will be necessary are as follows:

The ‘Name’ column will be mapped with the ‘Current Name’ value when we perform the import via the Import Tool.  ‘InventoryUofM’ is retained so the User can view what the existing U of M is for the Purchased Item / Recipe and update the ‘Count U of M 2’ / ‘Count U of M 3’ accordingly.  ‘Type’ will allow the User to filter the Items by Type and create two separate update files (Purchased Items and Recipes are two different Records and must be updated separately)

As ‘Count U of M 2’ and ‘Count U of M 3’ are not present on the table, they will need to be added to the template.  Type the respective values in to columns D and E as shown below:

Populate the Template

The template is now ready to be populated.  Enter each respective Count U of M as needed / desired.  Note: U of Ms must exist in Restaurant365. If a new U of M is needed, follow these steps to creating a New U of M before attempting to import the updates.

Save the Template(s)

Upon completing all the updates, add a filter to the column headers and filter the ‘Type’ column to include only ‘Purchased’ (Note: if no Recipes exist in the data, save the file and proceed to the next step: Import).  A separate import file will need to be created for all ‘Purchased’ Types and ‘Recipe’ Types.  Type ‘Ctrl’ and ‘A’ on the keyboard to select everything in the sheet.  Then ‘Ctrl’ and ‘C’ to copy the data.  Now type ‘Ctrl’ and ‘N’ to open a new workbook (the current workbook will still remain open).  Use the mouse to click in to cell A1 in the new workbook and type ‘Ctrl’ and ‘P’.  This will paste the data copied from the other workbook in to the new workbook.  Save the file as a .CSV and repeat the process, changing the ‘Type’ filter to ‘Recipe’.  After each file has been saved, proceed to the next step

Import Template(s)

Navigate to the Import Tool and set the Options / Type as shown below (for Purchased Item update)

 

Click the ‘Next’ button to proceed to ‘Map Fields’.  On this page, set the ‘Current Name’ value to ‘Name’ from the template.  Ensure that the ‘Count U of M 2’ and ‘Count U of M 3’ were properly assigned by scrolling down to the bottom of the mapping fields.  When all fields have been mapped, click the ‘Next’ button and proceed to ‘Import’.  Click the ‘Import’ button to import the updates.  Repeat the process for the Recipe items (setting the Option to ‘Recipe Item’)

 

Step 2: Perform the Stock Count

Once all Inventory Items (Purchased Item and Recipes) have been updated to include the additional Count U of Ms, they can now be counted via the Stock Count.  Follow the regular process to create a new Stock Count via an existing Stock Count Template to begin.  Click here for more information on Performing a Stock Count.  Note: any existing Stock Counts (created before the Count U of Ms updates were made in Restaurant365) will not contain the updated Count U of Ms.  New Stock Counts going forward will contain the updated Count U of Ms

Multiple U of Ms via Browser

When entering a Stock Count via Browser, if any Inventory Items have additional Count U of Ms, those Count U of Ms will appear in the second (green highlight above) and third (orange highlight above) columns accordingly.  For Inventory Items that have only the required ‘Inventory U of M’ (red highlight above), the additional columns will be blank.

Enter the count quantities in their respective U of M column.  All quantities will be added together to give a total quantity (in terms of the ‘Inventory U of M’) based on the Inventory and Count U of Ms.  Upon completion, ensure to Save the Stock Count.

 

Multiple U of Ms via Mobile App

 

 

When entering a Stock Count via Mobile App, if any Inventory Items have additional Count U of Ms, those Count U of Ms will appear to the right of the Inventory U of M (red highlight above).  Count U of M 2 (green highlight above) appears to the right of the Inventory U of M and Count U of M 3 (orange highlight above) appears to the right of Count U of M 2 accordingly.  For Inventory Items that have only the required ‘Inventory U of M’ (red highlight above), no additional columns will be present.

Enter the count quantities in their respective U of M column.  All quantities will be added together to give a total quantity (in terms of the ‘Inventory U of M’) based on the Inventory and Count U of Ms.  Upon completion, ensure to Save the Stock Count.

Was this article helpful to you?

Comments are closed.