TMWSuite 2020 release notes

These release notes contain the following information:

  • System requirements

  • Enhancements (new or updated features)

  • Resolved issues (application improvements)

Before upgrading your production environment, Trimble recommends that you read the system requirements and install the latest version in a test environment. If you have questions, please contact your customer representative.

A PDF version of these release notes is available here.

Warnings

Installation directory

As of version 2020.4, you must install TMWSuite files into a new directory. Some files from earlier versions are not compatible with newer versions. If you need assistance, contact Trimble Transportation Support.

Social Security number encryption

As of version 2020.2, Social Security numbers you enter in the driver profile are encrypted in the database by default.

Having encrypted Social Security numbers could interfere with third-party applications accessing the data. This happens because the data is encrypted when transferred. The third-party application does not have the ability to decrypt it.

You can set up the system so that the Social Security numbers you enter in the driver profile are not encrypted in the database.

To do so, set the DataEncryption General Info Table setting’s String1 field to N.

The Data Conversion Administration Utility allows you to encrypt/decrypt a group of Social Security numbers in your database. Contact your Professional Services representative to obtain the DataConversionAdministrationUtilityInstall.msi.

Access and usage of the Data Conversion Administration Utility should be provided only to a system administrator. That utility provides access to highly sensitive data and should be used in the explicit instance of needing to encrypt or decrypt the driver profile.

SMTP e-mail port

As of version 2019.2, the setup for the SMTP e-mail feature has changed. You can now set these options in the SmtpEmailer General Info Table setting:

  • String1 = Identify your SMTP server

  • String3 = Identify your SMTP server username

  • String4 = Identify your SMTP server Password

  • Int1 = 587

  • Int2 = 465

This allows you to configure your system to use Secure Sockets Layer (SSL) for SMTP email.

Invoice output configurations

As of version 2019.1, there is a new procedure for setting up and assigning invoice output configurations for print and EDI.

In previous versions, you set up output configurations in the EDI 210 field or in the Advanced EDI Output Settings window in the company’s File Maintenance profile.

Now, those two locations are no longer available. Set up invoice output configurations in the Billing Output Configuration Folder. To access this window, go to Edit > Company Billing Output.

You can also assign invoice output configurations from either of these locations:

  • Billing Output Configuration Folder

  • The Distribution Method window in the company profile

    Note: To access this window, you must use Screen Designer to add the Invoice Output Method button to the company profile.

The new upgrade script automatically imports all the invoice output configurations you previously set up. You should not need to do any additional setup for your existing configurations. However, as with any major upgrade, we recommend that you verify the results after running the upgrade script.

PC*Miler warnings

Incompatibility with later PC*Miler|Mapping products

TMWSuite’s mapping feature works with PC*Miler|Mapping software to plot routes and symbols on a map.

To use these features in TMWSuite, you must use PC*Miler|Mapping version 31 or earlier.

Starting with PC*Miler version 32, ALK supports only ALK Maps for mapping. ALK Maps is a web-based, JavaScript API. TMWSuite does not support ALK Maps.

If you are using TMW.Suite Enterprise (TMW Operations, TMW Back Office, etc.) or another .NET product, you can use ALK Maps.

  1. In TMW.Suite, support for ALK Maps is free of charge. To use it, you need a unique API key value. Contact your Trimble support representative for more information.

  2. This change only affects the compatibility of ALK’s mapping features in TMWSuite. It does not affect the mileage features.

2020.4.1.2025 Service Pack

Enhancement

Extra Information window

Add the Extra Info window to TMW Operations (TTESUITE-202551)

In TMWSuite, system administrators can set up the Extra Information feature. You use this feature to store custom information in user-defined fields.

Previously, this feature was available only in TMWSuite. Now, you can access the Extra Information window from TMW Operations. The setup includes using QuickDesigner to add a hyperlink to one or more windows in TMW Operations. The link will launch the Extra Information window to view or edit data.

Data recorded in the Extra Information feature is informational only. It does not affect the functionality of the system.

2020.4.1.2024 Service Pack

Resolved issues

Rating

  • TTESUITE-201836

    On a pay rate, you use the Min Trip option to set a minimum total pay amount for a trip.

    The first time Settlements computed pay for a trip, it did not compute the minimum trip pay.

    This happened only when you had [Settlement]ShowTeam=Y set in your TTS50.

  • TTESUITE-202310

    Certain stop pay rates did not pull the correct dollar amount. This happened only with rate tables defined by both:

    • An incremental Rating Option

    • Rows and columns

2020.4.1.2021 Service Pack

Resolved issues

Settlements

  • TTESUITE-200584

In Settlements, an error message was displaying when you applied a filter in the Notes window.

Rating

  • TTESUITE-201563

    Specific rate tables were applying the wrong rate. This happened only with rate tables that were set up to use both:

    • Incremental rating

    • Two dimensions, both Rows and Columns

  • TTESUITE-201525

    The Driver/Equipment Status window did not show the correct Carrier expiration options. The Type field should have shown the entries made in the CarExp label.

Settlements

  • TTESUITE-201504

    The rating engine incorrectly created Invoice Line Item pay. It did this even when the accessorial was not billed.

    For the system to calculate pay using an Invoice Line Item secondary rate, the accessorial must be billed.

2020.4

General requirements

Before you begin installing TMWSuite, check that these requirements are met:

  • Internet Information Services (IIS) for Microsoft® Windows Server®
    IIS Microsoft Windows Server 2008 R2 or later

  • Microsoft® SQL Server®

    Microsoft SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 are supported. Trimble Transportation recommends using the latest service pack of whichever version you use.

  • Microsoft Visual C++ 2010 x 86 Redistributables

  • 32-bit SQL Native Client Drivers
    Version 10, 11, or MS OLE DB must match the drivers to your SQL version.

  • You must be logged into the system where you want to install TMWSuite and have administrator rights for that system.

    Like most applications, TMWSuite can be installed locally on a user’s system. It is also possible to install TMWSuite on a network drive. To do so, you must be logged into the system where the drive is physically located, and have administrator rights for that system.

Enhancements

General

Privacy Policy link added (PBNEW-104)

The Trimble Privacy Policy link has been added to all TMWSuite login windows. When you click the link, the Privacy Policy page opens in a web browser.

Rating

The Engage.Bid Import feature (PB-200875)

Engage.Bid is an online subscription product that allows trucking companies to process bids from shippers, also known as Requests for Proposals (RFPs).

When bids are accepted, you create billing rates for each lane contracted.

Now, the Engage.Bid Import feature allows you to create primary billing rates automatically when you import bid information into the rating engine.

Resolved issues

Credit Checking

PB-200711

You can use the [Misc]ForceOrderStatusWhenCreditCheckFails setting to specify the status the system assigns to a new order when the Bill To fails a credit check. Your entry must specify a non-dispatch status. The system was allowing users to override this setup and change the order status to Available.

Fuel Import

PB-201074

Clicking Validate GP on the GP Payables tab caused a database error. This happened when you were processing data that included a NULL GL number.

Rating

PB-200971

When rating an order, the primary billing rate was being overwritten with the secondary rate. This happened only when the secondary rate had a rate table met these criteria:

  • Used the Hi Rate All Combos option

  • Had a 0 (zero) rate in the first cell

2020.3

General requirements

Before you begin installing TMWSuite, check that these requirements are met:

  • Internet Information Services (IIS) for Microsoft® Windows Server®
    IIS Microsoft Windows Server 2008 R2 or later

  • Microsoft® SQL Server®

    Microsoft SQL Server 2012, SQL Server 2014, and SQL Server 2016 are supported. Trimble Transportation recommends using the latest service pack of whichever version you use.

  • Microsoft Visual C++ 2010 x 86 Redistributables

  • 32-bit SQL Native Client Drivers
    Version 10, 11, or MS OLE DB must match the drivers to your SQL version.

  • You must be logged into the system where you want to install TMWSuite and have administrator rights for that system.

    Like most applications, TMWSuite can be installed locally on a user’s system. It is also possible to install TMWSuite on a network drive. To do so, you must be logged into the system where the drive is physically located, and have administrator rights for that system.

Enhancements

Mapping

Support Web-based mapping via the Add-Ins interface (PB-200293, PB-200294, NSUITE-209839)

Now, you can use the TMW Add-Ins interface to set up your system for Web-based mapping. The Web-based mapping features are available in Dispatch, Order Entry, and File Maintenance.

Your system must be configured for either:

  • PCMiler 32 (or greater)

  • Web-based mapping

Settlements

Accessing the .NET Inbound EDI210 window (PB-200881)

An inbound EDI 210 file contains the charges sent by a carrier for services completed. You process payment for an EDI210 in the Trip Settlements Folder.

In version 2020.3, the Inbound EDI210 window was added to TMW Back Office. In this window, you can retrieve a list of 210’s. Then, you can either accept or reject individual 210’s for payment in Settlements.

Now, you can use the Add-Ins interface to set up your system to access this .NET window from Classic TMWSuite. Then you can process payment for the 210 in the Trip Settlements Folder.

You must have both:
Prevent deletion of pay details created by the EDI 210 process (PB-200959)

When pay is created by the EDI 210 process, now the system prevents you from deleting that pay in Trip Settlements or in Final Settlements. You can modify the pay details, but not delete them.

Resolved issues

EDI

PB-200978

The 214’s were failing when check calls were created without lat/long information. This happened because the system was pushing out the file mapping locations.

Microsoft Dynamics GP integration

  • PB-200684

    When transferring an invoice to Dynamics GP, the GL Reset Rule was reading DriverType data from the driver profile instead of from the trip. This occurred when there was only one leg.

  • PB-200968

    GP Payables did not correctly break out advances from Comdata/Pilot on Pilot Fuel transactions. When you sent three transactions to GP, only two were processed.

Rating

  • PB-200286

    The system was creating a detention charge even when the driver was late.

    This should not happen when you have Y in the String3 field of the TimeCalcDelayApplyAll General Info Table setting.

  • PB-200890

    The rating engine was rounding to four decimal places. This caused pay based on hundred weight rates to be rounded incorrectly.

  • PB-200923

    The system was not pulling the cell minimum charge. It was basing its calculation on origin/destination miles instead of trip miles.

  • PB-200940

    Previously, event-based table rates were applied incorrectly. The system was creating pay details even for events not recorded on the rate. It used the first rate in the table for the calculation.

  • PB-200943

    The system was applying zero dollar rates even when the Ignore Zero Rates check box was selected on the rate.

Systemwide

NSUITE-204430

There is now a performance improvement in place. It prevents the system from processing the same consolidated movement record multiple times.

2020.2

General requirements

Before you begin installing TMWSuite, check that these requirements are met:

  • Internet Information Services (IIS) for Microsoft® Windows Server®
    IIS Microsoft Windows Server 2008 R2 or later

  • Microsoft® SQL Server®

    Microsoft SQL Server 2012, SQL Server 2014, and SQL Server 2016 are supported. Trimble Transportation recommends using the latest service pack of whichever version you use.

  • Microsoft Visual C++ 2010 x 86 Redistributables

  • 32-bit SQL Native Client Drivers
    Version 10, 11, or MS OLE DB must match the drivers to your SQL version.

  • You must be logged into the system where you want to install TMWSuite and have administrator rights for that system.

    Like most applications, TMWSuite can be installed locally on a user’s system. It is also possible to install TMWSuite on a network drive. To do so, you must be logged into the system where the drive is physically located, and have administrator rights for that system.

Enhancements

EDI Scheduler

Two EDI Scheduler enhancements (PB-200922)

The EDI Scheduler now disconnects from the database when done processing, and it reconnects when the scheduled process starts again.

Now, you can set up the EDI Scheduler to send an email notification when it cannot connect to the database for processing.

You specify the email address(es) in the [Misc]EdiSchedulerMailList INI setting. You separate each email address with the pipe symbol "|" You must also place a pipe symbol at the end of the list.

For example:

[Misc]EdiSchedulerMailList=[email protected]|[email protected]|

Final Settlements

Calculating statutory holiday pay (PB-200899)

Canadian statutory holidays are public holidays for which all employees are entitled to the day off with pay.

TMWSuite’s Statutory Holiday Pay feature automatically calculates the amount of holiday pay due to a driver based on the driver’s recent earnings. Then during the Collect process, the system creates a flat pay detail for the holiday.

There are two calculation methods available. In the driver’s profile, you specify the method used, either:

  • Wages

    The holiday pay equals 1/20th of the driver’s last 4 weeks of earnings.

    Note: Twenty is the average number of weekdays in four weeks (4 x 5 = 20).

  • Commissions

    The holiday pay equals 1/60th of the driver’s last 12 weeks of earnings.

    Note: Sixty is the average number of weekdays in twelve weeks (12 x 5 = 60).

Profiles

Encrypting driver social security numbers (PB-200900)

Now, the system encrypts driver Social Security numbers in the database automatically as you record them in the driver profile.

In addition, you can use the Data Conversion Administration tool to encrypt or decrypt multiple existing Social Security numbers in your database at a time.

  1. Having encrypted Social Security numbers could interfere with third-party applications accessing the data. This happens because the data is encrypted when transferred. The third-party application does not have the ability to decrypt it.

    You can set up the system so that the Social Security numbers you enter in the driver profile are not encrypted in the database. To do so, set the DataEncryption General Info Table setting’s String1 field to N.

  2. To install the Data Conversion Administration tool, contact your support representative to obtain the DataConversionAdministrationUtilityInstall.msi.

    Access and usage of the Data Conversion Administration Utility should be provided only to a system administrator. That utility provides access to highly sensitive data and should be used in the explicit instance of needing to encrypt or decrypt the driver profile.

TruETAAgent

Actual Arrival and Departure times for completed stops now appear in the TruETA map (NSUITE-209861)

When recording a completed stop, TruETA Agent was not updating the actual time in the Arrival Date and Departure Date fields.

Now, the system updates the TruETA map with the updated Arrival Date and Departure Date times when you:

  1. Have a started trip in TMW Operations with a valid TruETA solution.

    Note: You have a valid TruETA solution when a map appears on the TruETA tab.

  2. Modify the Arrival Date and/or Departure Date on the Completed stop.

  3. Process TruETA for the trip without error.

Resolved issues

Common Dispatch features

  • PB-200787

    On Miscellaneous invoices, you were not allowed to save separate reference numbers on the invoice header and on the invoice detail.

    Editing a header reference number was overwriting the detail reference number and vice versa.

  • PB-200795

    Dispatch was allowing you to create pay details that were marked on the pay type as Display Only in Dispatch.

  • PB-200910

    The system was incorrectly cascading Trailer 3 to EBT stops.

  • PB-200932

    You were unable to add a pay detail in the Adv/Misc Labor window.

Fuel Import interface

PB-200876

The system was applying the currency conversion to the fuel purchase amount, but not to the rebate amount.

Invoicing

PB-200770

The system was not sequencing Miscellaneous Invoice numbers correctly. This occurred when you had [Invoice]InvoiceSuffixPrefix=NUMERICSUFFIX set.

Paperwork Tracking

  • PB-200375

    In previous versions, when you checked in paperwork for one trip segment of a split trip, the system allowed you to save the invoice with a Ready to Print status. This happened when you had PaperWorkCheckLevel=Order.

  • PB-200418

    When you checked in paperwork for an order on a consolidated trip, the system added it. However, if you unconsolidated that order from the trip, the paperwork was no longer checked in. This issue occurred when the PaperWorkCheckLevel String1 field was set to ORD in the General Info Table.

Pay Rates

  • PB-200065

    When you manually entered a CWT (hundred weight) rate that had more than two decimal places, the system was truncating the total when rounding.

  • PB-200423

    The Instant Best Match feature was limiting the number of characters entered in the MSTOrd# field. This field is in the Edit Settlements Rate Folder.

Profiles

PB-200736

In some circumstances, the system was displaying an error message when you opened a profile window. This happened when you opened a profile window after you opened an expiration window in the company profile.

Rating

PB-200894

The system was unable to rate a move after you changed an IEMT event to an IDMT event.

Settlements

PB-200879

The system was including time recorded for split trip events when it calculated hourly pay based on the Arrival and Departure times.

System Administration

PB-200498

The rate migration tool in System Administration was not working. It was unable to process rates in databases that contained new columns and tables.

TruETA Agent

NSUITE-209730

TruETA Agent sent PlannedDuration values on Completed stops. This led to errors when the actual Arrival Date or Departure Date fields changed.

Upgrade script

PB-200903

A SQL error was being received when upgrading from 2018.18_01.0192 to 2018.1.1.0276.

2020.1

General requirements

Before you begin installing TMWSuite, check that these requirements are met:

  • Internet Information Services (IIS) for Microsoft® Windows Server®
    IIS Microsoft Windows Server 2008 R2 or later

  • Microsoft® SQL Server®

    Microsoft SQL Server 2012, SQL Server 2014, and SQL Server 2016 are supported. Trimble Transportation recommends using the latest service pack of whichever version you use.

  • Microsoft Visual C++ 2010 x 86 Redistributables

  • 32-bit SQL Native Client Drivers
    Version 10, 11, or MS OLE DB must match the drivers to your SQL version.

  • You must be logged into the system where you want to install TMWSuite and have administrator rights for that system.

    Like most applications, TMWSuite can be installed locally on a user’s system. It is also possible to install TMWSuite on a network drive. To do so, you must be logged into the system where the drive is physically located, and have administrator rights for that system.

Enhancements

Mileage

Modify TMWSuite to support the ALK Web Address Validation function (PB-200289, PB-200792, NSUITE-207730)

You can use the Check Address feature in the company profile to verify the company’s address is valid.

In previous versions, you had to have ALK’s PC*MILER installed locally to use this feature.

Now, you can set up the Check Address feature to use the PC*MILER Web Services interface for address validation.

Resolved issues

Dispatch

PB-200379

The Intelligent Drop Down Data window feature caused Dispatch to lock up.

General system setup

PB-200724

Users were unable to save changes in the Define BackOffice Views window.

To access the Define BackOffice Views window, you must have the BackOfficeViews General Info Table setting String1 field set to Y.

Final Settlements Folder

PB-200756

The system was allowing two users to process the same settlement record, which would incorrectly create two pay headers for that record.

Microsoft Dynamics GP integration

PB-200697

Using Windows Authentication to access the accounting database caused login errors. This happened when the system was set up to get the Balance Due for an invoice.

Performance issues

PB-200780

A performance enhancement for slow processing in the invoicing print queues

Rating

PB-200729

The system was not finding the correct active rate, when applying a rate table that contained an expired rate.

Trip Folder

  • PB-200798

    An error occurred when a trip that included an IBMT > IEMT > EBT event was created.

  • PB-200778

    The system cascaded assets listed in the Trailer3 and Trailer4 fields to a BBT event when:

    Assets were assigned to the Trailer3 and Trailer4 fields.

    A BBT event was added after an LLD or LUL event.

Trip Settlements Folder

  • PB-200676

    When retrieving a Turnpike Doubles trip in the Trip Settlements Folder, the system was not displaying all legs.

  • PB-200752

    After computing pay in Trip Settlements and in the Pay Details window, duplicate pay details were shown. This was not affecting the actual pay.