Revised:  02/18/2015

Inventory Item Master

Go to Maintain>>Inventory Item Master.

This program is used to enter and maintain Inventory Items for use and tracking in several modules.

See Also:

Function Menu

At the top of the view are functions such as save and delete.  For more information on functions, click here.

Quick Link ...

Header

Item Number

Enter or select an existing Item number to view or edit.  For a new item enter a unique alphanumeric code.

The first two digits of the item number can include the product line code.

For Example:

AP is setup as an Appliance product line code.  Any item that is an appliance or an appliance replacement part may include AP in its number.

AP-0001  Range

AP-0002  Range Hood

AP-0003  6" Drip pan for electric range  

See Comments....

If comments have been entered for the item, See Comments... will be shown below the item number field to inform users that comments are entered for the selected item.

Description 1 & 2

When an existing item is selected the associated descriptions will be displayed.  The descriptions may be edited at any time.

When entering a new item, enter an appropriate description in these fields.

Main

Parameters

Product Line

Select an appropriate code from the drop down list.  Product lines are maintained by the user in Inventory Product Lines.

Group Code

Users may enter their own grouping code here for reporting purposes.

Type Code

The type code field is another way for the user to classify the item for reports.  Currently this field is limited to one character.

ABC Code

The ABC field is used to classify items into groups to rank them according to total sales, total cost, or total margin.  This is known as ABC Analysis and can be used to assist in producing an ABC Analysis Report.  Valid entries are A, B or C.

Structure Code

From the drop down menu select one of the following:

Item Status

From the drop down menu select one of the following:

Alt Barcode

Enter a number to serve as an alternate barcode for the item.  This field may be left blank.

Check Boxes

Place a check mark in one or more of the following fields if the item is:

Cost Information

Last Cost

This field will be updated by the system as purchase orders are received.  

Base Cost

View, enter or edit a base cost.  This cost will not be updated by the system.

Pricing

List Price

View, enter or edit the list price for the item and select one of the following:

Level 1 through 4

Enter special price levels, i.e. sell pricing, contract pricing, etc when applicable.

Availability

This section displays the amount of inventory On Hand, Reserved, Available , BO and PO.  These fields are updated by the system.

Purchasing

Vendor Information

Primary Vendor

Enter or select the main vendor for purchasing the inventory item from.

Part Number

View, enter or edit the primary vendor's part number for the item.

Vendor Cost

View, enter or edit the primary vendor's cost for the item.

Stocking

Main Warehouse

Select the primary warehouse in which this item will be stocked.

Stocking Unit

Select one of the types from the drop down menu to indicate how the item is to be purchased/stocked/counted.  The list is as follows:

Users may update this list by accessing Global Table Maintenance, code INUNITS, found under Settings.

Pricing Unit

Select one of the following types from the drop down menu to indicate how the item is sold as:

Conversion Factor

Conversion Factors are now setup in the Vendor Item Master.  Information entered in this field is no longer used.

Size

Enter the size of the item.

Weight

Enter the weight of the item.

PO History Grid

Displays purchase order numbers, remaining amounts and cost of the item in stock.  If any are on order, the grid will display the purchase order number, cost and amount expected.

Costing Layer Information

Average Cost

Displays the average cost of the item.

Layers

This grid displays the layers for the average cost by transaction date, quantity ordered and cost.

Account Building

Inventory Account Building

Segment 1 through 9

Enter segment values in the appropriate segment field.  If unsure of what to enter, please contact the Horizon Help Desk.

Revenue Account Building

Segment 1 through 9

Enter segment values in the appropriate segment field.  If unsure of what to enter, please contact the Horizon Help Desk.

COG Account Building

Segment 1 through 9

Enter segment values in the appropriate segment field.  If unsure of what to enter, please contact the Horizon Help Desk.

Int Use Exp Account Building

Segment 1 through 9

Enter segment values in the appropriate segment field.  If unsure of what to enter, please contact the Horizon Help Desk.

Comments

This is a notepad area to write any detailed information regarding the item.  When text is entered here and saved a text message of "See Comments..." will appear below the item number field in the header area.

Warehouse

Warehouse

Enter or select the default warehouse the item will be stored in.

Bin Location

Enter the bin number where the item will be stored.  If there is no bin location, leave this field blank.

Balance Information

On Hand, Reserved, Available

The system will calculate and track the balance on hand, reserved for jobs and available for use for the item.  These fields are for informational display and are updated by the system.

Reorder Information

Reorder Point

Enter a number to indicate when the item should be reordered.

Lead Days

Enter the number of days the item will take to receive it back into stock once it has been reordered.

Reorder Quantity

Enter the amount that should be reordered.

Maximum Quantity

Enter the maximum amount to keep on hand in inventory.

General Ledger Interface

Inventory Account

Enter or select the general ledger asset account number to interface the value of the inventory on hand.

Revenue Account

Enter or select the general ledger revenue account number that the sale of this item is associated with.

COG Account

Enter or select the general ledger expense account that the cost of goods of this item is associated with.

Internal Use

Enter or select the general ledger account that the internal use of this item is associated with.

Shopping Setup

Associations

Select item numbers to associate.

For Example:

Some Items are actually a combination of pieces that are put together to make a bigger piece.  The Associations entered here would contain the item numbers of those parts needed to make this item.

Main Web Image

Enter the network path to where the image of the item is stored.  This field may be left blank if it is not applicable (If images of items are not saved or viewed on a network).