2020.2

This section contains the following for the latest version:

  • 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 Trimble customer representative.

Warnings

Version warning

When you upgrade TMW Back Office, you must also upgrade TMW Operations and TMWSuite to the same version.

Social Security number encryption warning

Starting in 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 would 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 only be provided to a system administrator. That utility provides access to all highly sensitive data and should only be used in the explicit instance of needing to encrypt or decrypt the driver profile.

Invoice output configurations warning

Starting in 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.

Starting in V.2019.1, those two locations are no longer available. Now, you set up invoice output configurations in the Billing Output Configuration Folder. To access this window, go to
Tools > Setup > Billing Output Configuration.

Now, you can assign companies to invoice output configurations from either of these locations:

  • The Billing Output Configuration Folder

  • The Distribution Method section on the Distribution Info tab in the company profile

The upgrade script is designed to automatically import 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.

For information about setting up and using invoice output configurations, see the Configuring your invoice output topic.

Case sensitive passwords warning

Starting with V.17.50, the system treats all passwords as case sensitive. This includes existing passwords.

This change affects how you log in with an existing password:

  • If your password was created with [Misc]CaseSensitivePasswords=OFF in your TTS50, you must enter that password in all upper case characters.

  • If your password was created with [Misc]CaseSensitivePasswords=ON in your TTS50, you can enter that password as you originally recorded it (case sensitive).

Requirements

Before you begin installing TMW Back Office version 2020.2, check that you meet these requirements:

  • TMWSuite®
    You must be using TMWSuite V. 2020.2.

  • TMW Operations
    If you are using TMW Operations, your version of TMW Back Office must be the same as your version of TMW Operations.

  • Microsoft® .NET Framework
    .NET Framework 4.6.2 or later (full package not client)

    The framework must be installed on the TMW Back Office server, client, and administrator systems before you install TMW Back Office. If it is not present, the system displays an advisory message during the installation. Install the framework before running the application.

  • Internet Information Services (IIS) for Microsoft® Windows Server®

    IIS Microsoft Windows Server 2008 R2 or later

  • Microsoft® SQL Server®

    • Microsoft SQL Server 2012 or later

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

  • You must be logged into the system where you want to install TMW Back Office, and have administrator rights for that system.
    Like most applications, TMW Back Office can be installed locally on a user’s system. It is also possible to install TMW Back Office 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.

  • SQL Server System Administrator rights are necessary
    The installation of TMW Back Office includes the manual application of a SQL script to the TMWSuite database. You must have a SQL Server administrator login and password to apply it.

Enhancements

Microsoft® Dynamics GP

Rolling up distributions for cash receipts (NSUITE-207912)

Now, you can set up the Cash Receipts window to roll up distributions for items having the same GL account number and index into a single line for posting.

Profiles

Encrypting driver social security numbers (NSUITE-208468, NSUITE-209789)

Now, you can set up your system to encrypt driver Social Security numbers in the database as you record them in the driver profile.

In addition, you can use the Data Conversion Administration tool to encrypt/decrypt a group of Social Security numbers in your database.

Rating

Setting a blended minimum quantity (NSUITE-209642)

Individual billing rates allow you to set a minimum quantity. If an order is less than the minimum, the system creates an additional charge for the difference.

Now, the system allows you to set up a blended minimum quantity based on the combined quantity of multiple commodity classes.

For example, a fuel hauler might use a compartmented trailer to deliver two types of fuel, such as diesel and unleaded gasoline. That company could set up a blended minimum charge that is based on the combined quantity for the two commodities.

You set the blended minimum on the Bill To company’s profile.

Note: This feature is supported for Rate by Detail orders.

Recurring adjustments

Setting an effective date for reopened adjustments (NSUITE-208477)

If you need to suspend processing of a recurring adjustment, you can cancel it or put it on hold. To resume processing of the adjustment, you click Reopen Adjustment.

In previous versions, the system set the recurring adjustment’s effective date to the date you reopened it. Now, when you reopen a recurring adjustment, you can manually set an effective date.

Third party pay

Including accessorial revenue when calculating third party pay (NSUITE-207721)

The Third Party Pay feature calculates pay for third party entities, such as agents.

In previous version, it calculated third party pay by subtracting the carrier pay from the line haul revenue and then multiplying the resulting sum by an agreed upon percentage.

{third party pay = (line haul revenue - carrier pay) x third party percentage}

Now, you can set up the system to include accessorial revenue in the calculation.

{third party pay = (line haul revenue + accessorial revenue - carrier pay) x third party percentage}

On each accessorial charge type you specify whether its charges should be included/excluded in the calculation.

Resolved Issues

Imaging

  • NSUITE-209447
    The Microdea Imaging control was upgraded to support viewing documents using the Microdea Synergize Explorer web site

Invoicing

  • NSUITE-207096
    When you copied the miscellaneous invoice attached to a master bill, the system incorrectly copied the master bill number to the new invoice.

  • NSUITE-208392
    The system was not e-mailing invoices. It could not decrypt the SMTP password.

  • NSUITE-209511
    When you had [Invoice]InvoiceSuffixPrefix=NUMERICSUFFIX set, the system was not sequencing Miscellaneous Invoice numbers correctly.

  • NSUITE-209626
    In the Print Invoices queue, pressing SPACEBAR caused an error. This happened when selecting or clearing rows in the queue.

Microsoft® Dynamics GP

  • NSUITE-207870
    When you transferred a Pay To profile that was set up with a factor company, the system did not add the factor data to the Vendor card.

  • NSUITE-208387
    The system was creating a separate Batch number for each transaction you entered during a single session in the Cash Receipts window.

  • NSUITE-208388
    A date error occurred when you posted cash receipts.

  • NSUITE-208389
    When you entered a write off amount in the Cash Receipts window, the journal entry created in Dynamics GP was incorrect.
    The Credit to Accounts Receivable account showed only the credit for the cash portion. It did not show the write off amount.

Profiles

  • NSUITE-207261
    The system was not allowing you to hide the Pay Schedule tab in the resource profiles.

  • NSUITE-209415
    Editing information on the Company Profile window’s Distribution Info tab caused performance issues. This happened when you made entries in the Distribution Method section.

Recurring Adjustments

  • NSUITE-207806
    When you filtered rows in the Recurring Adjustment Assign Asset window, the system was not showing information correctly.

Settlements

  • NSUITE-209886
    The [Dispatch]BlockEditLevelAfterStl=LEG setting was not working. When the first trip segment of a split trip was settled, the system would not let you edit the second trip segment.

Systemwide

  • NSUITE-209454
    There was a long delay when opening trips.

  • NSUITE-209588
    For security issues we updated the Bouncy Castle Java library to the latest version.
    Note: Bouncy Castle is a collection of APIs used in cryptography.

Trip Settlements Folder

  • NSUITE-207759
    The Restriction window in the Trips Ready to Settle queue was taking a long time to open.

  • NSUITE-207583
    The system was not displaying all trip segments for Turnpike Double trips.