Revised: 02/18/2015
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:
At the top of the view are functions such as save and delete. For more information on functions, click here.
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.
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.
Select an appropriate code from the drop down list. Product lines are maintained by the user in Inventory Product Lines.
Users may enter their own grouping code here for reporting purposes.
The type code field is another way for the user to classify the item for reports. Currently this field is limited to one character.
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.
From the drop down menu select one of the following:
Raw Materials
Final Product
Sub-Assembly
From the drop down menu select one of the following:
Active
Discontinued
Inactive
Enter a number to serve as an alternate barcode for the item. This field may be left blank.
Place a check mark in one or more of the following fields if the item is:
This field will be updated by the system as purchase orders are received.
View, enter or edit a base cost. This cost will not be updated by the system.
View, enter or edit the list price for the item and select one of the following:
Over Cost - if the pricing will be by markup
Under List - if the pricing will be by discount
Enter special price levels, i.e. sell pricing, contract pricing, etc when applicable.
This section displays the amount of inventory On Hand, Reserved, Available , BO and PO. These fields are updated by the system.
Enter or select the main vendor for purchasing the inventory item from.
View, enter or edit the primary vendor's part number for the item.
View, enter or edit the primary vendor's cost for the item.
Select the primary warehouse in which this item will be stocked.
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:
Barrels
Box
Case
Dozen
Each
Feet
Gallons
Hundred Per
Inches
Pair
Six Per
Thousand Per.
Users may update this list by accessing Global Table Maintenance, code INUNITS, found under Settings.
Select one of the following types from the drop down menu to indicate how the item is sold as:
Barrels
Box
Case
Dozen
Each
Feet
Gallons
Hundreds Per
Inches
Pair
Six Per
Thousand Per
Conversion Factors are now setup in the Vendor Item Master. Information entered in this field is no longer used.
Enter the size of the item.
Enter the weight of the item.
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.
Displays the average cost of the item.
This grid displays the layers for the average cost by transaction date, quantity ordered and cost.
Enter segment values in the appropriate segment field. If unsure of what to enter, please contact the Horizon Help Desk.
Enter segment values in the appropriate segment field. If unsure of what to enter, please contact the Horizon Help Desk.
Enter segment values in the appropriate segment field. If unsure of what to enter, please contact the Horizon Help Desk.
Enter segment values in the appropriate segment field. If unsure of what to enter, please contact the Horizon Help Desk.
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.
Enter or select the default warehouse the item will be stored in.
Enter the bin number where the item will be stored. If there is no bin location, leave this field blank.
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.
Enter a number to indicate when the item should be reordered.
Enter the number of days the item will take to receive it back into stock once it has been reordered.
Enter the amount that should be reordered.
Enter the maximum amount to keep on hand in inventory.
Enter or select the general ledger asset account number to interface the value of the inventory on hand.
Enter or select the general ledger revenue account number that the sale of this item is associated with.
Enter or select the general ledger expense account that the cost of goods of this item is associated with.
Enter or select the general ledger account that the internal use of this item is associated with.
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.
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).