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

As of version 2019.4, you can disable SSL for your SMTP email feature.

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.

2021.4.15.186 Service Pack

Resolved issue

ALK Maps

TTESUITE-202894

When viewing a driver’s route on the ALK Map in the Trip Folder Check Calls tab, the plot line did not display the check calls. This happened when using:

  • ALK Web version

  • PC Miler version 29 and up

  • [TmwSuiteAddins]EnableMapping=Y in the TTS50

2021.4.12.0027 Service Pack

Resolved issue

Invoicing

TTESUITE-203607

The functionality to split an invoice was not working properly. This is used to create multiple invoices for an order.

In TMWSuite you set this in File Maintenance > Company Profile > Extra Info. This is available if the Extra Information feature is activated.

In TMW Operations you set this in Tools > Tools Maintenance > Bill To Relations in the Invoice Options tab.

2021.4

General requirements

Before you begin installing TMWSuite version 2021, 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.

  • .NET Framework 4.6.2 or later

  • 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

Settlements

Overriding pay in the Trips Ready to Settle queue (TTESUITE-200518)

The [Settlement]PayExistBeforeQueue setting determines how the Trips Ready to Settle queue:

  • Processes pay when line haul pay (primary pay) for that resource/trip combination already exists

  • Updates the paid status for the resource’s asset assignment record

The setting now has a new option: Override. When you use this option and a trip with pay is run through the queue, the system:

  • Removes primary and secondary pay and recomputes them

  • Retains line item pay details with their quantity, but it sets the rate to zero, then it recomputes the pay

  • Retains all imported or manually added pay details

  • Sets the status of the resource’s asset assignment record to Prepared

Although this setting focuses primarily on the Trips Ready to Settle queue, it also affects trips processed in the Trip Settlements Folder. When you try to reprocess pay for a trip there, the system displays a message. It states, "It looks like Line Haul pay has already been computed. Select:

  • "Yes" to add new item(s) for Line Haul pay

  • "No" to find rates only for lines where rate is now zero

  • "Override" for the override feature

    Note: To use this option, you must have [Settlement]PayexistbeforeQueue=Override in your TTS50.

Resolved issues

Dispatch

TTESUITE-60099

If you had the Trip Folder open in the Dispatch application, it could lose focus and close. This happened if:

  • It was behind another open window or folder

    and

  • You right-clicked anywhere in the Trip Header section

Microsoft Dynamics GP integration

  • TTESUITE-60159

    You can set up Payment Terms as End of Month (EOM) plus a number of days. You do this setup in Dynamics GP. When you transferred invoices, the invoice due date was set to EOM. If you had set it up with the additional days, they were ignored.

  • TTESUITE-200578

    You could not transfer Accounts Receivable or Accounts Payable records to Dynamics GP. The transfer produced "Account not found" errors. This happened if you used fewer than eight columns for your account segments setup.

Profiles

TTESUITE-60160

In driver rofiles, you can enter a driver name that is greater than 15 characters. In trailer profiles, you can enter an ID that is up to eight characters and an ILT SCAC ID up to four characters.

In the Cash Card Maintenance window, errors occurred when:

  • The Driver ID was greater than 15 characters

  • The Trailer ID was combined with the ILT SCAC ID to form an ID greater than eight characters.

Invoicing

TTESUITE-60049

Sometimes, the Invoices on Hold queue did not use invoice validation correctly. This happened only when both these things were true:

Rating

  • TTESUITE-201480

    When using incremental rate tables for Stop pay, the system was incorrectly counting the number of pickup stops. This caused it to select the wrong rate from the table.

  • TTESUITE-160905

    Sometimes, the system did not allocate Percent of Revenue pay correctly for split trips. This happened when the rate used mileage-based allocation. The system did not use the correct mileage buckets.

  • TTESUITE-200143

    When a minimum charge was applied by the primary rate, secondary percent of revenue rates were calculated incorrectly. The secondary rate was not including the minimum charge.

Settlements

  • TTESUITE-50870

    When a trip is billed incorrectly, the system lets you create a credit memo in the Invoicing application. The system can be set up to reverse the pay details associated with the invoice when the credit memo is saved. After the order is rebilled, you can recalculate the pay in the Trip Settlement Folder.

The system incorrectly reversed pay details that had both its:

  • Basis set to Ancillary

  • Unit Basis set to Line Haul

It used the new quantity on the rebill to update the old pay detail. It should have used the rebill quantity for the new pay detail.

  • TTESUITE-60120

    An error occurred when the system converted date/time data from a character string. This was caused by a rounding error. The error was linked to two settlement sheets and a stored procedure for paperwork tracking.

Trip Settlements

TTESUITE-60144

When computing pay, Settlements was changing the BCST (Billable Customs Stop) event from loaded to empty. This caused the loaded miles to switch to empty miles and the empty miles were computed instead.

This occurred only in limited circumstances when both the following were true:

  • The trip was split

  • The BCST event was not on the trip segment that contains the pickup stop

2021.3.23.43 Service Pack

Resolved issue

File Maintenance

TTESUITE-203206

When Trimble Places Integration was enabled, delays occurred when opening company profiles.

2021.3.2.38 Service Pack

Resolved issue

Dispatch

TTESUITE-60137

System error occurs when opening Trip Folder and Planning Worksheet with [TmwSuiteAddins]EnableInterface=N.

2021.3

General requirements

Before you begin installing TMWSuite version 2021, 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.

  • .NET Framework 4.6.2 or later

  • 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

WorkOptima Interface

Opening the WorkOptima window (TTESUITE-60149, TTESUITE-60141)

Now, you can set up your system to access the WorkOptima window from TMWSuite. From this window, you can search for documents associated with the order or the resource in view. You use Screen Designer to add a hyperlink that will launch WorkOptima from these locations:

  • Invoicing

  • Dispatch Trip Folder

  • File Maintenance profiles

    • Driver

    • Tractor

    • Trailer

    • Carrier

    • Company

    • Commodity

You must have a WorkOptima license.

Resolved issues

Advances/Misc Labor window

TTESUITE-60037

Pay details for carriers created in the Advances/Misc Labor window were always using the default currency. When a currency is recorded on the Pay To’s profile, the pay detail should use that currency.

File Maintenance

  • TTESUITE-60038

    In the Company profile, the Shipper list and Consignee list was not being updated correctly.

    The Shipper list and Consignee list records the shippers and consignees used by the selected company. The lists should be built dynamically as orders are completed.

  • TTESUITE-60132

    If you used a custom layout in the Safety Report, the window would become read only. To use the window, you had to reset the layout to the default.

Fuel Import

  • TTESUITE-70738

    An error was occurring when you saved the batch import. This happened when you had an invoice number that exceeded eight characters in the Truck Stop Invoice No. column.

    Now, up to 12 characters are allowed.

  • TTESUITE-200628

    If your fuel vendor is COMDATA, a hard coded Bank Identification Number (BIN) prevented you from transferring ONROAD cards from one driver to another. The original driver remained on the card.

Invoicing

TTESUITE-60157

The Distribution Method window was not showing all the invoice output configurations assigned to a Bill To company.

Microsoft Dynamics GP interface

  • TTESUITE-60096

    When transferring multicurrency invoices from TMWSuite to Dynamics GP, a rounding error caused amounts in the invoice balance to be off by a penny. This also showed in the Allocate Invoice window in TMWSuite.

  • TTESUITE-60100

    You could not transfer Pay To profiles to Dynamics GP as vendors. The transfer failed if the Pay To profile’s PayTo Misc 4 field entry was greater than 21 characters.

  • TTESUITE-200035

    TMWSuite’s Microsoft Dynamics GP integration lets you process cash receipts in the Invoicing application. When you do, cash receipt records are created in Dynamics GP. If you were also using Multi-Entity Management (MEM) for Dynamics GP, cash receipt records were not created. No message appeared stating that the process was not successful. This happened because the integration could not insert a NULL value in a field required by MEM.

Multi-Entity Management is a third party add-on to Dynamics GP. It lets you treat multiple legal entities as a single company.

Notes

  • TTESUITE-50889

    Certain order-based notes entered in TMW Operations were not showing in TMWSuite’s Invoicing application. This was happening when the note’s text was entered in the TextLarge field.

  • TTESUITE-60024

    An error message was displaying when you applied a filter in the Notes window in Settlements.

  • TTESUITE-60082

    There was a performance issue when you saved new orders in Order Entry or Dispatch. The issue happened if you had [Misc]CopyCompanyNotestoOrder=Y in your TTS50.

Settlements

TTESUITE-60223

In certain instances, the Settlement Detail Summary report was not using the resource restrictions to filter the details retrieved. This was happening only when all the following were true:

  • The pay details were not associated with a trip.

  • [Settlement]UseResourceTypeOnTrip=Y was set.

  • The report was run by Item Type.

  • A resource type restriction was used, such as DrvType1.

Trimble Places

TTESUITE-160806

When you were creating a new company, the Create Company with Trimble Place Link window was not opening.

Trip Folder

  • TTESUITE-60137

    A system error occurred when opening the Trip Folder. This happened when you had:

  • [Dispatch]LTSLNewSetup=N

  • TTESUITE-60114

    When you changed the stop on an order to a different company, an error would occur when saving the order. If you tried to open the same order in Order Entry an error message stated, "There are no commodity rows found."

2021.2.1.1099 Service Pack

Resolved issue

Trimble Places

TTESUITE-201363

Trimble Places integration caused a long delay when you retrieved a company profile in File Maintenance.

2021.2

General requirements

Before you begin installing TMWSuite version 2021, 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.

  • .NET Framework 4.6.2 or later

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

Resolved issues

eManifest

TSI-849

For a multi-crossing ACE trip, all consignee companies appeared on the Company tab. This error happened if the origin and final stop were at the same location or in the same country.

File Maintenance

TTESUITE-60077

After you created a new Dedicated Billing Schedule and closed the window, the transaction in SQL would continue in the database. The schedule would also build a large number of blank rows with 00/00/0000 in the Dates tab.

Final Settlements

PBNEW-185

When a Fuel Purchase pay detail is added, Final Settlements creates a tax pay detail.

When this happened for a deduction, the pyd_minus was not set correctly.

This caused the header deduction totals to not include the tax detail’s value.

Fuel Import

  • PB-201102

    Using [FuelServ]AlwaysChargeAdvanceToVendor=Y caused an error. The system sent two different Microsoft Dynamics GP vouchers to the vendor. One amount would also be out of balance.

  • PB-201103

    Some EFS transactions had the tractor fuel amount missing from the distribution.

  • PB-201113

    Processing fuel transactions to Microsoft Dynamics GP took a long time. This happened only in the 2018.4 version.

Invoicing

  • PBNEW-89

    The system was allowing you to assign disabled invoice output configurations in the Distribution Method window. It should have only allowed you to assign configurations that had the Enabled checkbox selected in the Billing Output window.

  • PBNEW-136

    The system was not setting the Pay Leg in the Invoice Details window.

  • PBNEW-125

    Printing a rebill for a supplemental invoice was not producing the EDI 210 output.

  • PBNEW-159

    You can specify unique reference number formats for Bill To companies.

    Previously, you could save a format with a NULL value in the Attach To field. A NULL value in this field caused the system to skip the Reference number validation process.

Rating

  • PBNEW-173

    Users could not open the Edit Billing Rate Schedule Folder when the RatewareXL General Info Table setting was turned on. It caused an application error.

  • PBNEW-200

    The system was returning an error when the RatewareXL interface was active. The library path for Dispatch project needed to be updated.

  • PBNEW-212

    Sometimes the system pulled the wrong fuel price rates. This happened only with rate tables containing a large number of rates.

Settlements

  • PBNEW-88, TTESUITE-60220

    You could not save a pay detail in the Advances/Misc Labor window without making an additional change to the pay detail. This was happening when the pay detail was based on a pay type that had a quantity greater than zero.

  • PBNEW-194, PB-201107

    Users were able to Release trips in the Trips on Hold queue without recording the Carrier Invoice Number and Date. This did not affect the manual process of Releasing trips.

2021.1.1.2019 Service Pack

Resolved issue

Planning Worksheet

TTESUITE-203021

For consolidated orders, older versions of TMWSuite handled redelivery dates differently in the outbound view. With newer versions, the minimum date in the Date Promised column was incorrect.

This SQL code resolves the issue.

update @ttbl1
set ord_datepromised = (select min (ord_datepromised)
FROM orderheader (nolock) join stops on stops.ord_hdrnumber = orderheader.ord_hdrnumber
where t.mov_number = stops.mov_number)
FROM @ttbl1 t

2021.1.1.2017 Service Pack

Resolved issue

Order Entry

TTESUITE-205038

Hyperlinks on invoice headers now work as expected.

2021.1.1.2016 Service Pack

Resolved issue

Dispatch-Planning Worksheet

TTESUITE-203772

You can modify the grid in the Planning Worksheet and save the configuration for future use.

The system was not allowing you to add a new column to a saved configuration. This should be allowed.

2021.1.1.27 Service Pack

Resolved issues

Planning Worksheet

TTESUITE-202959

The ord_count field was calculating the number of billable stops. It should calculate the number of consolidated orders.

2021.1

General requirements

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

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

  • .NET Framework 4.6.1 or later

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.

+

  • .NET Framework 4.6.2 or later

  • 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

Company profiles

Trimble Places (NSUITE-209541)

The Trimble Places feature in TMWSuite integrates company location data in the TMWSuite database with Trimble Place data compiled by Trimble MAPS. This provides a centralized collection point for customer addresses.

Dispatch

Trimble Dispatch Advisor (PBNEW-100)

The Trimble Dispatch Advisor (TDA) is a load-planning aid. TDA will recommend the drivers and tractors that are a better match for specific loads. TDA exists in TMW Operations. This enhancement makes TDA functionality available in TMWSuite’s Planning Worksheet via the TMWSuite Add-Ins interface.

Fuel Import

Setting up the system to create truck stop profiles from imported transactions (PBNEW-151)

Before, when you imported transaction records that include a new truck stop, an error would occur. The record would show on the Error tab. You could not process the transaction until you created a profile for the truck stop.

Now, you can set up the system to create preliminary profiles for new truck stops when you import transactions. To do so, enter Y in the String1 field of the FuelCreateTSOnFileOpen General Info Table setting.

Microsoft® Dynamics GP integration

New tax type option for 1099-NEC (NSUITE-210479)

Payments to Pay To’s are reported to the IRS on 1099 forms. For the 2020 tax year, the IRS added the 1099-NEC form to report nonemployee compensation. Previously, you reported nonemployee compensation on the 1099-MISC form.

To support the new 1099-NEC form, the Nonemployee Compensation option was added in the 1099 Type field in the Pay To profile. The system passes the Nonemployee Compensation designation to Microsoft Dynamics GP when you transfer the Pay To’s information. It is saved in the Tax Type field in the Vendor Maintenance Options window.

In TMWSuite, you pay a nonemployee resource as an accounts payable entity. Accounts payable entities must be linked to a Pay To profile for payment.

Order Entry

New restriction field (PBNEW-140)

Order Entry’s Batch Rating window contains a new restriction field for Parent ID.

Batch Rating window enhancements for master orders (PBNEW-139, PBNEW-165)

The Batch Rating window allows you to retrieve a group of orders for rating.

There are two enhancements for processing master orders in the Batch Rating window:

  • A setup option that allows users to edit the Ship Date on Master orders

  • Additional data for master orders is listed in the batch log shown at the end of the queue process.

    The log now shows the tariff number, charge type description, and charge amount for each primary and accessorial rate applied to the master order.

  • When you edit the Ship Date of the first master order listed in the queue, a message displays when you tab out of the field. You can specify whether you want the new ship date to cascade to all the master orders in the queue.

Systemwide

A visual indicator for applications built with PowerBuilder 2019 (PBNEW-155)

Starting in version 2020.4, TMWSuite applications are built on PowerBuilder 2019.

Now, a red asterisk displays in the About window for TMWSuite applications built with PowerBuilder 2019. The asterisk displays next to the Application Version.

You access the About window from any TMWSuite application by selecting Help > About.
Providing telemetry data for application version (PBNEW-127)

The system now logs the version number of the TMWSuite application. It logs version data for System Administration, File Maintenance, Rate Schedules, Order Entry, Dispatch, Invoicing, and Settlements.

Resolved issues

EDI

PB-201087

Completion of IBMT event was not triggering the EDI 214 to be sent.

Expirations

PBNEW-168

The Driver/Equipment Status (expiration) window was displaying incorrect expiration types, including:

  • Retired expiration types

  • Expiration types not appropriate for the selected asset type

Fuel Import

TSI-723

Logic checking for duplicate rebates did not include the policy number. The system was only looking for:

  • Chain Code

  • Rebate Amount

  • Fuel Type

  • Rate Unit

This meant that it did not find duplicate rebates for another policy.

Invoicing

  • PBNEW-132

    The system was not creating invoice numbers as expected.

    This was occurring when you had these two INI settings set:

  • PBNEW-148

    An error was occurring when saving an invoice. This happened when the ord_subcompany field on the order contained more than six characters. We fixed the problem by expanding the ivh_company field on the invoice to allow eight characters. Now, this matches the size of the the ord_subcompany field on the order.

Microsoft® Dynamics GP integration

PBNEW-171

Master bills were not transferring to Dynamics GP correctly. This occurred when the invoice used GL Reset rules based on driver triggers.

Settlements

  • PBNEW-92

    The sort order in the Pay Entry Window was affecting how pay was calculated.

  • PBNEW-119

    The system was not computing pay for the secondary driver. This occurred when the secondary driver was assigned to a terminal but was not assigned to any DrvType1-4 restrictions.

  • PBNEW-124

    When you manually added pay for a secondary driver on the Profit and Loss tab in TMW Operations, the TMWSuite Settlements application assigned the pay to the primary driver. This happened when you had [Settlement]ShowTeam=Y set in the TTS50.