Please enable JavaScript to run this help system!
Execu/Tech Systems, Inc.
Knowledgebase
Search:
850-747-0581
Email
Website
Contents
Index
Search
Page Properties
Page Keywords
Page Visibility
Preview For Mobile Device
Lightbox Code & Preview
Save
Cancel
Saving...
Welcome
What's New
System Requirements
Computer Hardware
Other Hardware
Operating Systems
TLS 1.2 Requirements
Data Security
Firewall Settings
Credit Card Interfaces
Software Installation
Installation Checklists
Software Installation - Server
Software Installation - Client
Software Reinstall / Move
Create Shortcut Manually
Software Launcher
Software Updates
Software Update Requirements
Software Updates
Running ETUpdate from update.zip
Software Update without download
Post-Update Requirements
Questions and Answers
Common Questions
Common Mistakes
Sending a Screen Shot
Recording step by step
Glossary
Data Flow
Execu/Tech Services
Execu/Suite Hotel PMS
Setup - Execu/Suite PMS
Preparation/Installation
Getting Started
Data Preparation
Your Company Setup
Zip Code Database
License Access Code
HTML Templates
Manager Menu / Setup
Hotel Control Files Setup
Parameter Record
Season Record
Rooms
Room Types
Tax Codes
Charge Codes
Payment Codes
Guest Packages Setup
Market Segment Codes
Source of Business Codes
Corporate File
Guest Profile Tools
Housekeeping Codes
Yield Management
Meeting Room Parameters
User Defined Comments
Graphical Room View
Auto-Trace Setup
Wholesalers and Travel Agencies
Setup Bullet Points & Notes
Rooms, Room Types, Rates
Charge, Payment, Tax Codes
Guest Packages
User IDs, Passwords, & Security Levels
Parameters & Policies
Guest Profile Tabs and Fields
Market and Source Codes
System Maintenance
User I.D. / Security Setup
PMS Employee Setup
PMS Menu Permissions
Security Levels
Other Settings
Configuration Settings
Editing HTML Letters, Documents and Forms
Email Settings
Thank-you emails
Enable PDF Saving
Hotel Logo
Import Rate Spreadsheets
Master Folios
MENUINI.FIL Configuration
Terminal ID Number Codes-Batch Terminals
Hotel Print Settings
ETHTMLPrint (Print Folios, Reg Card, etc.)
Procedures Execu/Suite PMS
Manager
Manager Procedures
Adjusting Statistics-AM Report
Other Manager Tasks
Manager Reports
Reservations
Reservations Operations
Availability
New Reservations
Guest Profile Entry & Reports
Advance Deposits
Share-withs
Changing Reservations
Cancellations and No-Shows
Reservation Reports & Printouts
Sample Reports
Trace Reports
Front Desk
Front Desk Operations
Availability
Check In
Check In Master Folio
Assign Master Folio to Guest or Group
Guest Folio
Guest Profile
Credit Card Procedures
Guest Packages
Changes - Room, etc.
Posting Charges & Payments
Check Out
Guest History
Housekeeping
Front Desk Reports & Printouts
Night Audit
Night Audit FAQ
Night Audit Procedures
Night Audit Reports
Night Audit Bullet Points
Night Audit Report Viewer
Travel Agency Processing
Travel Agency Setup
Travel Agency Reports
Travel Agency Checks
Clearing Adv. Deposits Remaining
Folio Detail Export
Groups
Guest Name Changes-Profile
Guest Opt-out
Report Generator
How-To Videos and Tutorials
Change Terminal Number
Check In a Guest
Check Out a Guest
ETShortcutWizard
Export Guest Contact Info
Guest Profile Creation
Housekeeping Screen - Changing Status
Interface - Create a Scheduled Task
Posting Charge or Payment to Folio
Transfer Charge or Payment to a Folio
Voiding Charge or Payment in Folio
How-To Documents
Post CC After Check-out
Credit Card Reminders
Change Company Code
Reports - Execu/Suite Hotel PMS
Execu/Suite CRS
Initial Setup
Menu and Navigation
Rooms Setup
Inventory & Availability
Viewing Inventory & Availability
Default Inventory
House Inventory
Periods of Closure
Events and Groups
Room Type Variations/Adjustments
Stop Sale Limits
Availability by Rate Category
Availability by Channel
Allotments
Booking Rules & Closure Date Rules
Calendar quick changes
Minimum Stay Policies
Automated Revenue Rules
Occupancy Rules
Channel / IDS Rules
Products/Rates Setup
Payments - Cancellations
Groups
Setup
Booking
Lookup
Channel Manager
Corporate Client Setup
Services Setup
Force CRS to PMS Sync
Marina and RV Settings
Interfaces
OTA / HTNG
OTA / HTNG Installation and Configuration
OTA / HTNG 2 Way Push
OTA / HTNG 1 & 2 Way Pull
OTA / HTNG Functions and Limitations
OTA / HTNG PMS Settings
OTA / HTNG ROH (Run Of House)
OTA / HTNG Troubleshooting
OTA / HTNG Logs
Phone, Movie, POS, etc.
Comtrol® Interfaces
Comtrol® Network Requirements
Comtrol® Install
Comtrol® Setup
Comtrol® Testing
Comtrol® Resync
Comtrol® Troubleshooting
Legacy Interfaces
Legacy Interface Installation
Communication Settings
Phone Interface Resync
Troubleshooting Serial Connections
Micros POS Interface
Execu/Touch Point Of Sale
POS to Hotel Data Flow
Execu/Touch POS Administrator
Store Record
Departments/ Revenue Centers
Payment Records
Discount Records
Menu Items
Item Modifiers
Item Categories
Combinations (Value Meals)
Employee Records
Employee Work Codes
Void Codes
Table Setup
Terminal Records
Printer Setup
Item Button (Keyboard) Setup
Supervisor Menu
How To - POS Admin
Create POS Item
Execu/Touch POS Procedures
F&B Open a Check
Close a Check with CC
Separate Checks
Split Checks
Split Tendering
Retail Procedures
Reports
Supervisor
Paid-Out Tips and Other
Create TAB
Transfer Checks
Video-Credit Cards in POS
Execu/Touch POS Miscellaneous
POS Cash Management
Dining Reservations
Tableside Wireless Tablets
Edit/ Purge History Records
Add Comment to POS Guest Receipt
Suppress Remote Printing
Use Employee Login Cards
Encode Employee Login Cards
POS Activities Deposits - Setup
POS Activities Deposits - Procedures
Export POS Check Detail (GAPOCKH.TXT)
FUEL sales in POS
POS Copy / Delete Records (GAPOCOPY)
POS Copy all records to another store
POS Copy records from GAPOCNTL.OLD
POS Delete Records
POS Change item fixed tax amount
POS Reset Table Types
POS Resynch employee/password records
POS Copy ONE record to another store
POS Convert gapo999.fin's
POS Printers and Cash Drawers
POS Printer Setup
POS Printer Troubleshooting
Cash Drawer Setup
Configure Bar Code Printer and Labels
Print Bar Codes
Credit Card Processing
Shift4 Credit Card Processing
Shift4 Card Readers (Non-EMV)
Magtek Programming
Shift4 Data Flow
Shift4 Installation
Shift4 UTG Install
Shift4 EMV Setup
Shift4 AuthToken, AccessToken, AccessBlock
Shift4 PMS/POS Setup (MENUS4CO)
Shift4 PMS/POS Setup (Payment Codes)
Shift4 PMS/POS Setup (Other Settings)
Shift4 i4Go V2
Using Shift4 i4Go
Shift4 i4Go V2 Requirements
Shift4 i4Go V2 Errors
Shift4 i4Go V2 PMS / POS Settings
Shift4 i4Go V2 Internet Explorer Trusted Zone
Shift4 Receipt Printer Setup
Shift4 Troubleshooting
Shift4 UTG IP Address and Port
Shift4 Error Codes
Test Shift4 UTG Connection with Telnet
Shift4 Fix (June 19, 2020)
Worldpay Credit Card Processing
Worldpay Critical Setup Info
Worldpay EMV PIN Pad Setup
Worldpay EMV Cloud Config
Worldpay EMV Failure Messages
Worldpay EMV PIN Pad Troubleshooting
Worldpay EMV Data Flow
Worldpay Non-EMV Data Flow
Worldpay Receipt Printer Setup
Credit Card Service Fees / Surcharges
Credit Card Procedures
EMV Credit Card Processing
Switching Gateways/Providers
Inventory Control
Inventory Overview
Inventory Setup
Store, Locations, Classes-Categories
Inventory Items
Recipe File
Inventory Processing
Physical Inventory Entry
Physical Inventory Handheld Scanner
Purchase Orders
Miscellaneous Postings
Enter Waste Adjustments
Batch Updating
Display Item Detail
Inventory Integration
Integration to POS
Integration to A/P
Integration to GL
Inventory Reports
Time & Attendance
Direct Bill / City Ledger
Direct Bill Introduction
Direct Bill Setup
Control Files Setup
Customer Setup
Direct Bill - Execu/Suite PMS Interface
Direct Bill - Execu/Touch POS Interface
Direct Bill - General Ledger Interface
Membership Billing
Direct Bill Procedures
Hotel DB Transfers
Transaction Batches
Open Item Payments
Manual Postings
Fix Out of Balance Direct Bill Accounts
Late Fees
Member Billing
DB Reports and Statements
Transaction Batch Update Report
Customer Aged Trial Balance
Customer Detail Report
Open Item Statements
Balance Forward Statements
A/R Report Generator
Sample Reports
Events and Catering
Getting Started
Event Setup
Sample Reports
Gift Cards (Execu/Gift)
Execu/Gift Setup and Configuration
Selling/Issuing Gift Cards
Redeeming Gift Cards
Manual Entry / Edit / Delete
Donated Gift Cards
Reward cards
Encode Gift Cards
Back Office
General Ledger
GL Setup
GL Processing
GL Integration
GL Reports
Accounts Payable
A/P Setup
A/P Processing
A/P Reports
Condo
Condo Overview
Condo Setup
Condo Procedures
Condo Reports
Payroll
Payroll Setup
PR - GL Interface Setup
Company
Federal Tax Tables
Employee Setup
PR-TimeClock Interface Setup
Payroll Procedures
Payroll Reports
3rd Party Accounting Interfaces
GL Export
DataPlus
QuickBooks
Errors / Fixes
cbl.out Program Missing
Class Not Registered
Cobol Errors
Common System Issues
Company Selection Keeps Appearing
Detail File Update Error
Error: 80040154
File Error: 3000
Find Software Application Folder
Folio Stops Printing (HTMLPRNT.EXE)
Forms Print to Wrong Printer
Forms Print Too Large
LoadEntity invoke failed
Memory Access Violation
Microsoft .NET Framework
Microsoft.Office.Interop
Missing or Broken Shortcut / Icon
Network Benchmark
Rebuild Corrupted File
Rebuild Cross Reference
Register Programs and Controls
Restarting Servers and Terminals
Run Program By Name
Run-time error '429'
Run-time error '-2147319779'
Program Warnings
Cannot Run More Than Once
Could Not Read Card
Current time not set up
In Reorg - Not Posted
Invalid Company Code
Invalid Room Type
Keyboard Record Not Set Up
Record Busy Message
Software License Warning
Terminal Record Not Set Up
Shift4 Errors
Slow / Stuck Software
Start Program Missing
Support File Uploader
Unable to Select Printers
User Account Control (UAC)
What's My Terminal Number?
Execu/Vault
Remote Connection (RemoteET)
Uninstall Old Remote Connection App
Sample Reports
Year-End Procedures
Fiscal Year
Master Folios Year-End
Seasons and Rates
Year-End Advance Deposits
Server and System Health
PCI Compliance
City Ledger - Direct Bill
General Ledger
Accounts Payable
Payroll
Backup and Storage
Training
New Modules
Cloud Hosting
Cloud Hosting Access
Cloud Launcher Install
Cloud Launcher Setup
Cloud Launcher Update
Cloud Access for Mac
Cloud Hosting Preparation
Hosting Network/Hardware Requirements
Important Issues and Settings
Document Access
WebRes
WebRes - Installation
WebRes - Credit Card Processing
WebRes - Shift4
WebRes - Worldpay
WebRes - Customize / Configure
WebRes - Cancellation Policy
WebRes - Confirmation Page and Email
WebRes - Errors / Troubleshooting
Theresa's Test Page 1
Search
:
Index
Bookmark
Print This Article
Login
Edit Page
Publish Draft
Delete Draft
Compare Draft
Edit Header
Home
>
Inventory Control
>
Inventory Setup
>
Inventory Items
After completing the Control File setup you can start entering individual inventory items
. You need to understand the proper setup of inventory items in order to manage your inventory efficiently and correctly. Each of the fields in the setup screen is discussed here.
See
Control Files: Inventory Store, Locations, Classes-Categories.
There three primary types of inventory:
Basic Items
such as gift shop items or housekeeping supplies
Bulk Items
such as those used in recipes like ground beef for hamburgers or components like nails that are issued and not sold
Liquids
such as liquor that may be used with or without recipes
Basic Item Setup
"Item Code:"
is a required field and cannot be changed once set up. The code may be up to 15 characters but no more than 4 if POS direct update. POS direct update is used when POS items are created from POS items. You can type the code or you can scan the code. If you use a scanner, do so when you are in this field. To add a barcode to an existing item, place your cursor in the "Vendor item code" field (Field 2) and scan the code or type it if it is alphanumeric.
1. "Item description:"
up to 30 characters. It should be easy to find when searching for an item by description. For example, you might want to start like items with the same word such as BOOK or BEEF. That way you won't end up with CHIPS LAYS and LAYS CHIPS, which would not be consecutive in a lookup.
2. "Vendor item code:"
Enter the code that your vendor uses for this item. It is informational only. You may leave this blank. To add a barcode to an existing item, place your cursor in this field and scan the code or type it if it is alphanumeric.
3. "Purchase unit of measure:"
Enter the unit of measure used when purchasing this item. For example, CASE, LB, EA. These are not predefined. Use what makes sense to you.
4. "Unit cost/ purch unit:"
Enter the cost (not the sale price) for each purchase unit. If you purchase by the case, enter the cost for a case.
5. "Stock unit of measure:"
Enter the unit of measure used when stocking this item. It may or may not be the same as the purchase unit of measure. For example, CASE, EA.
6. "Purchase/ stock quantity:"
Enter the purchase-to-stock quantity ratio. For example, if you purchase a case (Field 3, purchase unit of measure) and you stock individual items and there are 12 items in a case, then you would put 12 in this field.
7. "Issue unit of measure:"
Enter the unit of measure used to issue this item, whether you issue the item through a POS sale or you issue it manually through Miscellaneous Postings. For example, EA, ML, LB. This will be explained more thoroughly in the following sections,
Bulk Items
and
Liquids
.
8. "Stock/ issue quantity:"
Enter the stock-to-issue quantity ratio. For example, if you stock by the case and issue by the each and there are 12 items in a case, you would enter 12. If you stock by the each and issue by the each, then you would put 1 in this field. This will be explained more thoroughly in the following sections,
Bulk Items
and
Liquids
.
9. "Vendor code:"
Enter the vendor code (up to 5 characters) for the vendor from whom you purchase this item. See also
Inventory Overview
for parameters.
10. "Sale price/ unit:"
If this is a retail item that is sold through Execu/Touch POS, enter the sale price for that item as it should be priced in POS. If you are using this price as a
recipe
component or if this is not a saleable item leave this field blank.
11. "Item department:"
- Enter the 1-character code for the Item's revenue department. This may be the same as the class/category or it may be different. For example, you might have an item department C for clothing but classes/categories TSH for T-shirts and JAC for Jackets. This can match the POS Revenue Department for this item if you want to keep things simple. See
Inventory store setup
. See
POS revenue department setup
.
12. "Item class/ category:"
Enter the code (1-4 characters) for the item's class/category. It may or may not be the same as POS category although you will enter the POS category code for this inventory category in the Class/Category setup.
See Item Class/Category setup
.
13. "Size:"
Enter a size for this item. You may leave this field blank.
14. "Color:"
Enter a color for this item. You may leave this field blank.
15. "Minimum qty on hand:"
Enter the minimum quantity to keep on hand. You may leave this field blank.
16. "Maximum qty on hand:"
Enter the maximum quantity to keep on hand. You may leave this field blank.
17. "Taxable? (Y/N) POS only:"
Enter Y or N for the four fields that apply to the four POS taxes. For example, YYNN. The default can be set for this. See
Inventory Overview
. See also
POS Store Record
for POS tax setup. For non saleable items you may leave this field blank.
18. "Alternate cost:"
Optionally enter an alternate cost for this item. You may leave this field blank.
19-21 "Location/ bin:"
Fields 19 through 21 are required but you may leave the "bin" blank. Even if you have only one location for this item, you must fill in the location for Field 19, Field 20, and Field 21. See
Locations
setup
22-31 "Extra location:"
You may enter additional locations for this item. These fields are not required.
Press Enter or Click Yes to save this item. You will receive one or more prompts:
Note:
Below is a POS revenue department. See Item #11 above, "Item Department". See
Store Record
for relevance.
Bulk Items
Liquids
Back to top
Bulk Items
Below is a recipe for a POS item (HAMBURGER) using the inventory item shown above (BEEF-GROUND).
Basic Item Setup
Liquids
Back to top
Liquids
Below is a liquor sale. The first image is the inventory detail and the second image is the POS master folio.
Basic Item Setup
Bulk Items
Back to top
Control Files: Inventory Store, Locations, Classes-Categories.
Related Files
none..
Related Pages
none..
Article ID
inventory_items
Views
3809
Last Modified
1/3/2017 11:43 AM
Copyright © Execu/Tech Systems, Inc. All Rights Reserved.
{1}
##LOC[OK]##
{1}
##LOC[OK]##
##LOC[Cancel]##
{1}
##LOC[OK]##
##LOC[Cancel]##