Parts Inventory SOP 0027

Purpose

This procedure provides information for your agency staff to ensure that:

  1. To avoid problematic issues when generating work orders in ETMS
  2. All vendors and parts are accurately accounted for in ETMS for use on all electronic work orders
  3. All parts in ETMS are up-to-date to ensure accuracy in financial tables for agency reporting needs
  4. Manual reconciliation is required for use of non-stock items on WOs as ETMS does not track associated costs for non- stock items

Operational Impact and Metrics

  1. To ensure scheduled revenue service is completed in a timely manner without unnecessary service interruptions
    1. Impacts ridership trip planning
    2. Impacts reporting metrics
  2. To increase maintenance team workflow efficiencies 
  3. To ensure that all parts included on work orders feed into the correct financial tables for agency accounting 
  4. Pro Tip: Use 'Stock' when possible for all part entries in ETMS

Definitions

ITS Intelligent Transportation Systems
CAD/AVL Computer-Aided Dispatch and Automatic Vehicle Location
WO Work orders in ETMS
DB table Database tables are areas used to store specific data states and to distribute data to other product areas/ tables, such as for finance, procurement, accounts payable through table 'join actions'
Stock Vs Non-Stock Parts Stock items carry associated costs when used for work orders and non-stock items do not. TIP: Manually reconcile costs of non-stock items for accurate financial accounting/ reporting metrics

Frequency

This procedure should be performed:

  1. When new parts must be added to ETMS for work order tracking purposes
  2. When parts require updates- inactivating or re-numbering parts
  3. When parts require re-ordering as there are none 'on hand'

Positions and Responsibilities

Implementation of this procedure is the responsibility of:

  1. Agency selected staff who need access to manage parts inventory entries
    1. Maintenance admins, managers and supervisors
    2. Inventory managers and supervisors

Procedure

This procedure describes the high-level steps involved:

  1. Login to ETMS and navigate to Parts Inventory or use the search and pattern matching to locate the card
    1. Search Example: parts inv
  2. Open the Parts Inventory Card

Add New Part

Overview: When adding new parts, you'll be required to enter data in multiple fields on several sub-tabs, which are described below.

  1. Press the Add Part button
    1. To enter basic information for the new part
  2. Enter part number in popup window
    1. Parameters for entry: Use whole integers, hyphens, upper/lower case letters, spaces
      1. Part Ids are not case sensitive meaning if you enter AB1part and ab1part, they are valued as identical and create only one part entry
    2. Confirm the Id is unique and not in use elsewhere for another part
    3. Software will validate the Id as valid or in use
    4. If in use, enter a different, unique Id
  3. Enter a description
  4. Enter Stock or Non- Stock for the item
    1. Non-stock items are not tracked for associated costs in ETMS
    2. Manual reconciliation is required when used on WOs
  5. Enter UOM (unit of measure)
  6. Enter Product Class Code
    1. Important: Class Code determines which tables the data feed into for accurate financial reporting

Basic Info Tab

  1. On Hand- Available quantity 
  2. On Order - Field indicates active orders
  3. Committed - Already assigned to a work order
  4. Available - based on quantity documented in ETMS
  5. Product Class Code - Ensure the data feeds into the correct DB tables. This field is prepopulated based on initial entry and is editable, if needed
  6. Unit of Measure - Indicates quantity per pack (box, dozen, gallon, pack, each, etc.)
  7. Min Stock - Indicates the minimum number required, used in Auto Reordering 
  8. Max Stock - Indicates maximum number to have on hand at a given time, used in Auto Reordering 
  9. Per Pack - How many per unit for measure used
  10. Last Count - Indicates last amount available/ unused on work orders, counted during an inventory count (inventory cycle monitoring)
  11. Count Date - Last check for part by date, counted during an inventory count (inventory cycle monitoring)
  12. Inventory Cycle - Indicates frequency for checking quantities,  the cycle used for the part/ will be counted when using Cycle Counts
  13. Commodity Code - Optional
  14. Last Cost - Most recently documented cost from the last PO received for the part
  15. Average Cost - Projected average based on part use- receiving and inventory adjustments
  16. Current Value - A calculated field
    1. Is the quantity on hand × average cost
    2. When a PO is received, ETMS revalues the whole stock for quantity on hand × Last Cost
    3. Until the next work order issue, Current Value will therefore not equal quantity on hand × Average Cost
    4. Reconcile Current Value against your financial records to confirm  
  17. Hazardous Checkbox - Check the box to indicate toxicity 
  18. Comment Field - Optional use to include additional details about the part
    1. Hazardous material handling, for example
    2. Prior Part number change
  19. Press Save when done

Extra Info Tab

Use this area to indicate part location, related contracts and vendors, contract end date and description.

Press  + to add information

  1. Warehouse - Important: Easily add a new warehouse or use warehouses in system to indicate part location
  2. Bin - Can include details about shelf and bin location to ease locating parts when needed
    1. Be sure to press the Save icon- located to right- to save the update
  3. Vehicle Model - Compatible vehicle models part can be used for
  4. Substitution Item # - Any compatible substitutions for parts
  5. Contract # - If there is an active contract use this field to indicate this
  6. Contract Vendor - Use to enter specific vendor for contract
  7. End Date - Contract expiry date, as needed
  8. Contract Description - Use to describe specific information
  9. Save - press to save the information

Vendor Tab

Press the +Add to add new vendors

  1. Vendor # - The Vendor Id used in ETMS to track parts for the vendor 
  2. Vendor - Name of vendor
    1. Example: Aramark Uniforms, After Market Parts R U, etc.
    2. Multiple vendors can be used for ordering parts. The unique Ids for vendors and parts are identified in ETMS and used to separate vendor's and their parts
      1. Example: " We use ACME and GETEM vendors to order lug nuts."
  3. Vendor Part # - This unique Id identifies a specific vendor's part number
  4. Description - Vendor's description of details about the part
  5. Last Purchased - Date part was last ordered
  6. Last Unit Cost - Most recent cost for part
  7. Save - Press to save the information

Perpetual Tab

Use the Perpetual tab to review all information and transactions that transpired for the part, options to filter on specific metrics.

  1. Part Number - Displays as view only here
  2. From - Use to enter the beginning date for the range to run a query against the part
  3. To - Use to enter the ending date for the range to run a query against the part
    1. Transactions that happened on the To date itself are mostly left out. To include a day's transactions, set To to the following day
  4. Menu: Check as many boxes as needed for those you wish to query/ research:
    1. Ordered 2. Purchase Adjustments 3. Invoice Cancellation 4. Physical Inventory Deviations 5. Receipts 6. Usage 7. Finished Goods 8. All Transactions 9. Order Cancellation 10. Issues 11. Return to Inventory 12. Back Order 13. Invoiced 14. Transfers
  5. Display Transactions button - Button is available for use after selecting search parameters
  6. Excel Export button - Press to create an Excel document
  7. Save - press to save the information

Notes Tab

Use this tab to document additional information about the part. Examples can include part handling measures, install steps, etc. 

  1. Code - Select a code from the dropdown menu
  2. Notes Field - Enter specific details
  3. Save - press to save the information
  4. Saved notes cannot be modified

History Tab

  1. Usage History - Bar graph displays activity for monthly usage 
    1. Select Period - Select the date range you wish to review history for
      1. Select range: 3, 6, 12, or 24 month ranges
  2. Quantity on Hand - Indicates how many of the part are available to assign to work orders
  3. Quantity on Order - Indicates how many of the part have been reordered/ are currently on order
  4. Average Cost - Average cost of the part over time
  5. Last Cost - Cost the last time the part was purchased
  6. Prior Fiscal Year - Identifies quantity used in last fiscal year
  7. This Month/ Period - Recent activity for use of part
    1. Item Usage - Indicates frequency of use activity for this month and for the range selected (3,6,12,24 month cycle)
    2. Amount Used -  Indicates cost for this month and for the range selected (3,6,12,24 month cycle)
    3. Back Orders -  Indicates back orders for this month and based on selected range (3,6,12,24 month cycle)
    4. Purchases - Indicates summed value for part if ordered during this period and also based on the selected range (3, 6,12, 24 month)
  8. Stock Levels - Color- coded graph displays part usage, on hand quantities, min and maxes, if part has been re-ordered. Hover over the bar to see all values
    1. On Hand (at risk)- blue bar indicates there are too few on hand- below minimum quantity
    2. Understocked- On Hand plus On Order Projected- bar indicates level is below ideal quantity (minimum quantity)
    3. Minimums - Indicates the lowest quantity available for use (to be kept on hand)
      1. NOTE: Low levels can indicate risk for heavily used parts/ influences ability to complete work orders in a timely manner
    4. Maximums - Indicates the maximum quantity available/ to be kept on hand
      1. NOTE: High stock levels can ensure work orders to be completed in a timely manner, but can also pose issues with holding too many of a part on the shelf.

Audit Tab

Use the 'read only' audit tab to review the last time the part was edited. Each edited record creates a timestamp in the backend: 1. Update By User 2. Update Date 3. Update Function.

Edit Part 

In some cases, parts will require updates. Costs, new vendors for the part, compatible parts, etc., may change over time. When editing a part, be sure to confirm accuracy and save the update.

  1. Locate the part and open its record
  2. Edit the part to update the specifications needed
  3. Confirm accuracy for the edited information
  4. Press the Save button to save the update
PRO TIP: Take care of editing and managerial settings for work orders, particularly class codes, as these data sets feed into specific tables for financial accounting purposes. If these are incorrect, they will slow internal workflows down. Managing overall specifications for work orders should be completed by managers, supervisors, and in the Work Order Management Settings area of Transit Assets. The cog on the Work Orders screen also provides a shortcut to 'management settings', if needed 'on-the-fly'.
  1. Open the Work Orders card
  2. Press the cog wheel on the upper right of the screen to access settings
    1. Important to include this permission at the managerial/ supervisory levels, at the discretion of the agency
  3. Open the Class Codes to edit
  4. Open an existing Class Code to update
  5. Or press the Add Class Code button to add a new one
    1. Adding new class codes is rarely needed 
  6. Save any updates

Renumber Button

In some cases, renumbering a part is necessary. If a manufacturer changes/ updates an Id for a part you use, it is necessary to update the Id for the part, to attribute the part to active and upcoming work orders and for related financial tables. 

  1. Search for the part
  2. Open the part record to edit
  3. Press the orange Renumber button
  4. In the popup window, update the part Id
  5. Enter the new Id and confirm it is accurate
  6. Check the box if you also want to print a new label
  7. Press OK to save the update
PRO TIP: It can be helpful to add a Comment about the legacy Id for the part for reference, on the main record for the part.

Attachments Button

Press the Attachments button to add additional documentation for a part. Attachments can be warranties, installation manuals, etc. When uploaded, they will follow the part, unless removed. Any previously uploaded documentation is also displayed here.

  1. Press the Attachments button
  2. Next screen: Use the Add Attachment button to upload documentation
  3. Drag and drop a document into the window
  4. Or search the computer for the document
  5. Category - Use the dropdown to add the category type
  6. Attachment title - enter a name (character count is 48)
  7. Optional Comment Field - Can enter additional details as preferred

Edit Permissions-Attachments

This button should only be used by trained staff. If it displays for incorrect staff, adjust overall permissions at the position level in Human Resources. Access determines attachments permissions based on staff position. 

  1. Select the position that should have access and check the box
  2. Press Save to save the update
  3. Confirm appropriate staff has access to upload attachments 

Advanced Search

  1. When parts are already entered into ETMS, use the Advanced Search tool to locate a part needed for a work order quickly. 
  2. Press the 'funnel' Filter, located to the right, to open and use the menu. Search by any combination of the following terms: 
  • Vendor 
  • Warehouse
  • Bin
  • Class Code
  • Vehicle Models
  • Vendor Part #
  • Previous Vendor Part #
  1. Press the blue Filter button to activate the search/ yield results to review 
  2. Press the Reset button to clear the active search terms

Related Articles & SOPs

Parts Inventory

Work Order Management Settings

Work Orders (Video)

Maintenance Dashboard

Maintenance SOP 032: Preventative Maintenance

Maintenance SOP 033: Supervision for Management

 

Was this article helpful?

Articles in this section

New to the Help Center?
Review the Help Center guide
Help Center Feedback
Have a suggestion for new content or how we can improve the Help Center? Let us know!