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.

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, 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, 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, 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 check box 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, 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®