docs.cissltd.com

Inventory Pro

Trace: Inventory

Inventory

Inventory

The Inventory menu is broken into two sections, Inventory, and Lists. The lists on the Inventory menu play a vital role in entering your data. Your lists must be populated before you begin adding your items and receiving inventory in. These lists can range vary. They include Suppliers, Units of Measure, Categories, Center Codes, and more.

Inventory Overview

Inventory → Inventory → Inventory Overview This is the default landing page when you log on to Inventory Pro, This screen shows a general overview of inventory levels, and inbound / outbound stock. It also allows you to manage all aspects of your inventory configuration for item definitions, reorder levels, item images, history, warehouse mappings and more.

Field/Column Name Description
EditThe pencil icon in this field takes you to edit the item definition for the given item.
Label This tag icon will show the barcode label for the given item.
Item IDThis field shows the unique identifier of the item, clicking this field will also allow you to edit warehouse mappings.
CategoryThis field displays the category to which the object is assigned.
DescriptionThis field shows a text description of the item.
ImageClicking on the camera icon in this field shows an image of the object if one has been input into the database. Otherwise, it will show an image of an X.
HistoryClicking on the magnifying glass icon in this field takes you to a transaction history of the item, showing all sales and deliveries of the item.
Reorder LevelClicking on the icon in this field takes you to the reorder information of an item.
In StockThe number in this field shows the number of units in stock that are available to ship minus what is on hold. It does not subtract the commitments or backorders from this field. If you click on the in-stock number, you will be shown the unit details.
On OrderThe number in this field shows how many units are currently on order for a given item. Clicking it shows all outstanding orders.
On HoldThe number in this field shows you all of the units on hold for that item ID. Clicking on the number will show those units
CommittedThe quantity in this column represents the number of units to go out on current shipping orders (only showing what is in stock that is committed).
Add ItemThis button allows you to add a new item record to the item master list.
Default SupplierIf a supplier is selected from the dropdown menu in this field, the item master will only display the items with that supplier selected as their main supplier in the Item Master Record detail screen.

Item Definitions

Not all fields may be shown on the screen. The list below is of the standard fields available. There are a number of other fields which can be turned on or used for unique requirements. See the customization section of the manual or contact CISS for more information if you would like to know more.

Item Attributes

Categories

System → Lists → Categories → “Add New Item Categories” Button / Pencil Icon in Edit Column

The Category field is one way of classifying your inventory. For example, if your business makes pens, you might use “ballpoint”, “felt tip”, and “gel writer” as your categories. If this list is left blank, this category will be listed as “all” for your inventory items. To add to the categories list:

  1. Click on System and then on Categories.
  2. Click on the “Add New Item Categories” button to add a new category or click on the pencil next to an existing category to edit it.
  3. Enter a description for the category in the Description field and make sure that the checkbox in the Use in Lookups field is checked. (Note: if you wish to retire a category, simply uncheck that checkbox after clicking on the pencil icon next to a category.)
  4. Press the “Save” button to save your category.

Center Codes

System → Lists → Center Codes → “Add New Item Center Codes” Button / Pencil Icon in Edit Column

The center code provides another way of classifying your inventory items, by cost center instead of category. Center codes are used for accounting purposes. For example, if you receive the same item from a number of sources, you can use the center code to track the source of each item for cost purposes. Many users of Inventory Pro Online choose to treat the center code as a secondary category list rather than as an accounting feature. To add a center code:

  1. Click on System and then on Center Codes.
  2. Click on the “Add New Item Center Codes” button to add a center code or click on the pencil next to an existing one to edit that code.
  3. Enter a name for the center code in the Name field.
  4. If necessary, enter a description for the center code or a warehouse to which the center code is restricted in the Description and Warehouse fields, respectively.
  5. Make sure the checkbox in the Use in Lookups field is checked. (Note: if you wish to retire a center code, simply uncheck that checkbox after clicking on the pencil icon next to a center code.)
  6. Press the “Save” button to save your center code.

Package

Units of Measure

System → Lists → Units of Measure

The “Unit of Measure” field on the “Item Master List” screen is used to define how you count your inventory (for example each, foot, pound, or ounce). Your unit of measure should always be the lowest countable unit. You may have as many units of measure as necessary. See below for adding new units of measure.

UOM Conversions

System → Lists → Units of Measure

Inventory Pro Online will also allow an item to be inventoried as one unit of measure but ordered or shipped in a larger unit of measure or vice versa. This can be used when your supplier requires the items to be ordered in a larger unit of measure than you store it or when your customer needs it to be sent in a unit of measure smaller than you store it.
The base unit of measure refers to the smallest unit of measure in which you wish to keep track of an item. So if you inventory your items in feet, a foot is the unit of measure. But if you will be receiving in inches, an inch would be the base unit of measure of the unit of measure foot. You must enter the conversion factors of different units into this list prior to being able to utilize this feature. To add a standard or conversion unit of measure:

  1. Click on System and then on Unit of Measure.
  2. Click on the “Add New Unit of Measure” button.
  3. Enter the name of the unit of measure in the Unit Of Measure field.
  4. If you want to add a standard unit of measure (e.g. inches in the example above), you would enter it as not having a base UOM but place 1 in the “Contains” field. If there is no base UOM enter it will default to itself when you save.
  5. To add a conversion unit of measure (e.g. feet), add another unit of measure the same way you added the standard unit. However, instead of leaving Base UOM blank, click on the drop-down menu and then click on the unit which you wish to use as a base. As well, enter the conversion factor in the “Contains” field (in this example, the number in “Contains” should be 12).

Item Aliases

Inventory → Management → Item Aliases

Item aliases work with the scanning functionality in different areas of the system. They allow a client to assign UPC, ISBN, or other barcode numbers to a product. It's also helpful for clients who purchase several different brands of the same item but treat it as a single internal item number. They can scan the barcodes and they will link back to the proper item number. To add or modify an item alias:

  1. Click on Inventory and then on Item Aliases.
  2. Click on the “Add New Item Alias” button to add a new item alias or click on the pencil icon next to an existing item alias to modify it.
  3. Click on the three dots icon to select the item to which you want to add an alias (note that you can only add aliases to items in the warehouse in which you are currently working) and type the alias in the box labeled Alias.
  4. Click on the “Save” button

Additional Features

Inventory Catalog

Barcode Catalog

Certifications and Inspections