Inventory Maintenance Field Help
This topic provides definitions for the fields in the Inventory Maintenance
window. This topic is organized by the tabs found in the window. To find
a definition, click one of the following tabs. This will take you to an
alphabetical list of the fields for that tab. Click the appropriate field
from the alphabetical list. When you are finished viewing a particular
definition, click the Back button at the top of this window to return
to the list. Note that the Load tab is not listed below; the reason is
that all the fields on the Load tab come from the other tabs; these fields
are merely assembled together on the Load tab to make loading new items
easier.
To move
from tab to tab in Inventory Maintenance without using a mouse, do one
of the following:
- Press <Cntl><PgUp> or <Cntl><PgDwn>
to move up or down one tab at a time.
- Press <Cntl> plus the number of
the tab you want to go to. For example, to go to tab 5 (Notes),
press <Cntl>5.
Stocking tab
Pricing tab
Codes tab
History tab
Notes tab
Vendor tab
Misc tab
Stocking Tab
Alternate
Ref
Buyout
Number and Units
Catalog
Date
Class
Committed
Qty
Consumer
Brand Name
Consumer
Description
Consumer
Quantity Factor
Cust
Backorder
Date
Added
Dept
Desc
Fineline
Fixed
Ord Qty
Future
Order
In
Stores
Last
Phys Inv
Last
Receipt
Last
Sale
Location
Lost
Sale #/Units
Max
Stock Level
Mfg
#
Mfg
Vend
Min
# of Std Pkgs
Min
Order Point
New
Order Qty
Order
Indicator
Order
Multiple
Order
Point
PO
Season
Pricing
U/M
Prime
Vend
Purch
Conv Factor
Purch
Decimal Pl
Purchasing
U/M
Qty
On Hand
Qty
On Order
Raincheck
Qty
Safety
Stock
Secondary
Vend
Sequence
SKU
Standard
Pack
Status
Stocking
U/M
Store
Type
UPC
Vend
Stk #
Weight
Top
Pricing Tab
Avg
Cost
Avg
GP%
Catalog
Retail
Class
Conversion
Decimal
Pl
Dept
Desc
Desired
GP%
Fineline
GP
(Repl)
In
Stores
List
Lumber
Type
Mfg
#
Mfg
Chg
Mfg
Cost
Mfg
Vend
Mkt
Cost
Price
1
Price
2
Price
3
Price
4
Price
5
*Pricing
Prime
Vend
Product
Code
Promotion
Qty
On Hand
Repl
Chg
Repl
Cost
Retail
Retail
(Old)
Retail
Chg
*Selling
Sequence
SKU
Store
Type
Units
UPC
Top
Codes Tab
#
of Bin Labels
Amt
of Purch Hist
Bill
of Materials
Catalog
Pg #
Class
Count
Promo Sales
Decimal
quantity allowed
Dept
Desc
Discontinued
Discountable
Expanded
A
Expanded
B
Expanded
C
Expanded
D
Ext
Sales History
ExtDesc
Group
Fineline
Fixed
Price Indicator
Gift
Card SKU
Has
Alt Part #
In
Stores
Keep
Prices
Keep
Promo History
Keep
Sales History
Keep
Stock Info
Kit
Record
Label
Format/Printer
Lifo
Pool Code
Loading
Required
Lowest
Sell Price
Max
Units per Transaction
Mfg
#
Mfg
Vend
Multiple
Selling Unit Code
Popularity
Code
POS
No Charge Item
POS
Returnable
POS
Sellable
Price
Rounding
Prime
Vend
Print
Labels
Product
Code
Promo
Sales Code
Qty
Break Code
ROP
Protect
Seas
Sales Code
Seas/Promo
Sequence
SKU
Fee
Type
Special
Record
Store
Store
Closeout
Tally
Tax
Code
Tax
Exempt Category
Tax
Status
Type
UPC
Update
Dept Data
User
Codes
Vendor
Backorder
Web?
Top
History Tab
Avg
Sales $/Mo
Class
Dept
Desc
Fineline
GMROI
In
Stores
Last
Per
Last
Year Avg Cost $
Last
Year Other Purchases
Last
Year Prime Vend
Last
Year Promo Units
Last
Year Replace Cost $
Last
Year Sales $
Last
Year Sales Units
Mfg
#
Mfg
Vend
Month/Yr
Fields
On-hand
Value
Popularity
Prime
Vend
Sequence
SKU
Store
To
Date
Turns
Type
UPC
Year
to Date Avg Cost
Year
to Date Gross Prof $
Year
to Date Gross Prof %
Year
to Date Kit Sales $
Year
to Date Kit Sales Unit
Year
to Date Other Purch
Year
to Date Prime Vend
Year
to Date Promo Cost $
Year
to Date Promo Sales $
Year
to Date Promo Units
Year
to Date Repl Cost
Year
to Date Sales $
Year
to Date Sales Units
Year
to Date Transactions
Top
Notes
Class
Dept
Desc
Display
Repeats
Fineline
In
Stores
Mfg
#
Mfg
Vend
Name
Note
Group
Prime
Vend
Print
Repeats
Sequence
SKU
Store
Type
(lower screen)
Type
(upper screen)
Top
Vendor Tab
Class
<Click
to Add>
Dept
Desc
Fineline
In
Stores
Last
Cost Change
Last
PO Number
Last
Purchase Cost
Last
Purchase Date
Last
Purchase Qty
Mfg
#
Mfg
Vend
Min
# of Order Multiples
Prime
Vend
Sequence
SKU
Store
Type
Unit
to Order By
UPC
Vendor
Code
Vendor
Cost
Vendor
Name
Vendor
Order Multiple
Vendor
Part #
Misc Tab
The fields listed in bold font
have a default value you can set up in Fineline Maintenance (MFI), Class
Maintenance (MCL), and Department (MDE) so that whenever you add a new
item in that fineline, class, or department, the system uses the default
value.
Item
Dimensions(Informational
only fields) – Height, Width, and Depth are all in inches. Item
Weight from the Stocking tab is repeated here for completeness. With Cubes,
you can toggle between cubes in feet or cubes in meters.
WIC
Code For future use.
WIC stands for Women, Infants, Children. This is a store-specific field
for grocery merchants.
EBT/FS
Item?(Master data) - for
Grocery or Pharmacy stores that honor Electronic Benefits Transfer (EBT)
for food stamps. This field identifies an item as an EBT food item. You
may use this field instead of assigning a use code per options 1073/1074.
The system still supports both methods of identification – either
using this new field or the use code peroptions 1073/1074.
.
Blank (initial default is blank) = “Not a EBT/FS item”
Y = “Yes, EBT/FS item”
FSA/HBC
Item? (Master data)
- for Grocery and/or Pharmacy stores that honor consumer Health Benefit
Cards/Flexible Spending Account (FSA). This field identifies an item as
a Health Benefits item (H), or a pharmacy item (R). You may use
this field instead of assigning a use code per option 9135. The
system supports both methods of identification - either using this new
field or the use code in option 9135.
Blank (initial default is blank) = “Not a FSA/HBC item”
H = Health Care item
R =Rx prescription item
Restricted
Hours code(Store
specific) – assign the Restricted Hours Selling Code that defines the
days and/or hours an item cannot be sold at POS. For example, some counties
or towns may not allow liquor to be sold on Sundays any time, or Sundays
prior to 5PM. This field’s label is a hyperlink which brings up the Restricted
Hours Selling Codes Maintenance.
Age/Selling
Restricted(Master
data) Use this Minimum Age or Selling Restricted field to indicate this
item is 1 = Type 1 restricted, or 2 = Type 2 restricted. You may
use this field instead of assigning a use code per options 9413/9414 and
9417/9418. The system supports both methods of identification –using
either this new field or the use code per the options listed above.
Weighable?(Store specific) – for Grocery stores, use this
field to identify the item as a weighable item which is weighed at POS
using an integrated scale. Use this field instead of assigning a use code
per options 122/123. The system supports both methods of identification
– either using this new field or the use code per options 122/123.