Revel POS: Creating Inventoried Units

This Article reviews how to create Inventoried Units/Products and the Product Fields used for PA Beer Distributors.  We have noted the Field Labels with a description and how they are used.

Reminder: Use the window on the left to set only the fields you want to display on the right.  Use Set as Default so you do not have to set each time.

Basic Product Details

Product name*:

• Required field (noted by the *)
• Format
  • Brand
  • Ounce
  • Package
  • Type of Units
• Used for:
  • POS Buttons
  • Reports
  • Sales Receipt
  • Management Console

Product Class:

• Primarily used for Reporting.

Barcode:

• Automatically Assigned by the Revel Management Console
• Printed on Product or Shelf Labels
• MUST BE UNIQUE.  No other Product in the database can have the same Barcode

SKU:

• Optional Field
• MUST BE UNIQUE.  No other Product in the database can have the same SKU
• Can be Alpha-Numeric
• Good use is a Vendor ID, for example, 123456-DUR

Cost:

• Initial Cost for this Product
• Must be updated manually - Will NOT be updated by Receivings
• Revel will use Cost if not using Dynamic Cost

Dynamic Cost:

• If "Use Inventory Cost" is set in Settings, Dynamic Cost will be derived from Inventory
• Cannot be changed manually

Price*:

• Required field (noted by the *)
• Price Customers will pay

Eligible for Discount:

• If check mark in the box, this Product is eligible to be discounted or used in the Discount rules

Product Groups:

• Primary use is in Discount Rules
• Can include Product in multiple Product Groups

 Custom Menus:

• Custom Menus are used to filter which Products are visibly available for sale.  Used for: 
  • POS (Buttons)
  • Online Ordering
  • Kiosk (Buttons)
  • Digital Menu Boards
• Can include Product in multiple Custom Menus

 Active:

• Only Active Products will appear on the POS and in Reporting
• Check Mark: Product is Active in the database and is available all thought the POS and Management Console
• No Check Mark: Product is NOT Active and is not available except in the Product List

 Alternate Lookup (ALU):

• Additional ways to identify Product
  • UPCs
  • Barcodes
  • SKUs
  • PLUs, NLUs,
• Does NOT need to be unique
• Used for items that have the same UPC.  When scanning a UPC on the POS that is in the ALU for Multiple Products, a box will appear to choose one of the Products
• Have not yet discovered a limit on the number of Alternate Lookups per Product
• To remove an Alternate Lookup, click the "-" to the right of the box

Basic Product Details / Tax Options

 Taxes:

• Prevailing Tax is the default Tax and is reflected in Active Taxes
• Tax Groups
  • Used in place of the Prevailing Tax
  • Common Use - No Tax or Non Taxable, different Tax other than Prevailing Tax

Display / Print Options

Main Category*:

• Required field (noted by the *)
• Each Product MUST be assigned to at least one Category / Subcategory
• Select 1 Category / Subcategory
• This is where the Product will appear on:
  
  • POS Screen
  • Management Console / Products / Products

Additional Categories:

• Product can be assigned to multiple Category / Subcategory's
• Select more than 1 Category / Subcategory
• This is where the Product will appear on:
  
  • POS Screen
  • Management Console / Products / Products

Image:

• Image assigned to Product
• .jpg and .png most common formats
• Will appear on:
  • POS Button
  • Kiosk Terminal
  • Customer Display (Optional)

Color Code:

• Select the color of the POS Button for this Product

Inventory

UOM or Unit of Measurement:

TIP: Although you could enter a value for each Product, it is only used for Products that are tracked in Inventory.

• Default Unit for Inventory tracking
• Case values would be 12 PACK, 15 PACK, 18 PACK, 24 PACK, 30 PACK, 36 PACK, etc

Track in Inventory:

• Is this Product tracked in Inventory
  • YES: Check Mark
    • Case and Keg Products
    • Will appear in
      
      • Inventory Tab
      • Inventory Reports
      • POs
    • TIP: Stock Units may need created if there are additional Selling units 

Bin Value:

• KEY PA1014 Field
• Value is in the format Ounces per Unit "-" Units per Case, i.e., 12-24 or 12-30
• After a value is created the first time, it will appear in a drop-down list

Threshold:

• Minimum Quantity to keep on Hand
• Viewed on Inventory Screens
• Viewed on Reorder Screen

Primary Vendor:

• Company you purchase Product from
• Viewed on Inventory Screens
• Used on Reorder Screen
• Used on Purchase Order

Vendor Item ID:

• Your Vendors Item Number
• Viewed on Inventory Screens
• Used on Purchase Order

Reorder Unit Type:

• Value will equal UOM
• Will be reflected as "Default UOM (Inventory Unit)"

Default Reorder Quantity:

• Maximum Quantity on hand
• Used on Purchase Order
  • If "Reorder to Par" for this Product is
    • NO (No Check Mark): value entered here will be the default in Reorder
    • YES (Check Mark): value entered here will be used in the Reorder to Par calculation, to NOT exceed this value for Quantity on Hand.

Default Reorder Price:

• Current Cost

Reorder to Par:

• Used on Reorder and Purchase Order affecting the Quantity to Order
• YES (Check Mark)
  • System calculates the Quantity to Order by subtracting the current Quantity on Hand from this value.
• NO (No Check Mark)
  • System uses the value as the Quantity to Order

Stock Units:

• Defined only for Case Products that are sold in multiple units, i.e. 2/12PK and 12PK, or 4/6PK and 6PK
• Used for Physical Inventory purposes
• Used only if additional selling units will be counted separately from the Case unit during a Physical Inventory
• Can have multiple Stock Units
• Conversion Units = 4PK, 6PK, 8PK, 12PK, etc
• Conversion = Number of Stock Units (above) in the Inventory Unit, i.e., 12PK is .5 of 2/12PK
• Barcode = UPC (if different than Inventory Unit) of this Unit
• Unit = Select the Inventory Unit from the Drop Down
• Active
  • YES (Check Mark) Stock Unit is Active
  • NO (No Check Mark) Stock Unit is NOT Active
• Primary
  • YES (Check Mark)
    • Stock Unit will be default Primary Unit
    • Unit will be reflected in Default Reorder Unit in place of Inventory Unit
  • NO (No Check Mark) Not Primary Unit

---