TMWSuite 2019 release notes
These release notes contain the following information for each version:
-
System requirements
-
Enhancements (new or updated features)
-
Resolved issues (application improvements)
We have updated our company name and logo to the Trimble brand.
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
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.
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.
|
2019.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, and SQL Server 2016 are supported. Trimble Transportation recommends using the latest service pack of whichever version you use.
-
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
EDI
Specifying the number of EDI 214 records to process (PB-200708)
Previously, when an EDI Scheduler job started, the batch included all 214 records in the database. For very high volume clients, batches could be too large to complete before the job timed out. This caused changes to records to revert, which produced failed records. Failed records were put back in the queue for the next batch.
Now you can set the number of records to be included in a batch. This eliminates an ever-increasing backlog and allows records to be processed in a timely manner.
Resolved issues
EDI
-
PB-200668
Rounding calculation for Multicurrency transfer to Dynamics GP was off by $.02. This caused a balancing issue when the entry was posted in Dynamics GP.
-
PB-200753
On outbound 204 EDI orders, the flat file output included reference numbers attached to order headers having a reftablekey value of 0 (zero). Now the system only includes reference numbers for stops on the leg where the ord_hdrnumber is greater than 0 (zero).
Final Settlements
-
PB-200741
In previous versions, when adding a non-leg-based pay detail, such as vacation pay, the system would not pull rates defined by resource ID.
-
PB-200757
After reopening a settlement in previous versions, the system was not retrieving the pay details correctly in a new pay period.
Freight Board
TSI-217
Freight Board Interface supports receiving the available date and time from the Dispatch system. However, the Create Posting tab allowed only the available date to be entered. Now you can enter the time when you enter the date.
Fuel Import
TSI-215/TS-214
If you had [FuelServ]ProcessEFSRejectedTransactions=Y
in your INI file, the interactive EFS integration performed the pulling and processing of transaction records. The table used to store transactions must be seeded, that is, has at least one record. If there were no records, the system used a default start date, such as 1/1/2000, to pull rejected transactions. This could cause too much data to be returned, resulting in timeouts.
Invoicing
-
PB-200102
Resolved a problem that occurred when you had [Invoice]RebillFromOrder=Y set in your TTS50 and were creating a credit memo/rebill for an invoice with a manually recorded line haul charge.
-
PB-200558
We fixed an issue that was causing the Output Configuration Maintenance window to error out and close.
Microsoft® Dynamics GP integration
-
PB-200747
The AR Export function was creating out of balance General Ledger entries when:
-
An invoice is in US$, which triggers multicurrency/exchange rate entries in GP
-
An invoice contains a negative invoice detail, such as a currency surcharge
-
The charge type used for the negative invoice detail had the same GL account as any of the positive invoice details
Note: These criteria applied even when multicurrency was not a factor.
-
-
PB-200746
When the system is set up to automatically apply credit memos, it applies the credit memo to the original invoice. This clears the invoice from the Bill To’s open aging report and shows both items with $0 remaining open.
However, the system is not updating all amount fields in the data transferred to Microsoft Dynamics GP. This results in Aging reports showing the original invoice as unpaid, even though the Amount Remaining is set to $0 during the Apply process.
Rating
PB-200779
Increased rating engine performance by adding the rate’s start date and end date to the search.
System Administration
PB-200730
In previous versions, there was an issue causing row level security to be ignored when row level security was set up for ord_revtype1 and the trip had an empty stop for the first stop.
Settlements
PB-200641
Fixed an issue that was preventing the system from logging the deletion of pay details in the paydetailaudit table consistently
System Updates
PB-200685
Fixed an issue where expiration listings prevented associated tractors from appearing in drop-down lists.
System wide
PB-200755
In previous versions, the system displayed a detailed error message when an incorrect entry was made during the log into TMWSuite or into the PowerSuite Administrator Login window.
Now, for security reasons, the system shows just a generic message.
When the error happens while logging into the PowerSuite Administrator Login window, the system logs the error to an error log in the database.
The PowerSuite Administrator Login window is used to edit users in System Administration. |
Trip Settlements
PB-200385
Fixed an issue that was causing the system to calculate the currency conversion every time the row was edited, even for non-currency related edits.
TruETA Agent
-
NSUITE-207953
Fixed a problem that was causing the TruETA Agent to not update the legheader ETA Status value correctly.
-
NSUITE-208020
In previous versions, the system was displaying a Not Responding message while it was processing trips. This caused confusion for users. Now, the system displays a progress message while processing trips, so that clients will know the system is working.
-
NSUITE-208203
Fixed a time stamp error that occurred on the UpdateTripStatus call. The system now applies UTC time rather than the local time for the tractor’s location.
-
NSUITE-208310
For proper sequencing, check calls sent to TruETA now include time stamps. These time stamps include the time zone offset as well.
2019.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, and SQL Server 2016 are supported. Trimble Transportation recommends using the latest service pack of whichever version you use.
-
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
Application
Changed the trc-transponder column so that it allows up to 50 characters (PB-200659, PB-200661, PB-200693, PB-200694, PB-200695)
Previously, the trc_transponder column in the TMWSuite database supported 17 characters. Now, it supports up to 50 characters. Update all windows, fields, and SQL tables related to this enhancement.
Database
-
Changed the trc_transponder column so that it allows up to 50 characters (PB-200659)
Previously, the trc_transponder column in the TMWSuite database supported 17 characters. Now, it supports up to 50 characters.
-
SQL changes related to the trc_transponder column update (PB-200661)
Updated 5 Microsoft® SQL stored procedures in conjunction with the changes related to the trc_transponder column update.
File Maintenance
Updated the Transponder ID field so that it allows up to50 characters (PB-200660)
Previously, the Transponder ID field in the Additional Tractor Information window allowed you to enter up to 17 characters. If you entered more than 17 characters, the system displayed an error message and would not save your changes.
In File Maintenance, you can load this window by opening the Tractor Profile and then clicking on >> next to the VIN field. |
Now, you can enter up to 50 characters in this field.
Resolved issues
Database
TSI-239
Fixed an issue where Inbound 204’s would take several minutes to import causing Microsoft® Windows to display the "Application is not responding" error message. However, the application was still running. This message caused users to force-close the application. Users would reboot their machines and try to load the Inbound 204’s again. This could cause 204’s to be lost or duplicated.
Dedicated Billing
PB-200701
Replaced the missing custom code in the Dedicated Billing (PB) procedure. This procedure added an ALL type to the Invoice Splitgroup that allows multiple split groups to pull into a dedicated bill.
EDI
-
PB-200634
Fixed an issue where Outbound 204’s were not indexing correctly. This caused the system to lock up or freeze.
-
PB-200664
Fixed an issue where the EDI 214 window was displaying a drop event before a pickup event when there was no drop event.
-
PB-200702
Fixed an issue where EDI 210’s were listing accessorial charges before linehaul charges. This caused the system to reject the EDI 210’s.
-
TSI-293 and TSI-297
Fixed an issue with incoming EDI 204’s that required you to create a new company using the Company Matching window
Previously, the system would not match the newly created company with the EDI 204 row. Now, the system matches the newly created company to the EDI 204 row.
Note: This issue affected EDI 204’s that contained row-level security.
-
TSI-320
Improved Planning Worksheet performance related to retrieving data on the EDI tab.
-
TSI-321/TSI-193
Improved Data Exchange performance related to creating 990s from 204s.
Fuel Import
PB-200331
Fixed an issue where certain transactions were not being labeled correctly during the Fuel Import process.
Load Requirements
PB-200629
When customers had more than one load requirement placed on an order, they were unable to modify or delete the load requirements in TMWSuite. This issue has been resolved.
Settlements
-
PB-2
Fixed issue that was erroneously deleting intercompany charges when processing pay in the Trip Settlements Folder.
-
PB-200689
Fixed an issue where carrier settlements in the A/P Export window were combining pay details for split trips. Now the pay details are listed as separate line items.
2019.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, and SQL Server 2016 are supported. Trimble Transportation recommends using the latest service pack of whichever version you use.
-
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
Add-Ins
TMWSuite Fuel Import can access the .NET UI (TSI-18)
Previously, users could not access the Fuel Import feature through the .NET add-ins. This required the user to use the TMWSuite windows when using the Fuel Import feature. Now, users can access the Fuel Import feature using the .NET Add-Ins. Now TMWSuite will display this window the same as in TWM Operations.
EDI
Inbound 214s populate the ckc_tractor field
Previously, inbound 214 check calls did not populate the ckc_tractor field. Added functionality so if a tractor was already assigned to a leg, the inbound check call for 214s populates the ckc_tractor column.
Fuel Import
New setup to determine pay detail creation during fuel import (TSI-18)
TMWSuite uses a new method to determine paydetail creation during fuel import.
Mileage
New classifications for ALK’s HazMat module (PB-200535)
Clients using ALK’s HazMat add-on module in conjunction with PC*MILER can create routes and calculate mileages based on hazardous material classifications.
In previous versions, the ALKHazLevel label provided four classifications as system codes:
-
General hazardous material
-
Explosives
-
Inhalants
-
Radioactive material
Now, the system provides two more system code options:
-
Flammable
-
Corrosive
In previous versions, you could set up these two additional options manually. |
Resolved issues
Common dispatch features
PB-200539
Fixed problem in Dispatch Advantage that was preventing assignment of a resource with a Key Date (Priority 2) expiration.
EDI
-
PB-200482
The lat/long output in outbound 214s was not being presented in a consistent way.
-
When the 214 was sent as a result of an arrival or departure, it would have a leading zero.
-
When it was triggered as the result of a location report (X6), it did not have a leading zero.
This resulted in mapping failures. The lat/long output will now be presented in a consistent way regardless of the trigger of the 214.
-
-
TSI-87
Fixed an issue where users were receiving a GEH error when the in bound 204 process would update an EDI-created order with dx_processed=Done.
-
TSI-169
Fixed an issue where an inbound X6 with GPS coordinates was failing to import correctly. This caused the system to not create check calls.
Expirations
PB-200161
Fixed problem that was causing an error message when creating an In-Service expiration for a new tractor. This was happening only after you first saved a non-dispatch expiration for a new driver, and then tried saving the In-Service expiration.
Final Settlements
-
PB-200479
Client was having an issue where the enhanced tax line would show in the user interface but was not being saved to the database.
-
PB-200485
When you had
Settlement]FinalStlmntDetailGrid=Y
in your TTS50, the system would not allow you to Close a settlement that included a pay detail for Enhanced Taxes. -
PB-200557
Under certain circumstances, the system was duplicating pay header numbers.
Fuel Import
PB-200493 (Comdata)
Fixed an issue where rebates/discounts for Canadian purchases were passing the incorrect value during the US dollars to Canadian dollars transition.
Invoicing
PB-200355
Fixed an issue that was causing duplicate minimum charges when re-computing an invoice with Fix All set.
Microsoft® Dynamics GP integration
-
PB-200408
The ten-key entry was not working in the Cash Receipts window.
-
PB-200458
TMWSuite AP export was not retrieving settlements that were not linked to an order.
-
PB-200459
Fixed an issue that was causing the AP Export window to retrieve the same settlement number multiple times.
-
PB-200461
For negative invoice details, the AR Export was doubling the debit to sales. This was causing out of balance GL entries.
-
PB-200509
Fixed an issue that was causing properties to display in error in the A/P Export Status grid when you had
[Accounting]CarrierByOrder=1
and transfer by order selected. -
PB-200529, PB-200554, PB-200562
Fixed an issue causing an error whenever you attempted to save a new invoice that was set to Ready To Print. The error was due to the system making unwanted attempts to connect to GP.
-
PB-200531
When applying cash receipts in TMWSuite for transfer to Dynamics GP, we had issues where the system was not pulling the AR account from the invoice to which the cash was being applied.
-
PB-200568, PB-200578, PB-200579
Fixed an error that was being produced in the Payroll Export window.
-
PB-200581, PB-200580, PB-200573
Fixed an error that was being produced in the AP Export Process
-
PB-200599
The Auto Apply of Credit Memo to GP process was applying the credit memo incompletely.
Mileage
PB-200611
Fixed issue that was causing TMWSuite’s AddIns to ignore mileage through buckets greater than 99.
Planning Worksheet
-
PB-200513
Fixed an issue that was causing Master Orders and Quotes to be listed on the Planning Worksheet.
-
PB-200583
The Trc Trp Comments column was not retaining the entered comments upon save.
Rating
-
PB-200445
Fixed the rating engine to ignore duplicate stops only when they are sequential.
-
PB-200508
An error message was displaying when attempting to define a customized rate index hierarchy.
-
PB-200566
The custom stored procedure sp_ChargeTypeBasisUnitRuleBillToMileAll was causing an error when computing charges.
System wide
PB-200124
Add these capabilities to the SMTP Emailing functionality:
-
Specify the port used by the SMTP server
-
Specify the user name and password to the SMTP server
Trip Folder
PB-200239
The system was preventing the reassignment of a carrier on a split trip when pay details existed for a resource on a different trip segment.
2019.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®
Microsoft SQL Server 2012, SQL Server 2014, and SQL Server 2016 are supported. Trimble Transportation recommends using the latest service pack of whichever version you use.
-
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
Invoicing
PB-200251
Electronic Data Interchange (EDI) allows you to send and receive documents electronically.
When setting up a Bill To company for EDI, you must specify how the system outputs the company’s invoices. You can specify that the system:
-
Prints a physical copy
-
Sends a copy electronically as a EDI 210
-
Prints a physical copy and sends an electronic copy
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.
Resolved issues
Agent pay
PB-200371
Cannot compute pay in the Pay Detail Maintenance window. Added support for the [Settlement]DoActivityPayDetails
INI setting.
Invoicing
PB-200339
Date Invoices field on the Print Invoices Queue is not changing the bill date on the invoice. It does not update the date from the default date.
Microsoft® Dynamics GP integration
PB-200358
Client is unable to transfer invoices which contain a $0.00 freight invoice detail along with other charges.
Mileage interface
PB-200381
The Route Mileage Inquiry window was not recalculating the mileage after the first location was changed.
Trip Settlements Folder
-
PB-200240
Memory leaks cause Trips Ready to Settle queue to crash when processing large number of records.
-
PB-200310
When total pay is calculated from a secondary tariff with multiple indices and the matching index is not the first, the total pay calculation can improperly exclude invoice line item based pay.
Trip Folder
-
PB-200159
Mileage table on order header not getting set correctly on Bill To change.
-
PB-200429
Adding two splits to a trip at the same time and attempting to save corrupts the order and crashes the application.
-
PB-200503
When calculating pay for Driver 2, the system was not passing branch information to the rating engine.