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:

1. 1. • 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.

1. Stocking tab

2. Pricing tab

3. Codes tab

4. History tab

5. Notes tab

6. Vendor tab

7. 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 Backorder

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.