2020.3

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.3, check that you meet these requirements:

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

  • 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

EDI

Processing EDI Inbound 210 invoices (TSI-473)

An Inbound 210 file contains the charges sent by a carrier for services completed. You process payment for an Inbound 210 in the Trip Settlements Folder. In version 2020.3, the Inbound EDI 210 Process window was added in TMW Back Office. In this window, you can retrieve a list of inbound 210’s. Then, you can specify which 210’s will be processed in Settlements.
Note: You must have the Brokerage EDI license.

Imaging

Retrieving master bills (NSUITE-206555)

Now, an imaging vendor can retrieve master bills from TMW Back Office.

Resolved Issues

Imaging

  • NSUITE-203666
    The image_invoicedata001_sp stored procedure was timing out when run in large databases.

Invoicing

  • NSUITE-208383
    Fixed performance for processing a credit memo and/or rebill for master bills that contain many invoices.

Microsoft® Dynamics GP

  • NSUITE-209962
    The Select All Rows check box in the Payroll Export window was not working.

Profiles

  • NSUITE-209963
    An error was occurring immediately upon opening any of the profiles in TMW Back Office when all the following were true:

    • You had [Misc]ApplyMenuLayoutWithoutSavedScreenLayout=Y set in your TTS50.

    • There was at least one screen-designed control on the form.

    • There were no menu layout changes associated with the selected screen layout.

Rating

  • NSUITE-209824 and NSUITE-210096
    Rates defined by Best Charge Method A were applying random rates.

  • NSUITE-209812
    Two-dimensional rate tables (rows and columns) set to apply incremental rates were pulling random rates.

Systemwide

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