Detail tabs: Dispatch, Driver Pay

yellowbox

This topic discusses the following tabs:

  • Dispatch

  • Driver Pay

Dispatch

The Dispatch Tab offers mainly summary information from the Dispatch program about the Freight Bill. There are some fields that can be set that will affect driver pay and contract billing.

image30

Dispatch Equipment Info

Field Definition

P.U. Driver

Enter the Driver Name here or use the search button to locate the Driver Name.

P.U. Tractor

Enter the Tractor Name here, or use the search button to locate the Tractor Name.

P.U. Trailer1/P.U. Trailer2

The user can enter 2 trailers for the pickup. First select the trailer number (1 or 2) from the drop down list and then enter the Trailer Name, or use the search button to locate the pickup Trailer Name.

Dlvry Trailer1/Dlvry Trailer2

The user can enter 2 trailers for the delivery. First select the trailer number (1 or 2) from the drop down list and then enter a trailer Name, or use the search button to locate the delivery Trailer Name.

Miscellaneous Info

Field Definition

Odom. Start / End

Enter your starting and ending odometer readings.

Lid Seal #

Enter the Lid Seal number here, if applicable.

Mt’d back to

Motored back to End Destination'. Select the appropriate ending destination.

Note: If you have a 'Terminal' zone entered in this field, the selected Freight Bill will show up in the Crossdock program. Likewise, If a 'Terminal' zone' isn’t entered, then the Freight Bill will not appear in Crossdock.

Tracing / Ref. Number

Field Definition

B/L#

Enter the Bill of Lading number here.

Cust. PO

Enter the customer PO number here.

Hand Tag

Enter the Hand Tag number here.

CW Load #

Enter the CW Load number here.

USP Seals

Enter the USP Seal number here, if applicable.

Pickup / Delivery Info

Field Definition

Appt

Enter the Appointment time.

Arrive

These two fields will display the data in the 'ACTUAL_PICKUP' and 'ACTUAL_DELIVERY' fields of the TLORDER TruckMate Table. These fields are automatically populated when the Freight Bill’s associated Trip goes through a certain Status code ('P' for Pickup and 'D' for Delivery).

Start / End

These date fields will display the same dates as entered in the Shipper and Consignee header sections of the Customer Service program.

Delay

Driver Pay

Field Definition

Load Time

Enter the time taken to load.

O/N Voucher

Enter any relevant voucher information here.

Pay Cleanout

Check either the 'Yes' or 'No' flag, depending on if the Driver requires Pay Cleanout or not.

Contract Billing Equipment

This section is used to bill a customer when they are not billed per Freight Bill, but rather rent a truck/trailer/driver by the hour. In order to use the information in this area, these settings must be used in the following areas:

  • Application Configurator:

    • RATES.EXE - Aggregate Rating must be set to 'False'.

    • RATES.EXE - Equipment Rating must be set to 'TLDTL'.

    • CONBILL.EXE - Add Odometer to R&M can be either 'True' or 'False'.

  • In the Rates Maintenance program > Rate Sheet Tab, select the 'Contract' sheet-type. Freight bills are created for each haul, and must be dispatched as well as completed.

  • In Customer Service, Dispatch Tab, the Equipment Classes are entered, along with a billing 'position', which is a field that can be used to keep billing batches separate.

  • In the Contract Billing program, these bills will show up on the entry Tab when the appropriate information is entered and the 'Find Bills' is refreshed.

Field Definition

Equipment 1 / Equipment 2 / Reefer

Enter an Equipment Class or Reefer class, or click the search button to bring up a pop-up search form where you can search by code or description.

Position

Used in conjunction with the Contract Billing program. When a new 'summarized' bill is created, the position that is used to group/consolidate the bills will be entered here by the program.

Driver Pay

When a driver who is paid by percentage of revenue on the Freight Bill (as configured in the Driver Pay Contracts program) is assigned to the Freight Bill (using the Quick Bill Entry program, the Local Dispatch program, or the Driver Pay Tab in the Customer Service program), automatically generated pay entries will be displayed on this Tab. Also if a driver is configured to be paid by mileage and is assigned to a Freight Bill (as described above) the pay entry will display here (but note that pay will only be calculated if a Mileage amount has been assigned to the Freight Bill in the Freight Bill header). Because percentage-based driver payments are correlated to the charges on a Freight Bill, only percentage pay items are shown here, not mileage pay items generated by the Dispatch program. You can also manually enter extra pay and deductions on this Tab.

Four additional sub-Tabs are available in the Driver Pay Tab. Their associated Keyboard Shortcuts are displayed on the Tabs next to their descriptions, when available.

Depending on a setting on the Security Setup program > Security > Business Events > Allow Changes Tab, the user may or may not be able to amend Driver Pay data once a Freight Bill is posted to the Billing Register.

Driver Deductions sub-tab

image31

Driver Deductions can be manually entered on this Tab. Note that you can only enter deductions for drivers who have an entry on the Pay Tab. The driver who is currently highlighted on the Pay Tab will by the default recipient of the deduction. This cannot be changed. All outstanding deduction entries for the driver highlighted on the Pay Tab will display in the grid. You can view deductions of all status types by selecting the checkboxes at the bottom of the Tab.

Approving Driver Deduction Records

You can set the status of a Driver Deduction entry (manual or automatic) to 'Approved' in the Driver Deduction Tab of the Customer Service program (depending on your security clearance on the Security Setup program > Security > Business Events > Misc > Customer Service Tab). Approving a Deduction entry allows it to be updated by the Driver Deduction Register program and included on a statement. Double-click on a pay entry to approve it. The entry will turn from black text to green text. For further information about the status color codes, refer to the Driver Pay Audit program documentation.

Users that do not have the appropriate security clearance to Approve records can still do other status changes on them, such as to the 'Owed' status.

Creating Advance Checks

image32 Selecting this button will open the Advance Check window, whcih allows the user to create an advance check for any Drivers that have been assigned to the Freight Bill.

image33

There are some restrictions when using this functionality:

  • The Freight Bill status must be at least 'Dispatched', and must not be 'Complete'.

  • The Driver ID has been assigned to the Freight Bill (i.e. the Driver will be visible on the Trip Resources Tab.

Once the check details have been populated by the user, the normal Crystal Report selection window will open, allowing the user to select a Crystal Report that will print the check. Posting of the Check Register program must still be done on a regular basis by head office staff.

The advance Deduction will not be taken from a Driver/Vendor statement if the Check Register has not been posted.
Field Definition

Driver

Select a Driver ID for the check. The Driver’s name and address will auto populate from the Driver Profiles program > Address Tab.

Note: Use the 'Check Name' field on the Driver Profiles program > Pay/Remuneration Tab if it should be different from the Driver’s name.

Bank Account

Choose one of the valid bank accounts that the user has been given access to be selecting the edit pick icon.

Check Number

Select the ellipsis button to open a small window that will default to the next available check number in the system. This value can be overridden, if desired.

Check Date

Enter the date of the advance or select the Calendar icon to choose a date from a calendar menu.

Deduction Code

Choose a Deduction Code from the Driver’s Contract that should be used to the advance check.

Amount

Enter the amount of the advance check. The amount the user can enter here may be restricted by the value entered by the administrator in the Security Setup program > Security > Business Events > Misc > Customer Service Tab > 'Max DP Advance Allowed' field.

Bill Number / Trip Number

These fields will automatically populate based on the Freight Bill / Trip information.

Filtering Options

Not Reviewed / Not Approved / Approved / Owed / Previous

You can set the status of a driver deduction entry to Approved in the Driver Pay Tab of the Customer Service program. Approving a pay entry allows it to be updated by the Driver Deduction Register program and included on a check. Normally, driver deduction entries are approved in the Driver Pay Audit program. Double-click on a deduction entry to approve it. The entry will turn from black text to green text.

The Driver records that can display/be added on this Tab are restricted by the Application Configurator program > CSERV.EXE > 'Display on Drv Ded Tab' option. If this option is set to 'Pay' then only Drivers that have Driver Pay records on the Driver Pay sub-Tab will display. If set to 'Trip' then only Drivers that have been assigned to Trips for the Freight Bill (visible on Trip Res’s Tab) can be added (including Trailers or Power Units that have a Driver ID attached to them (TRAILER.PAY_DRIVER, and PUNIT.PAY_DRIVER, respectively).

Additionally, only Driver Deduction Codes that have been flagged as 'Available in Customer Service' on the Driver Pay Contracts program > Deductions Tab will be available for selection.

Grid Fields

Field Definition

Driver ID

Will default to the driver record currently highlighted on the Driver Pay Tab. This cannot be changed.

Ded Code

Enter a Deduction Code as created in the Driver Pay Contracts program. Double-click for a selection form.

Deduction Description

Will default to the Description associated with the Deduction Code, as configured in the Driver Pay Contracts program.

Date

Will default to today’s date. You can manually enter a different date.

Quantity

Will default to '1'. You can change the value if you wish to deduct more than one instance of the Deduction code. The Functional Amount and Amount fields will recalculate by multiplying the value in this field by the value in the Rate field.

Rate

Will default to rate specified for the deduction code in the Driver Pay Contracts program. You can manually change the value. The Functional Amount and Amount fields will recalculate by multiplying the value in this field by the value in the Quantity field.

Amount

Will display the value of the Rate multiplied by the Quantity.

Functional Amount

Is a working field used for calculating the total pay. It will include foreign exchange amounts that are applied to the entry. It is a read-only field.

Currency Code

Will default to the currency specified in the Deduction code, as configured in the Driver Pay Contracts program.

SOURCE_REG_ACC

This field indicates which Register program the Driver Pay entry was posted in.

Trip Number

Will display Dispatch Trip Number that the Freight Bill was assigned to. Many of the advanced Driver Pay functions available via right-mouse click on this Tab require that a Trip Number (other than '0') be populated.

User1 - User3

These additional fields can be utilized for future business needs.

Context Menu

Driver Deduction

The user can use the 'Driver Deduction' right-click option on this Tab to post Driver Deduction entries while within the Customer Service program. Right-click to select the option on the Driver Deduction record and the Driver Deduction Register program will open, with the 'Trip Number' and 'Leg Date' fields populated form the Deduction detail record. The user can then select the 'Post' button to post all 'Approved' Deductions for the Trip.

This right-click option may not be available, depending on the settings of the Security Setup program > Security > Business Events > Misc > Customer Service Tab.

Driver Pay sub-tab

image34

Approving Driver Pay Records

You can set the status of a driver pay entry (manual or automatic) to 'Approved' in the Driver Pay Tab of the Customer Service program (depending on your security clearance on the Security Setup program > Security > Business Events > Misc > Customer Service Tab). Approving a pay entry allows it to be updated by the Driver Pay Register program and included on a statement. Normally, driver pay entries are approved in the Driver Pay Audit program. Double-click on a pay entry to approve it. The entry will turn from black text to green text. For further information about the status color codes, refer to the Driver Pay Audit program documentation.

Users that do not have the appropriate security clearance to Approve records can still do other status changes on them, such as to the 'Wait' status.
Field Definition

Pickup Drivers

If a Pickup Driver was assigned to the Freight Bill in the Local Dispatch program, Quick Bill Entry program or Dispatch program, that drivers code will display in this field. You can manually assign a driver to this field by clicking on the edit button in the main navigator bar, then entering the driver code in this field. Double click for a selection form.

The second Pick Up Driver field denotes the second Driver attached to a Freight Bill (i.e team Driver).

Delivery Drivers

If a Delivery Driver was assigned to the Freight Bill in the Local Dispatch program, Quick Bill Entry program or Dispatch program, that drivers code will display in this field. You can manually assign a driver to this field by clicking on the edit button in the main navigator bar, then entering the driver code in this field. Double click for a selection form.

The second Delivery Driver field denotes the second Driver attached to a Freight Bill (i.e team Driver).

Driver Pay Factor for % Rules

This field is a Factor Field, not a percentage field, and the 'Min' and 'Max' fields in the Driver Pay program have to agree. There are a number of ways to use this field but here are a few examples.

Let’s say you have three sites and you’ve labeled them as follows: 'Site 1' = Kelowna, 'Site 2' = Abbotsford, and 'Site 3' = Vancouver. You pay your drivers by percentage rules. If the site on the Freight Bill is 'Site 1' (Kelowna), you will pay 45% of the total charges to the driver. If the site is 'Site 2' (Abbotsford), then you pay your driver 50% of the total Freight Bill charges, and if the site is 'Site 3' (Vancouver), you will pay your driver 55% of the total Freight Bill charges. Your 'Min' and 'Max' factor for your first rule could be set at 1. Your 'Min' and 'Max' factor for your second rule could be set at 2, and your 'Min' and 'Max' factor for your first rule could be set at 3. Now, if the Freight Bill is created on 'Site 1', you would enter a '1' in the Driver Pay factor field, which would cause the first rule to be engaged and the Driver will be paid 45% of the total Freight Bill charges. If you feel you would use this option continuously, Contact TMW Support to discuss further, and a trigger could be developed where each time a Freight Bill is created, the system would check to see the site information entered, and add the appropriate 'Min/Max' factor that corresponds. You could also set up a situation where a driver may be paid different amounts depending on the pick up date.

Tarped

Place a checkmark in the box if this load must be covered by tarps. If you have also created a rule in Driver Pay Contracts where the tarp column appears as 'True', then the automatic pay system will match this checkbox with the Driver Pay Rule and create a pay amount for covering a load in tarps.

Note: It is a tremendous amount of physical work for a Driver to cover a load in tarps, and therefore the Driver will be paid extra for this job.

Recalc

The 'Recalc' button can be used to refresh Driver Pay amounts based on changes in other TruckMate applications (i.e. a Driver’s Pay Contract is updated/changed in the Driver Pay Contracts program).

Context Menu

These right-click options may not be available, depending on the settings of the Security Setup program > Security > Business Events > Misc > Customer Service Tab.

Driver Pay Register

The user can use the 'Driver Pay Register' right-click option on this Tab to post Driver Pay and Deduction entries while within the Customer Service program. Right-click to select the option on the Driver Pay record and the Driver Pay Register program will open, with the 'Trip Number' and 'Leg Date' fields auto-populated. Select the 'Post' button and all 'Approved' Driver Pay records for that Trip will be posted. After the Pay Register has completed, a confirmation box will pop up and ask if the user would then like to post Deductions. If the user selects 'Yes', the Driver Deduction Register program will also open with the 'Trip Number' and 'Leg Date' fields populated. The user can then select the 'Post' button a second time and all 'Approved' Deductions for the Trip will post.

Driver Pay Statements

Selecting this option will open the Driver Pay Statements program with the 'Trip Number' field automatically populated from the Driver Pay record, allowing you to print all Statements related to this entry quickly.

Pay Records Grid

Field Definition

Driver ID

For automatically generated percentage payments, the drivers code will display in this field. When you manually enter an Extra Payment for a driver, enter the drivers code (or double-click for a selection form)

Pay Code

When entering an Extra Payment, enter the Extra Pay code (as configured in the Driver Pay Contracts program). Double-click for a selection form.

Pay Description

In the case of an Extra Payment, this field will default to the Description associated with the Pay Code, as configured in the Driver Pay Contracts program. For automatically generated percentage payments, the description will be 'Paid by Percentage of Gross'.* *

Trip Num

For automatically generated percentage payments, the Trip Number to which the Freight Bill was assigned will be displayed. You can (optionally) manually enter a Trip Number, in the case of Extra Payments.

Leg Seq

For automatically generated percentage payments, the leg number from the trip to which the Freight Bill was assigned will be displayed. You can (optionally) manually enter a leg number, in the case of Extra Payments.

Trip Status

For automatically generated percentage payments, the current status of the trip to which the Freight Bill was assigned will be displayed. In the case of Extra Payments, this field will default to 'FINISHED'.

Trailer 1 / Trailer 2

For automatically generated percentage payments, the Trailer ID’s of the Trailers in the order they were assigned to the trip to which the Freight Bill was assigned will be displayed. In the case of Extra Payments, you can manually enter a value in this field.

Tarped

Modify this field in the Driver Pay Contracts program, Pickups and Drops Tab by double-clicking in the column to toggle the switch from 'False' to 'True. Either entry will appear in the Customer Service program, Driver Pay Tab. If you wish to mark this load as requiring tarps, place a checkmark in the 'Tarped' box appearing in the Customer Service program, Driver Pay Tab, if this load must be covered by tarps. If you have also created a rule in Driver Pay Contracts where the tarp column appears as 'True', then the automatic pay system will match this checkbox with the Driver Pay Rule and create a pay amount for covering a load in tarps.

Leg Date

For automatically generated percentage payments, the Leg Date associated with the leg number on the trip to which the Freight Bill was assigned will be displayed.

For manually entered payments, you can use the option in Application Configurator > Bill > CSERV.EXE - 'Default Leg Date to be used when user manually creates pay records in Driver Pay tab' to set a default value for this field. Available values for selection are 'Current Date' and 'Pick UP By'

From Zone

For automatically generated percentage payments, the From Zone on the trip leg to which the Freight Bill was assigned will be displayed. In the case of Extra Payments, the From Zone will be left blank. To enter a From Zone, double-click for a selection form.

To Zone

For automatically generated percentage payments, the To Zone on the trip leg to which the Freight Bill was assigned will be displayed. In the case of Extra Payments, the To Zone will be left blank. To enter a To Zone, double-click for a selection form.

F/B Charges

Displays the sum of the charges entered on the Details Tab.

Percentage

Displays the drivers pay percentage as configured in the Driver Pay Contracts program. This Percentage field in the Customer Service program, Driver Pay Tab, and the Minimum and Maximum Factor fields found in the Driver Pay Contracts program, Percentage Tab, must agree.

Loaded Miles / Loaded Rate / Empty Miles / Empty Rate / Hours / Hourly Rate / Picks / Pick Rate / Drops / Drop Rate / Layovers / Layover Rate

These fields are used for other types of driver pay, such as mileage pay and pick / drop pay. As the Driver Pay Tab in the Customer Service program only displays percentage payments, these fields are not used and no data will display.

As a default, only Pickup and Delivery drivers are included in the percentage calculations; Any other drivers are not included. This default calculation rule can be changed to include all drivers involved in the freight bill, even if they didn’t pick up or deliver. To do that you need to set the option in Application Configurator > Driver Pay > PAYCON.EXE - 'Calculate Freight Bill Based Driver Pay on Drivers Other Than Pickup/Delivery Drivers' to 'True'.

Other

In the case of Extra Payments, the value will default to '1' (ie: one instance of the Extra Payment will be paid). You can change the value if you wish to pay more than one instance of the Extra Pay code. The Functional Amount and Total Pay fields will recalculate by multiplying the value in this field by the Other Rate.

Other Rate

In the case of Extra Payments, the value will default to the rate specified for the extra pay code in the Driver Pay Contracts program. You can manually change the value. The Functional Amount and Total Pay fields will recalculate by multiplying the value in this field by the value in the Other field.

Total Amount

In the case of an Extra Payment, the Total Amount will default to the Rate associated with the Pay Code, as configured in the Driver Pay Contracts program.

For automatically generated percentage payments, the Total Amount will be the percentage paid to the driver (as configured in the Driver Pay Contracts program) multiplied by the sum of the charges entered on the Details Tab.

Functional Amount

Is a working field used for calculating the total pay. It will include foreign exchange amounts that are applied to the entry. It is a read-only field.

Currency Code

In the case of a manually entered Extra Pay entry, the currency will default to the currency specified in the Extra Pay code, as configured in the Driver Pay Contracts program. For automatically generated percentage payments, the currency field will be blank. The currency will be assigned to the pay entry based on the setup in the Driver Pay Contracts program when the entry is processed in the Driver Pay Audit program.

Gross FB Charges

This column will display the total Freight Bill charges less any Driver Deductions. This amount may vary depending on any preferences set up in the Interliner Tab in the Customer Service program. You can set this up as an automatic calculation by going to the Driver Pay Contracts program, Percentage Rules, Ded IP and set this to either 'True' or 'False'.

The total Freight Bill charges are displayed in the F/B Charges column. These are the same amounts shown on the Detail Tab in the Customer Service program.

Rule Group

Will display the Rule Group as specified in the Driver Pay Contracts program.

Override

In the case of a manually entered Extra Pay entry, the default Override value will be 'True'. This tells the system that the pay was not generated automatically, but that it is acceptable for processing. In the case of automatically generated percentage payments, if you manually change any values associated with the pay record, you must change this flag to 'True' (the flag may change automatically) in order to prevent the system from over-writing your changes as further dispatch activity occurs.

Override User

Works in conjunction with the Override column. Once you adjust information on this Tab, the override username will appear in this column. Useful when tracking any changes made to the system.

Override Date

Works in conjunction with the Override column. Once you adjust information on this Tab, the override date and time will appear in this column. Useful when tracking any changes made to the system Payable Account pre-populated based on the entry in the Driver Pay Contracts program > Driver Pay Accounts Tab.

Taxable

Pre-populated based on the entry in the Driver Pay Contracts program > R&M Deductions Tab.

Team Drivers

The default is set at 'False'. This will automatically change to 'True' if there is more than one driver used in say, the pickup of this Freight Bill, as set out in the Dispatch program, this will automatically display as 'True.'

This depends on whether you are using 'trip-based' or 'freight-bill' based rules.

If the rule is 'trip-based', set this field to 'True' and then pay will only be generated when two drivers are assigned to the leg (as set up in the Dispatch program, on the Trip Grid). If the value is set to 'False', pay will be generated if only one driver is assigned to the leg.

* This is different from a freight-bill based rule where payment occurs if a single driver is on the Freight Bill, but not if a team is. * Percentage rules are never trip based, they can only be Freight Bill based. * If you are paying drivers through Local Dispatch / Customer Service / Quick Bill Entry, it does not matter what value is entered in this field.

SOURCE_REG_ACC

This field indicates which Register program the Driver Pay entry was posted in.

Gross Pay Deduction

This field allows you to enter a dollar amount that will be applied as a Gross Pay deduction for the selected Driver.

Freight Charge Deduction sub-tab

image35

The records stored in this grid detail those deductions that affect the total freight charges. You can also use this Tab to pay local drivers an hourly amount, which will reduce the percentage amount paid to a Driver. For example, if you have a Driver paid by percentage, but need a local Driver for one Pick-Up, and the local Driver is paid by the hour, enter the local Driver’s information in this Tab, enter the amount, and this amount will be deducted from the amount paid to the Driver paid on a percentage basis.

The behavior of this Tab is controlled by the 'Ded FB Deds' option on the Driver Pay Contracts program > Percentage Tab.
Field Definition

Driver ID

Select the '+' button to add a new record and then double-click in the Driver ID column to select the driver of your choice.

Remarks

Enter any relevant remarks.

Amount

Enter the amount of freight charge deduction.

Currency

Will default to currency used in this Freight Bill.

Start Time

Will default to the current date upon the creation of a new record. Double-click to enter a different date, if required.

End Time

Will default to the current date upon the creation of a new record. Double-click to enter a different date, if required.

Lunch

This field allows you to specify any time that was given for a Lunch break for a driver. The field will default to '0.5' (one half hour) upon the creation of a new record. You may enter any other time simply by clicking within the field and entering a new integer value.

Total Hrs

Will calculate the total amount of time that will be deducted from the various options of this Tab.

Gross FB Charges / Driver FB Charges

These two fields will update with values as changes are made within the Freight Charge Deduction Tab. These fields are read-only and are uneditable.

Dispatch Information sub-tab

image36

This Tab offers a recap of Pick-up and Delivery information and offers Driver, Power Unit, and Trailer names, as well as the Trip Number, and Actual Time.

Driver Shift

Optional field: you may enter the details regarding the Driver’s shift time, if required.