Step-by-Step Instructions

INV-1 (input or Correction of an Inventory Item)


1. (Inventory Number) Input the inventory item #. If the item exists in the system and you don't know the number, input ?? to access the search methods.
2. (One Word Description) Input the word that best describes the item. You may enter more than one word, separating each one-word description by a space. One-word descriptions are used to search for the inventory item from field one (1).
3. (Narrative) Input the full name or description of the inventory item.
4. (Catalog Description) Input the catalog description of the item, if applicable. This field is used to input a more informative description of the item.
5. (Inventory Type) Input the inventory type code, or input ?? to search for the code. If the code does not exist, input the new code at this field. This code is helpful for inventory and sales reporting. If an At sign (@) is input, this item is treated differently. Items with "@" in their type code will not be decremented or incremented, that is, the system or location quantity on hand will not be effected.
6. (Commission Type) Input the commission type code, if applicable. Or input ?? to search for the code.
7. (Columnar Price Code) Input the columnar price code, if applicable, or input ?? for a list of codes. Codes that begin with "C" are calculated, and codes that begin with "M" are manual. For more information, see IC-6 in the Inventory Codes Directory (accessed from Miscellaneous Directory).
8. (Purchasing Chart of Account Number) Input the cost of sales chart of account number for the item. Input ?? to search for the number, and select #4 for the Cost of Sales list of COA'S. Then select the correct chart of account number. If a new COA needs to be created, advise the accounting department to do so.
9. (Unit of Measure) Input the unit of measure code used to sell the item. To search for the code input ??. If the code does not exist, input a new code at this field. To input the unit of measure used to buy the item, input /MORE and input an alternate unit of measure in field 9 and the unit amount in field 10.
10. (Standard Cost) Input the standard cost, which is the price your company expects to pay for the item. If there is no standard cost, input zero (0).
11. (Formula) Input the selling price formula code, or input ?? to search for the code. The formula code is normally the standard cost times a percentage for each selling price (listed in fields 12-15).
12. (Retail) Input the retail selling price or first selling price of the item. If a formula was input in field 1 1, the system will display the price.
13. (Second Price) Input the second selling price for the item. If a formula was input in field 11, the system will display the price.
14. (Third Price or Special Price 1) Input the third selling price or the first special selling price for the item. If a formula was input in field 1 1, the system will display the price.
15. (Special Price) Input the special selling price for the item. If a formula was input in field 1 1, the system will display the price.
16. (Gross Weight Per Unit) Input the weight per unit (product and package weight), if applicable. If weight does not apply, press the Return key to leave the field blank. If a freight burden (field 19) applies to this inventory item, then this weight will be used to calculate the freight burden.
17.

(Net Weight Per Unit) Input the weight per unit for the product, if applicable. If weight does not apply, press the Return key to leave the field blank.

18. (Volume Per Unit) Input the volume per unit, if applicable. If volume does not apply, press the Return key to leave the field blank.
19. (Freight Burden Add-on) The freight burden add-on amount will be displayed if an amount was input in the manufacturer code (field 23) and there is gross weight per unit (field 16). This is helpful in determining selling prices. For more information, input ? for the Help Directory.
20. (Street/Transfer Price) Input the price that the item sells for on the street. (This can be the lowest selling price for the item.) This price is used by the sales department to inform them when they are selling below street price.
21. (Price Each) Input the price each, if applicable. For example: The unit of measure is box (BX) with a package quantity of 5. The purchase cost is $50 a box, therefore the price each is $10.
22. (Location) Input the location number that the item is located in. If the item is located in all locations, input A for all. Input ?? to access a list of your company location codes.
23. (Manufacturer Code) Input the manufacturer's code, if applicable. Input ?? to search for the code. If the code does not exist, input /EC to access the mfr. code screen, and input the new code. Press the Escape key ([) to go back to INV-1. Freight burden factor codes are assigned to manufacturer codes, and this code field is used to implement the freight burden. The freight burden amount will be calculated and displayed in field 19.
24. (Manufacturer's Part Number) Input the manufacturer's part number, if applicable. If there is not a Mfg #, press the Return key to leave the field blank.
25. (Generic Number) If a generic number is input, the system will relieve inventory for the item and increase the generic item inventory when requisitions are created. The generic number must exist in INV-1 as an inventory item for this process to work.
26. (Production Package) Input the production package code, if applicable, or input ?? to search for the code. If the code does not exist, input a code identifier, and the system will ask if you wish to input a new code. Input Y (Yes), and input the code information. Press the Escape key ([) to go back to INV-1. For more information, input ? for the Help Directory.
27. (Brand/Group) Input the brand/group code, if applicable, or input ?? to search for the code. If the code does not exist, input a code identifier, and the system will ask if you wish to input a new code. Input Y (Yes), and input the code information. Press the Escape key ([) to go back to INV-1. This code is used to segregate inventory items and for production reports.
28.

(Warranty Period (Days)) Input the warranty period (number of days), if applicable. If this item is returned for repair or replacement (via a customer memo or return material authorization (RMA)), the system will notify you if it is no longer under warranty.

29. (Lead Time) Input the number of days it normally takes the vendor to deliver this item to you. If there is no lead time, press the Return key to leave the field blank.
30. (Minimum Quantity on Hand) Input the minimum quantity on hand for the item. A report may then be produced by the purchasing department advising them to purchase the item based on the minimum quantity on hand (procedure PO-23).
31. (Package Quantity) Input the package quantity, if applicable. For example: The unit of measure is Case (CS). There are 1 0 items in a case. The package quantity is 10.
32. (Sort Number) Input the sort number for the item, if applicable. This field is normally used for small parts found in bins.
33. (Line Number) This field selects the line-item set. The arrow next to the line number indicates your line position. If you want to go to a particular line, you must be in this line number field. Input the line number, and the arrow will move to that line number.
34. (In-house Destination) This refers to the location within your company that the inventory item is stored. Input the in-house destination code for the item, or input ?? to search for the code. If the code does not exist, input a new code into this field. * The system normally defaults to "R" for Receiving.
35. (Source) The system will continually update this field from purchase orders. The source identifies the vendor number and the vendor's name from whom you purchased the item. * If a vendor has a quoted price for the iter-n, but you have not actually purchased the item from them, you may input the vendor # into this field (and the price in field 36) for future reference.
36. (Price) The system will continually update this field from purchase orders. This field displays the last purchase price from the vendor listed in field 35. See previous field (35) for additional information.
37. (Manufacturer's Code) Input the manufacturer's code, if applicable. Input ?? to search for the code. If the code does not exist, enter a new code in this field.
38. (Alternate Part Number) If a particular vendor wants you to use his part number when ordering, input this number for future reference.
Input /F to file the inventory item.
Helpful Commands:
  • Input ? to access the Screen Help Directory.
  • Input IC to input comments for the inventory item. You can store notes on vendors or other helpful information for the item.
  • Input /IS to display inventory information for all locations combined, such as quantities, costs, dates last sold, etc.
  • Input /IL to display inventory information for individual locations.
  • Input /EC (Edit Code command) from code fields to create and edit codes.
  • Input /MORE to input alternate unit of measures and units.