View/Edit Item Inventory Information Version

Contents

This topic discusses:

Links to related topics:

Search Online Doc
Current Release Notes

Overview

The Item Inventory is a list of items available for requisition from an asset location. Each item has a detailed record that contains information such as stock status, vendor UOMs, authorized and unauthorized POs for the item, usage statistics, order guides containing the item, and more.

Asset locations are repositories for item records, including vendor, manufacturer, and contract information. The item data is available for requisitioning, purchasing, receiving, invoicing, and accounts payable activities, regardless of whether the hospital keeps inventories of items on hand, or uses a stockless supply process.

You can access item information for a single asset location -- the Asset Location specified in your Current Settings. You, or staff at your site, may also have access to multiple asset locations, and may also be able to view inventory information for those asset locations as well.

Security

If your user profile restricts you from displaying financial data, fields on any of the item inventory panels that normally display financial information (such as unit prices, average cost, inventory value) contain "{restricted data}."

In addition, to be able to edit item inventory information at a particular asset location, the field Allow Changes to Asset Location and Inventory on the Data Profile Asset Location panel must be selected. This field controls permission to edit asset location records and edit item inventory records at the asset location. This field also controls permission for the following functions that you can perform for an inventory item:

The functions are available from the Menu next to any item on the item inventory list.

The menu option Reset Stock Item Pipeline Days is grayed out unless the user has the authority to reset the pipeline days.

The topic Restrict Users from Editing Asset Location Records and Item Inventory Records outlines how to access and use the Allow Changes to Asset Location and Inventory field.

ePHI Features

Features are built into the system to ensure the privacy of electronic protected health information (ePHI), in compliance with HIPAA requirements.

On a User Profile, the Hide ePHI Data field determines whether a user can access patient data. When Hide ePHI Data is checked, a detailed series of restrictions apply to the user's access to ePHI records. Patient information is subject to restrictions governed by this user profile field.

In sum, if Hide ePHI Data is checked, the user cannot access or display patient-identifying information.
Patient information in printed documents or panels is either not displayed or not accessible (prompts for patient information and downloads that contain patient information are not available).

The list of restrictions and examples is outlined in the ePHI documentation.

Note: Any ePHI fields in this document's figures contain fictional values, and are not associated with any actual individual.

See your system administrator if you need to maintain information in the Item Inventory.

To view the item inventory list for your authorized asset location:

Figure 1 - Item Inventory List

To view or edit item inventory information for a single item:

  1. If you need to change the Asset Location, in the Current Settings menu, select the Asset Location from the prompt (...).
  2. From the Materials Management main Contents, click Item Inventory.
  3. Enter the Item No in the Position To box.
  4. Click Go. The Item Inventory List displays.
  5. Next to the record you wish to view, click the i.
    - The system displays the item inventory information on the Item Inventory Inquiry panel. The panel has top and bottom tabs Figure 2.

Figure 2 - Item Inventory Record, Inquiry View

Note: All patient identifier fields in this document's figures contain fictional values, and are not associated with any actual individual.

The edit panel contains the same bottom tabs, but only two of the top tabs (Figure 3).

Figure 3 - Item Inventory Record, Edit View

Note: All patient identifier fields in this document's figures contain fictional values, and are not associated with any actual individual.

Summary of Tabs Contents

On the Item Edit panel, clicking Help displays information about all the fields. (The Inquiry panel has no help button.)

Item Inventory Inquiry - Top Tabs

When you click the i next to a record, these tabs appear at the top:

Item Inventory Edit - Top Tabs

When you click the edit pencil icon next to a record, only these tabs appear at the top:

Note: The system will not let you enter organization expense code overrides when the item inventory record has an Override Charge Department value (on the lower panel's Override Charge tab). Similarly, you cannot enter a value for the Override Charge Department when an organization expense code override already value exists.

Figure 4 - Expense Overrides Tab

Item Inventory Inquiry and Edit - Bottom Tabs

When you click the edit pencil icon or the i next to a record, these tabs appear at the bottom; Item Definition, Stock Status, Vendor Information, Override Charge,
Lot Tracking, Latest,
and Export Control. The paragraphs below provide information on several key fields. All the fields are explained in the Item Edit panel Help.

Item Definition: See Figure 3. Shows a subset of the categories from the item catalog that characterize the item and are relevant to inventory (e.g., Patient Chargeable and Non-Chargeable Expense Codes, ABC Class, whether the item is a consignment item, etc.)

- If a Preferred Order Factor and a Preferred Order UOM are defined for an item (click the Stock Status tab), how order quantities are determined depends on the setting for this field.
- When this field is checked for a stock item, and the Preferred Order Factor and a Preferred Order UOM are also entered, ordered quantities for purchase orders are adjusted upwards by the UOM and UOM factor.
- When this field is not checked, ordered quantities for transfer requisitions are adjusted upwards by the specified UOM and UOM factor.

 Minimum Stock Level = Days Between Delivery * Average Daily Usage

otherwise:

 Minimum Stock Level = Pipeline Days * Average Daily Usage

If unchecked, the system allows an authorized user to determine the Minimum Stock Quantity. Use Auto Adjust Minimum Stock level for Stock items only.

Figure 5 - The Bill-Only Field Used for Implant System ("Pulse") Requisitioning

Stock Status: See Figure 6. Shows quantity descriptors and values (Minimum Stock Quantity, Maximum Stock Quantity, Allocated Quantity, On-Order Authorized Quantity, Pipeline Days), aisle/bin locations, physical inventory information, and more.

Figure 6 - Item Inventory Record Stock Status Tabbed Panel

To edit the Pipeline Days,

  1. From the Materials Management main Contents, select Item Inventory or Item Inventory All Locations.
  2. Locate the item of interest.
  3. Next to the item on the list, click Menu > Reset Stock Item Pipeline Days. A panel appears for resetting the pipeline days.
  4. Enter the new number of days in the field Pipeline Days.
  5. Click Submit. The pipeline days are reset for the item.

Note: The menu option Reset Stock Item Pipeline Days for editing pipeline days is not available if:
- You do not have the authority to reset Pipeline Days.
- The item was created less than 45 days ago.
- The Pipeline Days for the item was reset less than 45 days ago.
- The item not a stock item type.

Reasons for Editing Pipeline Days:
The pipeline days associated with an item can be influenced by the amount of time that purchase orders for the item sit in the unauthorized state, awaiting approval. Similarly, when an item is on vendor backorder, the pipeline days can be affected. These situations can result in an unrealistic calculation from the response formula, which the system uses to project replenishment times and levels for stock items.

To compensate, edit the Pipeline Days associated with a stock item inventory record to correct skewed values resulting from delays.

When you reset pipeline days manually, the system uses the reset value for the next 45 days from the reset date, then calculations for average pipeline days resume.

Example 1:

Item ABC has the Preferred Order Factor set to 5. Whenever a quantity is added to or removed from a purchase order for item ABC, if the quantity is not evenly divisible by 5, it must be rounded up to the next highest, evenly divisible factor of 5. Thus, a quantity of 4 becomes 5; a quantity of 7 becomes 10; a quantity of 15 stays at 15, etc. Rounding up is applied to the quantity instead of best-packaging.

Example 2:

An item has UOMs and conversion factors for ordering as follows: CA/24, BX/12, PK/6, EA/1.
The Preferred Order Factor is 2 and the Preferred Order UOM is PK. Whatever quantity is ordered on the line for the item, it must be in terms of (or divisible by) 2 PKs. Below are sample quantity adjustments.

If ordering.... Adjusted to...
4 EA 2 PK (rounded to the next highest of 2 PK)
7 EA 2 PK (rounded to the next highest of 2 PK)
1 PK 2 PK (rounded to the next highest of 2 PK)
10 EA 2 PK (rounded to the next highest of 2 PK)
12 EA 2 PK (rounded to the next highest of 2 PK)
13 EA 4 PK (rounded to the next highest of 2 PK)
3 BX 6 PK (3 BX evenly goes to factor of 2 PK)
3 PK 4 PK (rounded to the next highest of 2 PK)
3 CA 12 PK (3 CA evenly goes to factor or 2 PK)
37 EA 8 PK (rounded to the next highest of 2 PK)

Vendor Information: (See Figure 7.) Shows the Primary Vendor and Primary Manufacturer, Contract number (if relevant), UOMs (lowest, order, issue) and conversion values for UOMs.

Figure 7 - Item Inventory Record Vendor Information Tabbed Panel

Override Charge: Shows the department (and organization) to which the item is charged as a override of the usual charge department.

Lot Tracking: Shows lot tracking information, if used for the item.

Latest: Shows updated statistics such as Last Inventoried Date, Last Inventoried Quantity, Last Received Date, Last Invoice Date, quantities and costs.

Export Control: Export controls are used in selecting item records for export; for example, export to a supply dispensing unit such as Pyxis. Export controls are defined in the Materials Management tables. Once defined and assigned to item records, you can specify export controls on the Item Export Selection Parameters panel.
For details, see the discussion in exporting item records: Using Export Controls

Figure 8 - Searching for Export Control Codes on the Item Inventory List

Important: To search for an Export Control Code value (either using the Quick Filter or the Search link), do this:

To view inventory transactions for an item:

  1. From the Materials Management main Contents, click Inventory > Item Inventory or click Inventory > Item Inventory - All Locations.
    - The item inventory list appears.
  2. Enter an item number (Item No) in the Position To box.
  3. Click Go.
  4. Next to the item, select Menu > View Inventory Transactions.
    - Inventory transaction information for the item appears (Figure 9).

.

Figure 9 - Inventory Transactions for an Item

Notes:

Transaction Types

In using some report objects, you can select the field "Transaction Type." This field is usually an integer value, rather than a description of the transaction. Here is a list of transaction types, and the matching number type.

 

Transaction Type -- Description Transaction Type -- Number
Requisition 1
Issue to dept 2
Inventory adjustment 3
Dept return to inventory 4
PO credit 5
PO-unauthorized 6
PO-authorized 7
Receipt 8
Transfer - entry 9
Issue - transfer 10
Receipt - transfer 11
Receipt - direct delivery 12
Issue - direct delivery 13
Physical inventory 14
Cost adjustment 15
Return to vendor 16
Cancel -- issue to dept 17
Cancel -- receipt 18
PO credit adjustment 19
Dept to dept transfer out 20
Dept to dept transfer in 21

To view file inventory transactions:

  1. From the Materials Management main Contents, click Inventory > File Item Transactions.
    - The Inventory Transactions list for file items appears.
    - A small arrow next to an Item No takes you to a tabbed panel. From the panel, you can view an item picture, an MSDS, or contract information for the item;
  2. Click GL Transactions to view the transactions associated with the item.

To view non-file inventory transactions:

  1. From the Materials Management main Contents, click Inventory > Non-file Item Transactions.
    The Non File Item Transactions list appears.
    - If there is a small arrow next to Vendor or Manufacturer, clicking it takes you to the vendor's or manufacturer's web page.
    - If you wish to search the list for particular items, click Search and enter your search values on the Search panel. Notice that you can search for an Item Description by entering text in the Item Desc field.
  2. Click GL Transactions to view the transactions associated with the item.

Inventory Valuation

For each organization and asset location defined in the user's data profile, the Item Inventory Value list (Figure 10) shows the inventory value. The valuation data include:

An inventory's value is updated when inventory transactions are created for any of its items. If an asset location had no inventory transactions, a message appears when you request the inventory valuation.

The Item Inventory Value list lets users drill down on each asset location to view inventory values for each Inventory Group and Item Class.

Note: The role object "Inventory Value" allows you to work with inventory valuations. The minimum setting is View. If this role object is set to None, the Inventory Value menu item is not visible on the main Materials Management contents.

To view inventory values:

  1. From the Materials Management main Contents, select Inventory > Inventory Value.
    - The
    Item Inventory list appears (Figure 10).

Figure 10 - Item Inventory Value List

To view a breakdown of inventory values from the Inventory Value List:

  1. Click Inventory Value Breakdown next to any organization/asset location in the list.
    - The Inventory Value Breakdown panel appears (Figure 11).

Figure 11 - Inventory Value Breakdown Panel

- The Inventory Group header (Figure 11) shows organization and asset location information, the period, and the accounting year from your financial calendar.
- Below the header (Figure 11), the Inventory Group tab shows inventory value by Inventory Group, if you have Inventory Groups defined.

  1. Click the Item Class tab to view inventory value by item class.
  2. Select the UNSPSC tab to view inventory value by UNSPSC code. The remaining tabs -- UNSPSC Segment, UNSPSC Family, and UNSPSC Class -- display inventory information by each 2-digit UNSPSC code portion: segment (the first two code integers); family (the second two code integers), and class (the last two integers). For details on UNSPSC codes, see Using UNSPSC Codes.

Accessing Inventory Values

Permission to run inventory values is provided by the "Inventory Value" role object (Figure 12), which must be included in the user's role, and set to All. (See Set Up and Maintain Users for details on role objects.)

Figure 12 - Inventory Value Role Object