Trucks page (Trucks): list, status filters, columns and Export

Every truck of your account in one table: who drives it, its dates, its status, its odometer and its costs. Use it to find a truck, see which trucks are out of service or need repair, check which inspections and registrations are about to expire, and export the list to Excel.

Who can do this: you need permission to view trucks. New truck only shows when your role allows creating trucks. Some columns can be hidden from some users.

Before you begin

• Add each truck with New truck. See Truck profile: Overview tab and New truck.
• The Driver number and Previous driver number columns come from your driver assignments.

Open the page

In the left menu, select Trucks.

The page has a New truck button (top right) and one table. The table has no search box and no row buttons: select a truck's Unit ID# to open its profile.

Filter by status

Above the table, a row of buttons shows how many trucks have each status. Select a button to show only those trucks, select it again to clear it, and select several to combine them. The page opens with Active selected, and Clear brings that back.

The buttons are On Order, Active, For Sale, Inactive, Out of Service, Needs Repair, Restricted Use, Marketing and On Hold.

How they combine:

• On Order, Active, For Sale, Inactive, Marketing and On Hold are statuses. If you select several, you see trucks with any of them.
• Out of Service, Needs Repair and Restricted Use are flags on a truck, not statuses. Each one you select narrows the list further. For example, Active with Out of Service shows trucks that are Active and flagged out of service. A flag selected on its own shows every truck with that flag, whatever its status.

The number on each button counts all of your account's trucks. It does not change when you use other filters.

OpenRoad remembers your filters, sort and columns in your browser, so the page opens the way you left it.

Filter by column

Each column header with a magnifier icon has a filter: a text box (matches part of the text), From and To boxes for numbers, a date range, or a drop-down. Yes/no columns have a Yes/No drop-down. Filters combine: a truck must match all of them.

Sort, page and totals

• The table is sorted by Vendor at first. Select a column header to sort by it.
• It shows 25 trucks per page. You can choose 10, 25, 50, 100, 250 or 500.
• Under the table, the pager says, for example, "1-25 of 40" and, when filters hide some trucks, the total in brackets.
• When a visible column holds money amounts (for example Cost, Monthly Payment or Insured value), the bottom of the table shows a Total row and an Average row. When there are more rows than fit on a page, they are worked out for the current page.

The columns

The table opens with these columns:

• Unit ID#: the truck number, as a link to the profile. A truck set up for slip seating shows "S-" before its number. Small icons before it show the flags that are set: OOS (red), Needs Repair (orange) and Restricted Use (purple).
• Vendor: the truck's company.
• Driver number: the drivers on the truck's current assignment, as links to the drivers (one for a normal truck, all for a slip-seating truck).
• Slip Seating, Year, Make, Vin.
• Licence plate (State): the plate and state, with a Temp badge when it is a temporary plate.
• Ann. Ins. Exp. Date: the annual inspection expiry date. The date is coloured when it is today or past (red), within 10 days (orange), or within 30 days (yellow). The Insurance Exp. and IRP Exp. columns are coloured the same way.
• Current Odometer.

Select Columns to show, hide, reorder and pin columns. In the Columns window, move columns between Available columns and Selected columns, then select Apply (at least one column must be selected). You can pin up to 4 columns. Reset brings back the default columns and order.

More than 150 other columns are available. They include:

• Vehicle details, such as the equipment type, brake type, tire inflation system and the slip-seating flag.
• Dates: acquisition, payment, lease, payoff and expiration dates.
• Ownership and money: Ownership Type, Cost, Monthly Payment, Interest, Lender, Insured value, insurance costs, End of Useful Life and Useful Life Left, and the computed Ownership Cost, Ownership Cost per Mile and Maintenance Cost per Mile.
• Mileage: Average miles per month (green up to 10,000, yellow up to 11,666, red above) and Estimated Miles At End Of Useful Life (green up to 480,000, yellow up to 560,000, red above).
• Status and repair: Status, the flags and their notes.
• GPS: the last address, coordinates and the time updated.
• Maintenance (latest service log): MAINT Status, MAINT TI, MAINT TO, MAINT ETI, MAINT ECT, MAINT TIS, MAINT Loc., MAINT TOS, MAINT Memo, and MAINT TTIS (total time in service across all service logs).
• Fleetrock: PM Status (Upcoming PM, Expired PM or Unclear PM), PM Days, PM Miles and PM Due Date.
• Assignments: Previous driver number, Previous Assignment Start Date and Previous Assignment End Date. A truck with a current assignment shows that assignment's dates in the two Previous Assignment columns, because an assignment with no end date is listed first.
• Primary safety manager and Accident Count.
• Selling and disposal: prices, dates, buyer details and listing links (Truckpaper, Facebook, Craigslist, Pictures).

The yes/no columns show a green tick for Yes and a red cross for No.

Export to Excel

• Excel exports the trucks on the current page.
• Export all exports every truck that matches your filters, in your sort order. It adds a last column, Actions, with a link to each truck.

Both export the columns you can see, in the order you see them, and keep your status buttons (so the default export is the Active trucks). The file is named "Trucks - OpenRoadTMS.xlsx". Dates are written as MM/DD/YYYY, and yes/no columns as Yes and No.

Frequently asked questions