Setting up the system for brokerage

When you set up TMW Operations for brokering orders, the system uses the information you provide to calculate the most recent carrier pay information for specific carrier lanes. It also uses this information when calculating the difference between trip revenue and cost spread.

The setup procedures include:

  • Setting up the system to provide pay information

  • Setting up carrier lanes

Setting up the system to provide the latest carrier pay information

To ensure that the Company Carriers tab and the Payment History for Carrier window display the latest carrier pay information, you must schedule the load brokerage stored procedure.

Use Microsoft SQL Server Management Studio or SQL Server Enterprise Manager to set up a job to run the updatecarrierhist_sp stored procedure routinely.

When creating the job:

  • Run the exec updatecarrierhist_sp command.

  • Set the recurrence as Daily.

  1. You must manually run the stored procedure after installing TMW Operations and whenever you upgrade.

  2. Refer to your SQL Server Management Studio or SQL Server Enterprise Manager help system for instructions on creating a recurring job. If you need more assistance, contact your Trimble Support representative.

Setting a target profit percent

By default, the target profit percent is 15%. You can use the [Misc]BrokerPercent setting in your TTS50 to identify the percentage of profit you wish to make when you broker loads.

Working with pay types

In the Advanced Carrier Selection window, the carrier’s pay is a cost of hauling the load. The ACS window bases the calculation of these costs on pay types.

By default, the BRKLH pay type is used for line haul costs. If necessary, you can change the line haul pay type on an order-by-order basis. Additional settings in the [Dispatch] section of your TTS50 allow you to identify the default pay types for fuel and accessorial costs.

INI settings in the [Dispatch] section of your TTS50 identify the default pay types used by the Advanced Carrier Selection module. The system uses these pay types to create pay details for amounts you enter manually in the Linehaul, Fuel, and Accessorials fields in the Advanced Carrier Selection window’s Summary tab.

INI setting Description

[Dispatch]BrokerFuelCostPayType

Determines the default pay type for fuel pay details

[Dispatch]BrokerAccessorialCostPayType

Determines the default pay type for accessorial pay details