2022.1

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.

Service pack(s) available: 2022.1.13.192

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

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

  • 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

Invoicing

Accrual Rebates (TTESUITE-201927)

Now, you can set up secondary billing rates that generate accrual rebate details automatically.

These rates are designed to accrue or collect values based on a specified item. For example, you could use one to create a rebate based on the number of times a Bill To company was billed in the current year.

The rating engine creates the accrual rebate detail when a user-specified charge is invoiced. However, this detail is not included on the invoice. Instead, it is held in a new window named Accrual Invoicing.

In the Accrual Invoicing window, you manually select the accrual rebate details to be processed. The processed details are added to a Miscellaneous invoice for the Bill To company.

You can set up the rebate as a single amount or as a table of rates.

Four Row/Column options were added for rate tables:

  • # of x Billed (YTD)
    Number of times billed year to date
    This option accrues the number of invoices that contain one or more of a specified charge type.

  • # of x Charged (YTD)
    Number of times charged year to date
    This option accrues the number of times one or more specified charge types were invoiced.

  • Invoice Count (YTD)
    This option accrues the number of primary invoices created for a Bill To company in the year to date.

  • KPI (YTD)
    This option calculates a KPI that tracks the timeliness of deliveries for a Bill To in the year to date.

  • OD Mileage (YTD)
    This option accrues the number of origin to destination miles billed to a Bill To company in the year to date.

System Administration

Extending Row Level Security to field options (TTESUITE-200685)

Row Level Security (RLS) lets you secure records. For example, security can be applied to records belonging to specific companies, divisions, or terminals. It limits access so that only users assigned to them retrieve their records. You do this by:

  • Identifying the tables and fields that would have security applied to them.

  • Specifying the field values associated with a user’s login.

This worked well when users retrieved records. However, when users created records such as orders or profiles, they could select any value in fields that have user-defined options. Their selections in these fields were not limited to what was defined for them when retrieving records. This meant that they could enter incorrect information accidentally. Once the record was saved, they could not access it to fix it.

Now, you can set up RLS to also use label security. Label security limits the options users can select in certain user-definable fields that have security applied to them.

Once you assign individual label options to a specified label key, only the groups or users assigned to the same label key value can see them in the user-defined field.

Notes:

  1. Row Level Security is a licensed add-on. In addition to the license, the RowSecurity General Info Table setting must have a String1 value of Y.

  2. In this release, the LTL Operations Module does not support extending RLS to filter field options in windows that are specific to LTL functionality. It does support it in profile and scroll windows that it shares with the TMW.Suite applications.

Resolved Issues

Invoicing

  • TTESUITE-201506
    Revenue-based accessorial rates were not calculated correctly. This happened only when a minimum line haul charge was included on an invoice.