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.
|
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:
-
You had
[Tariff]SetBillToPartyOnSecondaryFromTariff=No
in your TTS50. -
The validation procedure you use was based on the invoice being set to Ready to Print
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.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:
-
TMWSuite Addins and LTSL EDI Service installed
-
-
[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
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