Keystroke Point of Sale Help


Database Manager - Inventory Database - Main Screen

Video Screenshot

Fields displayed on the Inventory - Main Screen:

Product Code - The item bar code characters, part, or product number (SKU, UPC, etc).

Manufacturer - Manufacturer Name or Manufacturer Number.

Description - Text description of the item (or service).

Extended Desc - Continuation of Description or alternate item description.

Stock Number - Used internally to identify each record and cannot be changed.

Class - Usage similar to Product Code.

AltID# - Usage similar to Product Code, but accepts only numbers.

Average Cost - Represents the average amount paid.

Last Cost - Represents the amount most recently paid.

Base Price - The default retail selling price.

List Price - The Manufacturer's recommended retail price.

Price Levels 1,2,3 - Alternate prices available for sales and price tables.

Qty Price Breaks - Define fixed quantity price breaks (3 for $1.00, 5 for $3.00, etc).

Closeout Item - Used by filters for exporting, reporting and printing labels.

On Sale - Used to identify items which should default to Sale Price rather than Base Price.

Sale Price - Default retail selling price when On Sale is enabled.

Web Item - Used to identify items also sold on-line.

Web Price - Default on-line selling price when Web Item is enabled.

On Hand - The quantity currently available for sale.

Allocated - The quantity currently on Back Order.

Layaway - The quantity currently on Layaway transactions.

On Order - The quantity currently on order from Vendors.

Expected - The date the item is expected to be received, as specified on a purchase order.

Sale Unit - The unit of measure by which the item is sold (Each, Pound, Gallon, etc).

Sale Qty - The default quantity entered on Sales Transactions.

Bulk - Identifies item as Bulk for exporting and reporting.

Service - Identifies intangible items such as shipping and labor.

Rental - Identifies item that is rented, rather than sold.

Serialized - Identifies item that requires Serial Number tracking.

Department - Identifies the Department assigned to the item.

Category - Identifies the Category assigned to the item.

Location - Identifies the Location assigned to the item.

Matrix Table - Defines item Matrix Table (size/color/style matrix).

Price Code - Defines how item is affected by Price Table Formulas for discounts.

Tax Code - Defines how item is affected by Tax Table Formulas for required sales tax.

Pay Code - Defines how item is eligible for certain Sales Payment Type tendering.

Commission Code - Defines how item is affected by Commission Table Formulas.

Loyalty Code - Defines how item is affected by Loyalty Rules and Loyalty Buckets.

Last Count - The date the item was last counted on a posted Variance.

Last Sold - The date the item was last sold.

Total Purch - The total quantity received on Purchase Invoices.

Total Sold - The total quantity sold on Sales Invoices.

Comment - Press [Shift]+[Enter] to view the Comment field.

Inventory Screen Buttons

Vendor List - Press [Alt]+[v] to display/edit item Vendor Information.

Serial #s - Press [Alt]+[s] to display/edit item Serial Numbers.

AltCodes - Press [Alt]+[a] to display/edit item Alternate Codes.

Scripts - Press [Alt]+[c] to display the Scripted Item Screen.

Matrix - Press [Alt]+[m] to display the item Matrix Table.

Order Data - Press [Alt]+[r] to display the Order Data Screen.

More Data - Press [Alt]+[d] to display the More Data Screen.

Custom Data - Press [Alt]+[u] to display the Custom Data Screen.

See:

Cost of Goods Sold

Profit Margin and Percent Profit Margin

Quantity Fields

Selling Prices

Keystroke Help Table Of Contents