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:
- This workflow is a 'lite solution' intended for agencies not using Finance product suites.
- This 'lite solution' is not a replacement for a formal requisition and purchasing process when an agency requires broader procurement controls.
- 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.
- Enter Item Number
- Description will prepopulate (based on part entry information added in ETMS)
- Indicate quantity desired (ensure accuracy here, as associated costs for quantity are finalized at receiving)
- Indicate UOM
- Enter Unit Cost (ensure accuracy here, as costs are finalized at receiving)
- Check the box if taxable
- Extended cost populates
- Enter Vendor Item Number
- Vendor Item Description prepopulates
- Work Order- Use the dropdown menu to add the part order to an active work order for efficiency
- Work Order Id will prepopulate
- Select Asset Type (component, facility, vehicle, etc.)
- Asset Id prepopulates
- Asset Id Description prepopulates
- Notes- Optional field for additional information
- 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:
- Open the Settings Gear in Parts Ordering:
- Missing data should be added here and will be highlighted if missing.
- Press the 'edit pencil' to add missing information for a specific line item/ department.
- Use the built- in link ADD ADDRESS to open the window to add billing and shipping information:
- On the next screen add required entries: Name, Addresses, City, State, Zip, Phone Numbers, Phone Ext., Fax and Email
- 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:
- 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
- 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:
- Open an existing parts order- press directly on the record/ line item
- Press EDIT ORDER
- Open the line item to edit
- Adjust quantity if needed
- Adjust cost- if needed
- Enter Notes as preferred
- Press UPDATE
Cancel Order Not Received:
- Open an existing parts order- press directly on the record/ line item
- Press EDIT ORDER
- Press CANCEL
- Confirm action- Press YES
- 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.
- Navigate to the Parts Ordering Card- use the search to find it or open the Transit Assets Product Suite to locate the card
- Open an order that has arrived and is ready to be received
- 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:
- 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?
- Why: Received orders push costs forward and cannot be adjusted.
- Press RECEIVE ORDER
- Notice the ability to use the CANCEL ORDER and EDIT ORDER buttons are here?
- CANCEL ORDER- Did you receive the wrong items, or do you need to cancel the order entirely?
- EDIT ORDER- Used to edit an order not yet fulfilled
- The CANCEL button closes the receiving screen
- On the following screen enter quantity received
- Notice the RECEIVE ALL, BACKORDER ALL, and CANCEL ALL and ATTACHMENTS buttons display for use here
- Attachments can include invoices, etc.
- For partial receipts, determine if remainder should be backordered or canceled
- After entering value for goods received, the software auto-calculates remaining quantities
- Press BACKORDER to receive a partial shipment
- Notice the RECEIVE ALL, BACKORDER ALL, and CANCEL ALL and ATTACHMENTS buttons display for use here
Notice after pressing BACKORDER, the CONFIRM RECEIPT button becomes available for use and the BACKORDER button is highlighted (indicates it's active)
- Press CONFIRM RECEIPT to receive the goods.
- Confirmation popup- select YES to receive the order
- Associated costs are not editable after receiving a shipment
- Press NO to cancel the action
- Add any attachments required- invoices, etc.
- Software creates a PDF
- Locate PDF
- Can use the link that displays at the top of the screen when the download completes
- Or locate it in your computer's downloads
- Locate PDF
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."
- Paul creates a new vendor entry on the Vendor Management Card
- Melody creates the order on the Parts Inventory Card
- Janson approves the order by authorizing it
- 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
- Partial receipt- Miguel marks any remainder not yet received as back ordered or canceled
- 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
- 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.
- Login to ETMS and navigate to the Parts Ordering card or use the search to locate and open the card
- Press NEW ORDER
- Select Vendor from dropdown menu
- Select the Department
- Select Location
- Enter the Date Wanted
- Add Notes, optional field for use as preferred
- Add Line Item - Press button to add line item for existing parts in ETMS
-
Or press NEW PART
- 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
-
Or press NEW PART
- Line # field is read only and displays ____________________________?
- Check the box to include a barcode label
- Stock box defaults to 'Yes'
- Item Number- Use the menu to search for the parts you wish to order from the selected Vendor
- Item Description- will auto- populate based on part description included on part
- Enter Quantity
- Enter U/M (unit of measure)
- Enter Unit Cost/ doublecheck value to ensure accuracy
- Taxed? Check the box to indicate this
- Ext. Cost will auto-populate based on quantity
- Enter Vendor Item Number
- Vendor Item Description displays and is editable
- Work Order- Enter active work order, if attaching to existing WO
- Work Order Description - Will auto- populate based on description on WO
- Asset Type- Select from dropdown menu
- Asset Number - Use the menu to add the asset Id
- Asset Description based on asset number
- Press Add to save the request
- 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
Vendor Management Card SOP 0028
Maintenance Issues - Vehicle Issues