TMW Back Office
how to search

TMW Back Office

    • Logging in and out
    • Viewing system details
    • TMW Back Office video directory
    • Quick Start: How do I process an invoice?
    • Quick Start: How do I process pay for a trip?
    • Quick Start: How do I finalize pay for a resource?
    • Release notes
      • What’s new in 2025.3
      • 2025
        • 2025.2
        • 2025.1
      • 2024
        • 2024.7
        • 2024.6
        • 2024.5
        • 2024.4
        • 2024.3
        • 2024.2
        • 2024.1
      • 2023
        • 2023.6
        • 2023.5.13.99 Service Pack
        • 2023.5
        • 2023.4
        • 2023.3
        • 2023.2
        • 2023.1
      • 2022
        • 2022.4
        • 2022.3
        • 2022.2
        • 2022.1.13.192 Service Pack
        • 2022.1
      • 2021
        • 2021.4.26.202 Service Pack
        • 2021.4.15.16 Service Pack
        • 2021.4
        • 2021.3
        • 2021.2
        • 2021.1
      • 2020
        • 2020.4
        • 2020.3
        • 2020.2
        • 2020.1
    • Understanding basic window features
      • Choosing a window layout
      • Navigating within the application
      • Basic data entry
        • Using keyboard shortcuts
        • Accessing the mileage windows
    • Using data grids
      • Filtering data in a grid
      • Adding multiple filters to a grid
      • Working with columns
      • Grouping data in a grid
      • Copying column contents
      • Exporting data
      • Printing data
      • Saving or deleting a data grid layout
    • General system setup
      • Using the label file to customize fields
      • Applying security to grid/table rows
        • System setup
        • Defining a table’s security
        • Assigning security to a user or group
        • Enforcing security setup
        • Restricting access to field options
      • Encrypting Social Security numbers
      • Setting up unit conversions
      • Setting up currency conversions
      • Setting up your system for invoicing
        • Setting up charge types
        • Assigning invoice and master bill formats
        • Configuring invoice outputs
        • Setting up e-mail distribution for invoices
        • Setting up master bills
        • Automating toll cost billing
      • Setting up your system for settlements
        • Setting up pay types
        • Setting up pay schedules
        • Setting up guaranteed pay
        • Assigning settlement sheet formats
        • Setting up e-mail distribution for settlement sheets
      • Setting up a holiday schedule
      • Trimble Places
      • Setting up the No-Touch Processor
      • Setting up the Microsoft Dynamics GP Interface
        • Preliminary setup in TMWSuite
        • Working with company profiles
        • Setting up multi-currency features
    • Paperwork tracking
      • Setting up paperwork tracking
      • Checking in paperwork in Invoicing
      • Checking in paperwork in Settlements
      • Using paperwork status as a queue restriction
  • Invoicing
    • Introduction
    • Looking up orders and invoices
    • Processing a single order or invoice
      • Creating credit memos and rebills
      • Creating a split bill
      • Deleting invoice data
      • Creating additional or stand-alone invoices
    • Processing multiple orders and invoices
    • Processing accrual rebates
    • Master bills
    • Using Dedicated Billing
    • Trip Settlements Folder
      • Processing pay for a single trip
      • Processing pay for multiple trips
      • Correcting pay
    • Time Settlement Folder
      • Handling pay details from electronic or shift schedule logs
      • Handling pay details from hours of service data
    • Final Settlements Folder
      • Finalizing pay for a single asset
      • Finalizing pay for multiple assets
      • Printing settlement sheets
    • Processing Inbound EDI 210 invoices for carriers
    • Recurring adjustments
      • Setting up a pay type for a recurring adjustment
      • Setting up recurring adjustments
        • Recurring deductions
        • Recurring pay adjustments
        • Per diem adjustments
        • Recurring escrow adjustments
        • Recurring loan adjustments
      • Assigning recurring adjustments to an individual resource
      • Assigning recurring adjustments to a group of resources
      • Deleting or changing the status of a recurring adjustment
    • Tariff Maintenance
      • Creating a billing rate
      • Billing rate examples
        • Generating accrual rebates
        • Calculating detention charges automatically
      • Creating a pay rate
      • Pay rate examples
        • Setting up holiday pay
        • Setting up a Premium Day rate table for holiday pay
        • Setting up an Additional Earnings pay rate
        • Calculating detention pay automatically
      • Working with rate tables
      • Setting up rate keys
    • Engage.Bid Import
    • Notes
      • Setup for the Notes feature
      • Adding, changing, and deleting notes
      • Using the pop-up notes feature
      • Copying profile notes to orders
    • Driver profiles
      • Driver Profiles window overview
        • Header information
        • Information tab
        • Driver Management tab
      • Creating driver profiles
    • Company profiles
      • Using Trimble Places
      • Viewing average facility dwell times
    • Scroll records
      • General setup for scroll windows
        • Preventing users from exporting scroll data to Microsoft Excel
      • Branches
      • Carriers
      • Commodities
      • Companies
      • Drivers
      • Empty Moves
      • Expirations
      • Invoices
      • Orders
      • Passengers
      • Pay To
      • Reference Numbers
      • Stops
      • Third Party
      • Tractors
      • Trailers
      • Truck Stops
    • Using layouts to add security and control user actions
      • Changing menus and toolbars
      • Customizing menus
      • Customizing toolbars
      • Saving and deleting menus and toolbars
      • Changing a window layout
        • Basing a new layout on the factory default
        • Adding and removing fields
        • Applying security to fields
        • Using rules to restrict field values
        • Changing a field’s look or position
        • Controlling the tabbing sequence
        • Customizing detail tabs
      • Adding links, reports, and custom grids to a window
        • Adding hyperlinks and embedded webpages
        • Adding reports and embedded report viewers
        • Adding custom grids
        • Using parameters
      • Saving, loading, and resetting a window layout
      • Copying layouts from one database to another
      • Changing a data grid layout
      • Applying conditional formatting
        • Examples of conditional formatting
          • Highlighting specific entries in a column
          • Color-coding dispatch statuses
      • Applying conditional editing
      • Summarizing data in grids
      • Fixing views to include required columns
      • Assigning window and grid layouts
    • Determining point-to-point mileage
    • INI settings that are used by TMW Back Office
    • General Info Table settings that are used by TMW Back Office
  • TMW Back Office
  • Using layouts to add security and control user actions
  • Applying conditional formatting
  • Examples of conditional formatting

Examples of conditional formatting

The following examples provide some ways that you can use conditional formatting to enhance the appearance of data grids. You can also use formatting to call attention to data that meets specific criteria.

  • Highlighting specific entries in a column

  • Color-coding dispatch statuses

Applying conditional formatting Highlighting specific entries in a column
×
×