Canned Reports
This section contains samples of Canned Reports in Adobe Acrobat (PDF) format.
Application Security
These templates generate reports that contain TMWSuite menu items, user access details, and user groups.
| Report Name | Description |
|---|---|
Lists default values in the TMWSuite database. Note: This report runs with TMWSuite only. It does not work with TMW Operations. |
|
Lists all field level restrictions in your database. |
|
List of saved TMW Operations grid layouts and users with access |
|
List of saved TMW Operations screen layouts and users with access |
|
List of Report Library objects and users with access |
|
List of TMWSuite menu items and users with access |
|
List of TMWSuite modules and users with access |
|
List of TMWSuite users and groups |
Auto Hauler
These templates generate reports that contain vehicle damage information.
| Report Name | Description |
|---|---|
Letter to driver for damages responsibility |
|
Detailed report of vehicle damage |
Brokerage Reports
These templates generate reports that contain invoice and rating history.
| Report Name | Description |
|---|---|
Displays a list of carrier bids for an order over a period of time. |
|
Summary of carrier qualifications |
|
Summary of invoice and rating history by specific lane |
|
Displays a list of trip segments for a specific period of time grouped by executing terminal This report includes details, such as: Leg #, Order #, start/end dates, empty/loaded miles, revenue, net, margin, and revenue per mile. |
CRM Tasks Reports
These templates generate reports that contain activity details by user and by completed task.
| These templates require CRM Right installed to generate report data. |
| Report Name | Description |
|---|---|
Summary of activity details by user ID and activity type |
|
Summary of activity by user for completed tasks |
Database Reports
These templates generate reports that contain database information.
| Report Name | Description |
|---|---|
List of all databases on server |
|
List of all General Info Table (GIT) settings in the database This report displays the setting name, when it was added to the database, and the values. |
|
List of tables and sizes in one database |
DX - Data Exchange
These templates generate reports that contain data exceptions.
| Report Name | Description |
|---|---|
Data Exceptions written by data exchanged to the DX_Exceptions table |
|
EDI orders organized by status |
eManifest ACE ACI Reports
These templates generate reports that contain eManifest information.
| Report Name | Description |
|---|---|
Displays ACE Electronic Manifest barcode Includes the driver’s name, license plate number, trip number, and other information. Note: This is border crossing documentation. You must be licensed to use these features. |
|
Displays Lead Sheet barcode Includes the carrier code, trip number, ETA date, Port of Arrival, tractor and trailer license plate numbers, and other information. Note: This is border crossing documentation. You must be licensed to use these features. |
Fuel Dispatch Reports
These templates generate reports that contain scheduled drivers, orders by volume, and oil field readings.
| Report Name | Description |
|---|---|
Five-day planning board |
|
Delivered gallons over a period of time organized by tractor number and commodity |
|
Driver’s available days, unavailable days, trip count, trip time, logged hours, scheduled, and shift over a period of time Note: This report works with Fuel Dispatch databases only. |
|
Driver’s login and logout times on shift schedules organized by Driver ID |
|
List of drivers scheduled for a specific day |
|
List of drivers scheduled for week |
|
Oil field reading drop ticket that includes estimated barrels, truck number, lease number, and other information |
|
List of trips that contain more than one pickup event or drop event for a single trip over a period of time |
|
List of orders below target volume |
|
List of missing inventory readings by company |
|
Reject and Refusal Tickets [Reject and Refusal Tickets^] |
List of rejected fuel deliveries with reasons First available in Fuel Dispatch: 2018.3 |
Oil field readings run ticket, includes: company name, ticket number, tank number, hub reading, and other information |
|
Summary of oil field readings |
|
List of stops organized by shift |
|
List of tractor schedules |
Fuel Tax Mileage
These templates generate reports that contain fuel tax mileage information.
| To use this report, you must install and run the Fuel Tax Mileage WorkCycle feature. If you have questions about this feature, contact your Support representative. |
| Report Name | Description |
|---|---|
State mile totals and subtotals by tractor for a period of time Note: This report requires a WorkCycle process to complete. WorkCycle is a separately licensed module. |
Management Report Canned Reports
These templates generate reports that contain tractor, sales, and pay information.
| Sub folder | Report Name | Description |
|---|---|---|
File Maintenance |
Summary of all active tractors |
|
Summary of current, future, or past expirations |
||
Settlements |
Summary of pay for a specific driver or carrier over a period |
|
Summary of pay for a specific PayTo companies over a period |
||
Summary of pay for a specific tractor over a period |
||
List trip details, grouped by trip number |
||
Revenue Based Reports |
Summary of total revenue for a specific day This report contains:
|
|
General summary of revenue over a period of time |
||
Summary of revenue over a period of time for specific BillTo companies |
||
Analysis for a trip segment based on a specific tractor This report contains:
|
||
Summary of unbilled revenue for a specific date |
||
Resource Based |
Summary of empty, loaded, and total miles by driver |
Maps
These templates generate reports that display simple map information.
| Report Name | Description |
|---|---|
Displays one truck’s GPS location by date range |
|
Displays current tractor GPS locations |
|
Displays tractor GPS margins by origin state |
|
Displays the distance from the start of a trip to the nearest tractors |
|
Displays GPS history and a basic GPS map for a single truck over a period of time |
|
One Truck History (map only) |
Displays a basic GPS map for a single truck over a period of time |
Displays GPS locations, stop locations, and a basic GPS map for active tractors |
|
Tractor Positions (map only) |
Displays a basic GPS map for active tractors |
Microsoft Dynamics GP Reports
These templates generate reports that contain 401K records, cash receipts, deductions, and employee tax information.
| Report Name | Description |
|---|---|
Summary of 401(K) payment information |
|
Summary of average pay per employee ID This report contains:
|
|
Summary of cash receipts during a period of time |
|
Summary of payroll sorted by company category This report contains:
|
|
Summary of pay per employee class |
|
Summary of employee deductions over a period of time This report contains:
|
|
Summary of employee dependents and associated benefits |
|
Summary of all tax expenses |
|
Summary of gross wages per employee for a specific year |
|
This report lists all the employees missing from a payroll build that need added into the arrears transactions screen. |
|
Lists any employee missing a time card or recorded time |
|
Summary of pre-check totals This report contains:
|
|
Summary of account information for a specific year |
|
Summary of vacation pay for a specific employee |
|
Summary of work history for a specific employee |
Mileage Table
This template generates a report that displays mileage information based on trips.
| Report Name | Description |
|---|---|
Displays the following trip information:
|
Resource Analysis Reports
These templates generate reports that analyze assets or resource types.
| Report Name | Description |
|---|---|
Logs changes made to a list of orders |
|
Asset utilization (drivers, tractors, and/or trailers) over a period of time with percentages |
|
Displays asset start/end location inconsistencies |
|
Displays companies not used within the last number of months |
|
Lists companies within a user-defined distance of a primary company |
|
Expirations for non-termination, but dispatch effecting statuses in a calendar format |
|
Report that selects a random group of drivers and displays driver information, such as: birth date, hire date, driver ID, and other information |
|
Displays driver log hours by day, including days with missing logs |
|
Start/end location inconsistencies based on event |
|
List of potential backhaul trips for drivers, includes: start date, estimated hours, order number, and other information You enter a move number and use the Miles Radius slider to find orders available for backhaul. |
|
Displays the number of new hires, terminations, and the number of active drivers over a period of time |
|
Shows the last x commodities hauled on a specific trailer over a period of time Note: The x represent a user-defined value. |
|
Compares the number of orders that start in a region with the number of tractors that completed orders in the same region If you had ten (10) tractors that completed orders in the Northeast region and twelve (12) new orders in Northeast region, then your score would be two (2). Positive scores mean that you have more orders than trucks in that region. This report displays the results in a table and then it uses symbols to display the results on a map. |
|
Compares the number of orders that start in a ZIP Code with the number of tractors that completed orders in the same ZIP Code If you had ten (10) tractors that completed orders in a ZIP Code and twelve (12) new orders in that same ZIP Code, then your score would be two (2). Positive scores mean that you have more orders than trucks in that ZIP Code. This report displays the results in a table and then it uses ZIP Code Shapefiles to display the results on a map. Note: For this report to display the Shapefiles, you must run the AddTigerTableData.sql SQL script against your database. To obtain the file, contact your Trimble BI Support representative. Work with your company’s system administrator to apply the script. |
|
The Resource Mileage Trailer report shows a summary of empty, loaded, and total miles for each resource within a specified trip segment end date range. Miles are calculated for all moves, regardless of whether an order is attached. Breakdown is at stop level so switching trailers mid leg is supported. |
|
Summary of line haul revenue over the last 30 days |
|
Displays a year-over-year line haul revenue comparison |
Safety Reports
These templates generate reports that contain driver incident or accident safety information.
| Report Name | Description |
|---|---|
Displays a list of accidents |
|
Displays a driver’s safety record Note: The safety report contains links to a hidden safety detail report that shows detailed information about each safety report item. |
Tariffs
These templates generate reports that display billing and settlement tariff information.
| Report Name | Description |
|---|---|
Summary of individual billing tariff information |
|
Displays all billing tariff records |
|
Summary of individual settlement tariff information |
|
Displays all settlement tariff records |
TotalMail
These templates generate reports that display TotalMail communication information.
| Report Name | Description |
|---|---|
Summary of TotalMail errors |
|
Shows TotalMail errors for a period of time, grouped by general error description and showing error details |
|
Summary of all messages recorded for a specific period of time |
|
Summary of message delay between sending and receiving |
Trailer Location Reports
These templates generate reports that contain trailer location and company trailer locations.
| Report Name | Description |
|---|---|
Displays trailer locations |
|
Displays company trailer locations |
User-Defined Auditing
These templates generate reports that display user-defined auditing information. You must enable the User Defined Auditing application to use these reports. For details, see User Defined Auditing.
| Report Name | Description |
|---|---|
Displays general user-defined audit information |
|
Displays detailed user-defined audit information |
Workflow Checkup Reports
These templates generate reports that contain order status updates, trip revenue, and management information. System administrators run them against a test database to verify data accuracy.
| Report Name | Description |
|---|---|
Displays active assets without assignments for a selected number of days |
|
Displays expirations with a completion date over a selected number of hours |
|
Displays a summary of administration features, such as security, permissions, and freight boards |
|
Displays orders in a completed or cancelled billable status that have not been invoiced a certain number of days after delivery |
|
Displays completed trip segments not paid |
|
Displays orders not transferred after the bill date |
|
Displays pay not transferred after the pay period |
|
Displays late orders |
|
Lists orders by status |
|
Displays required paperwork that has not been received |
|
Displays completed segments not paid a number of days after the assignment end date |