2021.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.

A PDF of these release notes is available here.

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

  • TMWSuite®
    You must be using TMWSuite V. 2021.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 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, and SQL Server 2019 are certified for use with this application. 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

Driver Retention

Driver Retention enhancements (TTESUITE-200520)

Several changes have been made to the Driver Retention feature.

  • Replace the TIDv3 authorization and access token with the single TIDv4 access token

  • Use the TIDv4 access token for subsequent API method calls

  • Add the Consumer Secret field in the Driver Retention Configuration window.
    Now you can record the consumer secret value directly.
    Previously, you had to generate a Base64 value on the Base64 Encode site. The Base64 value was generated from the consumer key and secret.

Invoicing

Setting retrieval limits on the Billing Output Configuration Folder (TTESUITE-159347)

In the Billing Output Configuration Folder, you set up invoice outputs by:

  • Setting up the rules (configurations) that determine the type of output generated

  • Assigning them to one or more Bill To companies
    When you open the Billing Output Configuration Folder, the system retrieves all the companies assigned to a Billing Output Configuration.
    Before, you could see a performance issue when you opened the Billing Output Configuration Folder. This happened when a large number of companies were attached to the same configuration.
    Now, the system limits the retrieved companies to 1,000. You can change that limit using the [.NetMisc]ScrollRetrievalLimit INI setting. Sometimes the specified limit keeps you from viewing a particular company. When this happens, you can use the Restrict options on the Assign tab to change the number of companies retrieved.

Trimble Places

Saving custom places (TTESUITE-160657, TTESUITE-200433)

You link a company to a Trimble Place in the Create Company with Trimble Place Link window.

Previously, you could not create a link between a company and a place that did not have a Trimble Place ID. The Save button would have been inactive.

Now, you can create a link between a company and a place that does not have a Trimble Place ID. When you save the link, the window saves the ID in the CustomPlaceID column.

Resolved Issues

Final Settlements

  • TTESUITE-159163
    You could not delete certain pay details in the Final Settlements Folder. This happened when the pay was created by the escrow withdrawal process. The Delete Settled Pay button was not enabled.

  • TTESUITE-160887
    A rounding issue was causing an out of balance exception error. This was happening when the pay record’s status was set to Closed.

Invoicing

  • TTESUITE-153899
    When creating a Credit Memo and a Rebill simultaneously, the system was setting the focus on the original invoice when saving. It should have set the focus on the rebill invoice.

  • TTESUITE-159916
    The label file contains a predefined set of labels. Labels are associated with field names and options. Some labels allow you to assign names. The invoice Processing Queue was not displaying the user-defined names assigned in the label file. It was showing the default names instead.

  • TTESUITE-160835
    You assign invoice configurations in the Billing Output Configuration Folder window. The window was allowing you to assign configurations to non-Bill To companies. This should not be allowed.

Microsoft® Dynamics GP integration

  • TTESUITE-156206
    The Payroll Employee Export window was not reporting a validation error. This occurred when the Use Alternate ID option was set, but no Alternate ID was recorded.

  • TTESUITE-156208
    Two types of validation errors were not being reported when transferring records in the AR Export, AP Export, and Payroll Export windows. A validation error should have occurred when:

    • The Use Alternate ID option was set, but no Alternate ID was recorded.

    • The company or driver does not exist in the accounting system.

  • TTESUITE-158824
    Certain pay details were transferred to Dynamics GP with a Distribution Type of Cash instead of Purchases. This was happened when pay based on a negative pay type, such as Driver Advance, had a negative quantity assigned.

  • TTESUITE-160589
    The GL Reset rule for the Natural GL trigger was not being applied.

  • TTESUITE-160729
    Some invoices were being transferred to GP more than once. This was happening when users printed a Transferred invoice in the Print Invoices window and selected the Finalize Print? check box. This set the invoice status back to Printed, which allowed it to be transferred again. Now, when printing a Transferred invoice, the system will not set the status back to Printed.

Trimble Places

  • TTESUITE-160654
    Trimble Places was allowing you to link multiple companies to one Trimble Place. This should not be allowed.

  • TTESUITE-160655
    The Create Company with Trimble Place Link and the Link Company to Trimble Place windows were not showing all results retrieved by the Search API. It was showing only places that had a Trimble Place ID assigned.

  • TTESUITE-200225
    The typing speed in the Search field in the Create Company with Trimble Place Link window was affecting the number of places retrieved.