Parts Ordering Card- Core Lite Inventory Replenishment

Overview

Parts Ordering Core introduces a new feature that provides agencies with a way to record parts orders in ETMS due for replenishment to avoid running out of essential parts at the time of need. Built in checks and balances provide control for who authorizes or cancels replenishment requests, to verify materials received, track back-ordered items and update inventory. ETMS Core does this without a full requisition and finance process, and is intended for agencies that do not use the ETMS Finance product suite.

Future Proofing & Planning

Core will also eventually provide a way to seamlessly integrate Finance product suites in future software iterations for an agency so implementation will be enabled easily. This 'lite solution' is simply included in the core build for ETMS and the application writes replenishment orders directly to ETMS as a streamlined inventory-replenishment workflow ease, to increase workflow efficiencies.

Lite Solution Versus Finance Package

Business Need Parts Ordering Core Full Procurement Workflow External Procurement
Record a parts order (Create) Yes Yes Yes
Receive stocked material (Receive) Yes Yes Yes, with ETMS process
Separate authorization permission Yes Yes External system dependent
Multi-step requisition routing No Yes External system
Requisition-to-PO conversion No Yes External system
Accounts payable/invoicing No Yes External system
Auto-Reorder generation Separate capability Legacy/full workflow dependent Configuration dependent

ETMS Relationships

The parts ordering replenishment workflow involves several areas of ETMS. There are important software relationships that enable the features to work together collectively: 1) Vendor Management 2) Parts Inventory and 3) Parts Ordering. For this reason, all three card areas must be accurate and related staff workflows are interdependent. 

Common Staff Involvement

  • Parts clerks 
  • Stockroom staff 
  • Maintenance supervisors 
  • Purchasing coordinators 
  • Transit Assets administrators 
  • Those staff designated by agency, per workflow needs

Parts Inventory Replenishment Workflow Impact

Work Orders Impact: The parts inventory replenishment feature is a process that allows agencies to setup replenishment cycles for parts when they are in low quantities, removing the risk of quantities getting too low to fulfill work orders, which could thereby slow internal maintenance team workflows that may impact service offerings.  

Important Pro Tips: 

  1. This workflow is a 'lite solution' intended for agencies not using Finance product suites. 
  2. This 'lite solution' is not a replacement for a formal requisition and purchasing process when an agency requires broader procurement controls. 
  3. This process does, however, include two key authorization check points: 1) Designated staff who authorize or cancel a replenishment order and 2) Designated agency staff who receive the parts/s.

External Procurement Workflow

For Tyler-strategy orders, myAvail receiving status and Tyler’s externally polled status are intentionally separate signals/ pathways.  

A Tyler order remains on the Active list until its ETMS work is complete, even after Tyler rejects or closes it, so agency staff can still cancel or receive the order in myAvail and keep inventory correct. 

ETMS Core orders always show line items for orders, while Tyler orders require the applicable feature flag. The Revision dropdown changes the displayed lines without reloading the entire order. 

Replenishment Workflow Initial Setup Requirements

To use the parts replenishment process efficiently there are required setup steps to take first. The checklist below includes these:

  • Establish ownership of tasks and set staff permissions accordingly at the position level
  • Enter vendors on the Vendor Management Card 
  • Parts anticipated for replenishment/ reordering must be documented in the Parts Inventory Card screen
  • Parts must include the correct Class Code, be listed as Active, include UOM (unit of measure)

Parts Ordering Card

The Parts Ordering card is used to create parts orders and receive the parts. This card is located in Transit Assets > Parts Management Card > Parts Ordering card ( or simply search for the Parts Ordering card)

Staff with the correct permissions can create orders on the Parts Ordering card. When the parts are received, they can then be documented in Parts Inventory as available for use on work orders. When reordering from an existing vendor, some information for the parts ordered may require updates, so confirmation before creating an order is best practice. Required entries will include quantity and costs. To review the process for adding new parts in Parts Inventory, review this article: Parts Inventory 

TIP: As an intentionally 'lite solution', there are no connections to AR-Accounts Receivable, AP-Accounts Payable, and thereby the GL- General Ledger. Parts Ordering Core is a streamlined inventory-replenishment workflow. It does not produce a full requisition-routing, bidding, budget-control, or accounts-payable process.

Create New Order 

Parts Ordering Screen

All existing orders display here. 

Press NEW ORDER 

On the next screen add details for the parts to be ordered. Notice you can check the box for include a label for the order here. Some fields are required and will be highlighted in ETMS if entries are missed.

  1. Enter Item Number
  2. Description will prepopulate (based on part entry information added in ETMS)
  3. Indicate quantity desired (ensure accuracy here, as associated costs for quantity are finalized at receiving)
  4. Indicate UOM
  5. Enter Unit Cost (ensure accuracy here, as costs are finalized at receiving)
  6. Check the box if taxable
  7. Extended cost populates
  8. Enter Vendor Item Number
  9. Vendor Item Description prepopulates
  10. Work Order- Use the dropdown menu to add the part order to an active work order for efficiency 
  11. Work Order Id will prepopulate
  12. Select Asset Type (component, facility, vehicle, etc.)
  13. Asset Id prepopulates
  14. Asset Id Description prepopulates
  15. Notes- Optional field for additional information
  16. Press ADD to create the request

Basic Troubleshooting

  • If data is missing or incorrect when placing parts orders for replenishment, confirm that all information for the part, including any needed updates, have all been documented in ETMS on the Parts Inventory Card for the part.

Settings Gear

The Settings gear can be used as a convenient 'shortcut' to the settings area to ensure all shipping information is included for Bill To and Ship To locations. 

TIP:  At initial implementation of ETMS Core, Avail teams will work with your agency to assist with the set up your initial billing and shipping information here. Here's how to manage it independently:

  1. Open the Settings Gear in Parts Ordering:
  1. Missing data should be added here and will be highlighted if missing.
  2. Press the 'edit pencil' to add missing information for a specific line item/ department.
  1. Use the built- in link ADD ADDRESS to open the window to add billing and shipping information:
  1. On the next screen add required entries: Name, Addresses, City, State, Zip, Phone Numbers, Phone Ext., Fax and Email
  2. You can also adjust the screen view as preferred in two ways. 

Screen View 1- Use the default view that loads- offers a scroll bar to move up/ down on the screen:

Screen View 2- Or press the rectangle/ box near the upper right corner of the screen- to expand the view:

  1. Press Save when done adding Bill To/ Ship To information

Filters & Search

ETMS includes easy to use filtering and search options. Use them to locate what you need quickly. 

Filters

Open the Parts Inventory screen and use the filter options to select your search criteria: Active, Inactive, Last 7 Days, Has Work Order (to view parts already included on an active work order).

Search

Or use the Search field to locate what you need. 

Examples: "We need to review the last orders placed this week. What parts do we need to replenish based on the active work orders we have right now?"

Vendor Management Card

Purpose: Vendor Management supplies the basic vendor records needed for replenishment processes. 
 
User Story: "As a replenishment or finance user, I want to create, maintain and update basic vendor records in ETMS, so that active vendors can be used as a foundational component for parts replenishment processes. For vendors we no longer use, I will inactivate these, so replenishment orders are not incorrect or held up."
 
Vendors and their addresses must be entered in ETMS on the Vendor Management Card. Be sure to include Terms and Sales Tax Percentages. Why? This data will feed into the parts ordering and replenishment processes, as well as financial tables for agencies who do use ETMS Finance product suites. Ensure that all vendor entered information is correct and up-to-date. If vendors are not longer in use, it is important to inactivate them on this card.
 
Workflow For Vendor Management Card Inputs 
 
Enter the following:
  • Vendor Number
  • Vendor Name
  • DBA Name/Address
  • Address Line 1
  • Address Line 2
  • Attention
  • City (City is entered as free text)
  • State (State is selected from a predefined list)
  • Zip Code
  • Inactive flag- Should be used to indicate an inactive vendor to avoid issues

Attachments 

Parts Ordering attachments enable storage of supporting documents such as quotes, packing slips, and invoices with the purchase order rather than via email or a shared drive. Attachments are associated with the original order rather than an individual revision. Permissions will determine who can upload attachments.

Parts Ordering Permissions 

User Story: "As an admin managing security permissions, I want a distinct "Authorize" permission for Parts Ordering, so that I can decide per organization whether the same people who create orders can also authorize or cancel them, or whether that needs to be a different person."

Agencies ultimately determine access to features to match internal workflows according to their purchasing policies and internal controls. Review and refine if necessary, staff permissions at the position level in ETMS > Human Resources product suite >Positions Card. Below is a suggested table for permissions assignment.

Position Suggested Permissions
Parts Clerk View, Create, Edit, Attach documents
Maintenance or Parts Manager View, Authorize, Cancel
Receiver or Stockroom Clerk View, Receive, print receiving confirmation

Pending Authorization: Staff, such as parts clerks, can create part replenishment orders but not approve them. Designated staff who have the 'authorization permission' will process the order as 'approved'. Individuals with Authorization rights may also cancel a part reorder request.

Authorize Permissions Importance: "As a staff who has the Authorize permission, I want to authorize a Pending Core order so that orders created by staff without that permission can be verified as correct and to then move forward after someone accountable has signed off. I also want to be sure that, if needed, I can cancel the request."

Permissions Flexibility:  Position assignments allow easy separation of duties to reflect differences in agency practices. There may be cases when individuals will create and authorize parts replenishment orders, and there may be cases where these responsibilities are split.

Edit Orders & Cancellations

The Edit Order button allows an order’s quantity, price, lines, date wanted, and notes to be easily updated through one action. In some cases, a parts order may need to be cancelled rather than fulfilled. Staff with permissions to authorize a replenishment order may also cancel an order. Cancelled orders, before being received, will cancel/ ignore any associated costs. All orders that have been received do have associated costs that have been charged.

Edit Quantity or Cost for existing parts order:

  1. Open an existing parts order- press directly on the record/ line item
  2. Press EDIT ORDER
  3. Open the line item to edit
  4. Adjust quantity if needed
  5. Adjust cost- if needed
  6. Enter Notes as preferred
  7. Press UPDATE

Cancel Order Not Received:

  1. Open an existing parts order- press directly on the record/ line item
  2. Press EDIT ORDER
  3. Press CANCEL
  4. Confirm action- Press YES
  5. Popup displays to confirm the order was cancelled

Confirmation: 

Receive Order

When a parts replenishment order is received at its destination, someone with permissions to Receive will accept the order. Confirming costs and quantity are crucial before pressing the Receive button as costs for receipt of good are finalized at receipt. Partial receipt will only include costs for the partial receipt of materials received. 

Follow the steps below to correctly receive an order and document any outstanding quantities for the order using the Parts Ordering card.

Receiving Workflow

Important: When receiving orders, review all parts on the order thoroughly to ensure accuracy BEFORE receiving them. 

Why: When parts have been received their associated costs push through and cannot be adjusted. This can cause reconciliation issues. Ensure permissions for receiving orders is assigned carefully.

  1. Navigate to the Parts Ordering Card- use the search to find it or open the Transit Assets Product Suite to locate the card
  2. Open an order that has arrived and is ready to be received
  3. Check the box located on the left of the line item to include/ print RECEIVING SLIPS

ETMS creates a PDF. You can open the file when it displays or simply locate it in your downloads:

PDF Receiving Slip:

  1. When the order is opened 'receiving staff' should always review the delivery to confirm the parts received as best practice: Are they correct? Is the quantity correct? 
    1. Why: Received orders push costs forward and cannot be adjusted.
  2. Press RECEIVE ORDER
    1. Notice the ability to use the CANCEL ORDER and EDIT ORDER buttons are here? 
    2. CANCEL ORDER- Did you receive the wrong items, or do you need to cancel the order entirely?
    3. EDIT ORDER- Used to edit an order not yet fulfilled
    4. The CANCEL button closes the receiving screen
  1. On the following screen enter quantity received
    1. Notice the RECEIVE ALL, BACKORDER ALL, and CANCEL ALL and ATTACHMENTS buttons display for use here
      1. Attachments can include invoices, etc.
    2. For partial receipts, determine if remainder should be backordered or canceled
    3. After entering value for goods received, the software auto-calculates remaining quantities
    4. Press BACKORDER to receive a partial shipment

Notice after pressing BACKORDER, the CONFIRM RECEIPT button becomes available for use and the BACKORDER button is highlighted (indicates it's active)

  1. Press CONFIRM RECEIPT to receive the goods.
  1. Confirmation popup- select YES to receive the order
    1. Associated costs are not editable after receiving a shipment 
  2. Press NO to cancel the action
  1. Add any attachments required- invoices, etc.
  2. Software creates a PDF 
    1. Locate PDF
      1. Can use the link that displays at the top of the screen when the download completes
      2. Or locate it in your computer's downloads

PDF:

Partial Receipt & Back Ordered

Some parts may be shipped as 'partial receipt', meaning some but not all parts on the original order have been fulfilled. In this case, the receiver may accept the partial order and document the remaining value as 'backordered'. Costs associated with the received parts will be charged and any remaining outstanding balance will be resolved at receipt of the remainder of the order. 

Full Receipt

Pro Tip: Receiving staff should review orders thoroughly before accepting them to ensure accuracy as associated costs are charged at receiving. When a full order is received, the order becomes Closed, is removed from the Active list, on-hand inventory rises, and on-order inventory drops automatically.

How It Works

ETMS Core updates on-hand quantity and cost synchronously as part of receiving. It does not wait for the legacy invoiced/pending status to be cleared by a nightly job or for a separate confirmation step. 

Did You Know? Non-stock parts that are documented in ETMS are only initially calculated for cost, if those have been entered by your staff. Non-stock parts costs are not included in total expenditures. Reconcile non-stock items manually as they by design are not pulled in final sums. Avail recommends that parts are listed as stock in Parts Inventory to allow the software to calculate costs associated with the parts when used against work orders. 

Example: "This financial report doesn't seem correct. Why not? Oh, we forgot to calculate the costs for oil and rags we used on that WO."

Receiving FAQs

  • Receiving Now cannot exceed the open quantity
    • Check and balances include a review of the quantity before receiving 
  • The receipt date cannot be in the future
  • Backorder All is disabled until a quantity is received
  • Receive Order is disabled when staff do not have permissions to receive goods (a security function)

Parts Replenishment Workflow

User Story: "We are pretty low on filters. I only see 3 in Parts Inventory and our minimum should really be 8. We go through these frequently. Let's have Paul add that new DBE vendor we'll be using, then Melody will create the order and Janson will Authorize it. When the filters arrive, Miguel will receive them in the Parts Room."

  1. Paul creates a new vendor entry on the Vendor Management Card
  2. Melody creates the order on the Parts Inventory Card
  3. Janson approves the order by authorizing it
  4. When the filters are arrived at our facility, Miguel will inspect the filters and quantity BEFORE receiving the shipment since associated costs are completed at this point for what is arrived
    • Partial receipt- Miguel marks any remainder not yet received as back ordered or canceled 
      • Partial receipt of goods do not accrue costs until received
      • Cancelled parts not received do not accrue costs
  5. At receipt of delivery (for partial or full receipt of materials ordered), parts inventory is automatically updated for mins and maxes and is reflected when work orders are created that require the parts
  6. Maintenance teams can create work orders and attach materials knowing quantities reflect what's really on the shelf

Parts Ordering Process

Staff with permissions can reorder parts when needed. Below is a step by step guide to follow when re- ordering parts. 

Tip: Use the quick filters to locate existing information for Active, Inactive, Last 7 Days, Has Work Order.

  1. Login to ETMS and navigate to the Parts Ordering card or use the search to locate and open the card
  2. Press NEW ORDER
  3. Select Vendor from dropdown menu
  4. Select the Department
  5. Select Location
  6. Enter the Date Wanted
  7. Add Notes, optional field for use as preferred
  8. Add Line Item - Press button to add line item for existing parts in ETMS
    1. Or press NEW PART
      1. Pressing NEW PART takes you to Parts Inventory's screen to add the part. Review this article for more information about adding parts in ETMS:  Parts Inventory 
  9. Line # field is read only and displays ____________________________?
  10. Check the box to include a barcode label
  11. Stock box defaults to 'Yes' 
  12. Item Number- Use the menu to search for the parts you wish to order from the selected Vendor
  13. Item Description- will auto- populate based on part description included on part
  14. Enter Quantity
  15. Enter U/M (unit of measure)
  16. Enter Unit Cost/ doublecheck value to ensure accuracy
  17. Taxed? Check the box to indicate this
  18. Ext. Cost will auto-populate based on quantity
  19. Enter Vendor Item Number
  20. Vendor Item Description displays and is editable
  21. Work Order- Enter active work order, if attaching to existing WO
  22. Work Order Description - Will auto- populate based on description on WO
  23. Asset Type- Select from dropdown menu
  24. Asset Number - Use the menu to add the asset Id
  25. Asset Description based on asset number
  26. Press Add to save the request
  27. Or press Cancel to cancel the request

Parts Ordering Settings

The cog wheel on the Parts Ordering screen is used to review and ensure the Bill To and Ship To entries have been completed. Ordered placed without both these entries cannot be fulfilled. 

Did You Know

Stock parts carry their costs forward when used for work orders. Non-stock parts do not carry forward costs when used on work orders. Use manual reconciliation for including non-stock cost calculations.

Inventory Timing

Core updates on-hand quantities and costs synchronously as part of receiving. It does not wait for the legacy invoiced/pending status to be cleared by a nightly job or for a separate confirmation step. 

Related Articles & SOPS

Parts Inventory

Parts Inventory SOP 0027

Vendor Management

Vendor Management Card SOP 0028

Maintenance Issues - Vehicle Issues

Work Orders (Video) 

 

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!