TruckMate 2024.4 New Features: Back Office
General
Updated reason code logic (TM-137804)
The logic for reason codes has been improved for Customer Service, Dispatch, and Multi Mode Dispatch. The default reason code that appears is now the last code that was entered for the freight bill or trip.
The field stays blank if there was no previous reason code.
Prevent blank spaces in trace numbers (TM-174765)
When you copy and past trace numbers, blank spaces and unprintable characters are now automatically removed from the Trace Number field, Reference Qualifier field, and user fields before they are saved to the trace record.
Performance improvement to range-based account Charge Codes (TM-177114)
For client rating, the range-based account Charge Code allows you to set value ranges. It can also define specific ranges for clients, start and end zones, or even service levels. Because of this, a single code may have thousands of rules.
The logic for calculating range-based account charges has been optimized to filter irrelevant rules based on the freight bill’s information. It now only retrieves the applicable rules for calculation. This significantly improves system performance and saves substantial database resources.
Three main fields in the Accessorial Charges tab of Codes Maintenance will have performance improvements for client rating (freight bill charges):
-
Client ID
-
Start Zone
-
End Zone
Centralized accessorial validations (TM-166489)
Some of the validations used for checking accessorials that are added to carrier trips have been centralized.
Updated Trips API to use centralized validations (TM-177825)
Updated the Trips API to use the newly centralized validations when adding accessorials to a carrier trip.
Added Length to the Cost Rule dropdown list (TM-175583)
Added the ability to prorate the carrier cost using Length. It is now available as an option in the Cost Rule dropdown list.
Added ability to directly populate start_zone and end_zone via EDI (TM-178206)
Four new fields have been added to the EDIlink format in the 204 inbound map:
-
Start Zone
-
End Zone
-
PickupAt Zone
-
CareOf Zone
These fields, if populated with a value that is a valid TruckMate zone code, will override the existing methodology.
Billing Consolidation
Changes to freight bill consolidation (TM-172611)
Changes have been made to avoid situations where a consolidated master bill ends up having a delivery window that is earlier than the pick up window:
-
The consolidated master bill is marked as Don’t recalculate interliners/dates. This makes it so that the master bill does not have its dates recalculated by the service level matrix.
-
The Pick Up By end date and the Deliver By end dates are now the maximum of the dates from the bills it consolidates instead of the minimum.
Codes Maintenance
Added checklist item option (TM-178412)
The option Completion is mandatory before Freight Bill can be assigned or added to a Trip has been added to the Checklist Item Wizard.
For more information about this option, see Added support for mandatory checklist items (TM-178380).
Customer & Vendor Profiles
Customer Service and Multi Mode Dispatch
Added ability to require audit status code and reason code (TM-177021)
An option has been added to the Pickup/Delivery Appt security option called Audit Edits (Override Audit Code).
If this option is selected, a confirmation message opens when a user tries to:
-
Change the pickup or delivery date in Multi Mode Dispatch.
-
Select or clear the Appointment Req or Appointment Made checkbox in Multi Mode Dispatch or Customer Service.
The user then must provide a reason for the change and enter an Audit Status Code and a Reason Code. The reason code defaults to the last used reason code.
GL Journal Entries
Added Year End Entry field to import format (TM-171065)
The GL Journal Entries format now includes a Year End Entry field. This field is optional. The valid values for the field are True and False.
If the Year End Entry field is added, then it is expected that all records in the import file have that field.
Payroll Configuration and Payroll and Returns Generator
Added fields to support CPP2 and QPP2 amounts (TM-172694)
Fields have been added to Payroll Configuration and Payroll Returns Generator to support CPP2 and QPP2 values for T4 and RL-1 forms.
When you run the T4 wizard, you must now put the combined maximum earnings of both CPP and CPP2 in the Maximum amount of pensionable earnings field:
This is the amount you used to calculate your employee’s CPP/QPP and CPP2/QPP2 that you reported using box 16, box 16A, box 17, and box 17A, up to the additional maximum pensionable earnings for the year, even if you did not withold CPP/QPP or CPP2/QPP2 contributions on all or any of those earnings. In many cases, boxes 14 and 26 will be the same amount.
Rates Maintenance
Added staging tables for rate imports (TM-175073)
You can now load rating items into staging tables rather than directly into production tables. This lets you upload many rating records at once.
To minimize the effect of record locking and table locking on users, staging tables and stored procedures have been added. This moves the rating information from the staging tables to the production tables in more consumable pieces. The new tables provide staging for multi-point, multi-break, detention, and storage rate sheets.
There is no UI for this process. This process is done at the database level, such as through ODBC or JDBC types of drivers.
Here is an overview of the process:
-
Manually insert the new rate header data into the staging tables.
-
Run the procedure to move the headers from staging into production to get real header rating IDs.
These will have initial effective dates of "1/1/3000" to exclude them from active rating.
-
Manually insert the detail data into staging while incorporating the real header rating IDs.
-
Run the procedure to move the detail data from staging into production.
-
Update the real effective/expiry dates to make the rate sheets available.
Additional processes include:
-
Mass expiry of rate sheets and/or detail data
-
Purging previous staging table data
-
An error log table
List of tables:
-
STAGING_IMPORT_DETENTION_CLIENTS
-
STAGING_IMPORT_DETENTION_EQCLASS
-
STAGING_IMPORT_DETENTION_FREE_TIME
-
STAGING_IMPORT_DETENTION_RATES
-
STAGING_IMPORT_DETENTION_SVCLEVEL
-
STAGING_IMPORT_RATE_HEADER
-
STAGING_IMPORT_RATE_HEADER_SVCLEVEL
-
STAGING_IMPORT_RATE_MP_MBP
-
STAGING_IMPORT_RATE_MP_MBP_BREAKS
-
STAGING_IMPORT_STORAGE_CLIENTS
-
STAGING_IMPORT_STORAGE_RATES
-
STAGING_IMPORT_STORAGE_SVCLEVEL
-
STAGING_MESSAGES
-
STAGING_MODIFY_RECORDS
List of procedures:
-
STAGING_EMPTY_TX_TABLES
-
STAGING_IMPORT_DETENTION_DETAILS
-
STAGING_IMPORT_DETENTION_RATE_HEADER
-
STAGING_IMPORT_FB_RATE_DETAILS
-
STAGING_IMPORT_FB_RATE_HEADERS
-
STAGING_IMPORT_FB_RATE_PROCESS_DETAILS
-
STAGING_IMPORT_STORAGE_DETAILS
-
STAGING_IMPORT_STORAGE_DETAILS2
-
STAGING_IMPORT_STORAGE_RATE_HEADERS
-
STAGING_MODIFY_RECORDS