Detail tabs: Status - User Defined Fields

yellowbox

This topic discusses the following tabs:

  • Status

  • Summary

  • Supplier

  • Trace

  • Trip Resources

  • User Defined Fields

Status

The Status Tab displays information current and previous events processed for the Freight Bill. These include dispatch events and locations as well as print history from the billing process. This is also where an EDI WS 214 reply recipient is assigned.

  1. Status Codes are configured in the Codes Maintenance program. Status Code changes occur as the Freight Bill is processed through the system, and indicate the current condition of the Freight Bill. For example, when a Freight Bill code is Posted, it is assigned a Status Code of the 'Availability' behavior (with the TruckMate default data, the code 'AVAIL').

    In the Dispatch program, as Status Codes are assigned to trips they are also assigned to the Freight Bills on the trip. With the TruckMate default data, a Freight Bill might be assigned the codes 'DISP', 'PICKD' and 'DELVD' (of the Code Behavior Types 'Dispatch', 'Pick Up' and 'Delivery', respectively). In the City Dispatch program, and the Drill Down form in the Dispatch program, you can apply Status Codes directly to Freight Bills. You can also assign Status Codes during the Bill Printing and Billing Register processes.

  2. The user can select any of the column header labels in order to sort the data by that column’s values. Depending on which column is being sorted on (i.e. those of 'String' type) you can use the 'Filter' field to filter on specific values in the column.

image29

Field Definition

Current Status

Will pre-populate with the current Status as shown in the Customer Service program.

Enter a Status Code in the field, or click the search button for a Status Code selection form. Only Status Codes with the Code Behaviors Types of 'Availability', 'Completion', 'Docked' 'Administrative' and 'Cancel' are available to be selected.

It is possible to change a Freight Bill’s current status by clicking the image30 search button to the right of the Current Status field. Clicking on this button opens the Freight Bill Status Change window described below.

Reason Code

Reason Codes are set up in the Service Failure Codes section of the Codes Maintenance program, and are used as descriptors if a Freight Bill has encountered any difficulties as it is processed.

Admin Status

This field allows users to perform an Administrative status change which does not affect the current status of the freight bill. Administrative statuses can be made even when a freight bill is active on a trip.

To change the Admin Status of a freight bill, simply use the standard 'Change Status' form and select one of the status codes you have configured for the 'Administrative' behavior category (Codes Maintenance program > Status Tab).

Current Zone

Will pre-populate with the current Zone as selected in the Customer Service program.

Filter

Depending on which column is being sorted on (i.e. must be of 'String' type) the user can enter text or numeric values into the 'Filter' field to show only those records in the column which match.

No Position

When this flag is selected all 'Position' status updates (those normally received from the Mobile Communications module) will be removed from the Status Tab display.

InterComp

When working with Inter Company Freight Bills, this drop-down can be used to display the Status Changes for the currently selected Bill, the Inter Company Bill, or both, allowing visibility across multiple TruckMate operating Companies:

  • This Bill
    Shows status changes for the displayed Freight Bill only.

  • IC Bill
    Shows status changes for the matching intercompany Freight Bill only.

  • Both
    Shows status changes for both Freight Bills.

Send WS 214 Back To

Use the search button to select which Client you would like to send Web Services 214 data back to.

Detention

Selecting this button will open the Detention window, which details the Detention charges associated with this Freight Bill.
The Detention button will only appear if the Application Configurator program > RATES.EXE > 'Use Detention' option is set to 'True'.

Printing History

The fields described here indicate Billing process functions which have been completed.

  • DR Printed
    Indicates if a Delivery Receipt has been printed for the current Freight Bill.

  • FB Printed
    Indicates if an Invoice was printed for the current Freight Bill.

  • Stmt Printed
    Indicates if the Freight Bill was included on a Billing Statement.

Status History Grid

Column Definition

Status Code

Displays all Status Codes assigned to the Freight Bill since it was entered.

Note: If you’ve printed out this bill using the Invoice Printing program, the status Tab will show this bill printed as FB_PRINTED or DR_PRINTED (depending on if you’ve chosen to print a Delivery receipt). If you’ve printed out this bill using the Statement Printing program, then the bill will show as STMT_PRINTED on the Status Tab.

Date Changed

Displays the date and time that the Status Code changes were made to the Freight Bill.

Zone

If the Status Code change resulted from a change to the Freight Bills current location (for example, when a Freight Bill is delivered on a trip in the Dispatch program) the Freight Bills new zone will be displayed in this field.

Updated By

Displays the user name of the person who made the status change.

Comment

Comments can be recorded when the status of the trip to which the bill is assigned (in the Dispatch program) is changed. Also, if you recorded a comment when the Freight Bill was canceled or de-assigned from a trip in the Dispatch program, it will display here.

If the Application Configurator program > DISPATCH.EXE > 'Show Lat/Long' option is set to 'True', the Latitude/Longitude positions of the Trip Leg when its Status was updated will display in this field.

Trip Number

If the Freight Bill has been assigned to a trip in the Dispatch program, the Trip Number will display in this column. Note that a Freight Bill can be assigned to more than one trip. For example, on one trip a Freight Bill might be picked up and dropped at a loading dock. Then, on a second trip, the Freight Bill is delivered to its destination. Also, more than one Freight Bill can be assigned to a trip. If no Trip Number is displayed, it means that the Freight Bill has never been assigned to a trip.

Reason Code

Double-click this field to choose a Reason Code for this detail line. Reason Codes are set up in the Service Failure Codes section of the Codes Maintenance program, and are used as descriptors if a Freight Bill has encountered any difficulties as it is processed.

Date Inserted

This field contains the Date/Time stamp of when the record was initially inserted into the Database, as opposed to the 'Date Changed' field above, which records the Date/Time stamp of when the Status was updated.

Context Menu

Other than the standard options available in most grid context menus, one additional option exists:

The Print Manifest option is only enabled if the selected Status History record has an assigned Trip Number. If selected a report selection screen will pop up, the manifest report will be in the report selection list. The user can select the report and then select to view the report, e-mail it or fax it.

Freight Bill Status Change

image31

This feature is disabled by default. To enable this feature, go to the Security Setup program > Business Events Tab. This function can only be used if the Freight Bill is not currently assigned to a trip in the Dispatch program.

There are several options available on both the Security Setup program > Security > Allow Changes and Approving/Printing Tabs that affect freight bills when specific statuses are applied.

Great care must be taken whenever manually changing the status of a Freight Bill, as this action may have severe ramifications throughout the system. For example, this can cause a completed bill to re-appear in Dispatch.

Field Definition

Current Status

Enter a Status Code in the field, or click the search button for a Status Code selection form.

Only Status Codes with the Code Behaviors Types of 'Availability', 'Completion', 'Docked' 'Administrative' and 'Cancel' are available to be selected.

EDI Status Only?

Selecting this flag will allow the user to insert a status record to the ODRSTAT table without interfering with the current status of the order.

If checked, the selected information will show all possible Freight Bill status codes and will be added to the status history only, depending on the EDI Communication Manager configuration, this may cause a 214 status update to the customers to occur.

If this option is grayed out, it can be enabled by setting the Application Configurator program > CSERV.EXE > 'EDI Status Updates' option to 'True'.

Current Zone

To change a Freight Bills current zone, enter a 'Zone Code' in the field, or click the search button for a zone selection form.

Next Terminal Zone

To change a Freight Bills Next Terminal Zone, enter a 'Zone Code' (configured as a Terminal in the Codes Maintenance program) in the field, or click the search button for a zone selection form.

Date

Will default to the current date and time. You can manually alter this value as needed.

Comment

Is a free format entry field where you can record a comment about this status change. Because this is a manual status change, it is highly advisable that you enter a note explaining why the change was done.

Working with detentions

The Detention Form window will appear when the user clicks the Detention button on the Status Tab (or uses the <ALT><J> hot key). This window will automatically populate with the 'Pickup' and 'Delivery' information from the Freight Bill and any Detention Charges that have accrued against the Bill.

Fields in the Pickup and Delivery sections automatically populate with the freight bill’s pickup and delivery information respectively. The remaining fields are described below.

Field Definition

Billing Option

Choose how you would like the Detention charges to be applied:

  • Acc Charges: Detention charges will appear on the original Freight Bill as a Accessorial Charge.

  • Invoice: Detention charges will be applied on a new Freight Bill.

Manual Rate

Select this flag to manually audit the Detention information (dates, charges, rate, etc.) for the selected Freight Bill.

Currency

Sets the currency of the Detention charges.

Time Units / Rate Units

Select the Time and Rate Units for the Detention calculations using their respective drop-down menus.

If any Detention e-mails have previously been sent out for the selected Freight Bill, they will be displayed in the History grid.

Select a particular e-mail record to have its details populated into the two-sided E-Mail window below the History Grid. On the left pane of this window the e-mail message’s contents are displayed, while on the right page the e-mail addresses it was sent to are shown.

Detention Buttons

Option Definition

Calc

Select this button to calculate the Detention charges using the available Pickup and Delivery information. Detention Rating charges will be determined by the Detention Rating Rate Sheets as setup and applied to specific Clients on the Rates Maintenance program > Detention Tab.

Note: If no Detention Rates have been set up, the user can still calculate Detention manually in this window by selecting the 'Manual Rate' flag (above) and entering the required information.

EMail

Select this button to access the TruckMate E-mail System, which will allow you to setup and send the Detention e-mails.

FB Notes

Select this button to access the Notes window for the selected Freight Bill.

Summary

The Summary Tab offers several functions in addition to displaying summarized load information from the Details Tab. Shipping instructions, the current status of the Freight Bill, and CSA flag are examples of information found here. With the exception of selecting a Filter, adding or editing Notes and assigning Requested Equipment, the information on the Summary Tab is a read-only summary of information entered on the other Tabs, and cannot be changed.

The Summary Tab can be enabled/disabled for specific Users via the Security Setup program.

image32

Field Definition

Commodity

This field displays the Commodity Code of the last alphabetical commodity. For example, if you’ve entered the following commodities: applies, zucchini, carrots with carrots being the last item entered. The commodity Tab will show zucchini. To create new Commodities, use the Codes Maintenance program.

Note: If the Commodity field is blank when trying to save a popup message will appear notifying the user the commodity field is invalid.

Requested Equipment

In the Customer & Vendor Profiles program, you can configure a default Equipment Class for each customer profile. If an Equipment Class has been configured for the customer entered in the Shipper section, that equipment code will display here. (Equipment Classes are configured in the Codes Maintenance program). You can manually enter an Equipment Class code, or click the search button for a selection form. Automatic rating can be configured to rate based on the Equipment Class specified here. See the Rates Maintenance topic for more information.

Operations Code

Double-click this field (or click the search button) to choose an Operations Code to be attached to the current Freight Bill. If you have a 'default' Operations Code for the current Site, selecting an Operations Code in this field will override your default.

For more information on Operations Codes, see the Codes Maintenance program documentation.

Project / Job No.

Double-click this field (or click the Database Search button) to choose a Job Code to assign to the Freight Bill. Only active Job Codes will display in the list. Filter the list down to assist you in finding the correct code (i.e. enter '2007-FRE' to list only the 2007 events for Division FRE). If, instead of selecting a code from the list, you entered the code directly into the field, there is a check done at saving of the Freight Bill to validate the code and disallow update if either invalid or expired (i.e. cancelled). Thus, the user is forced to enter only an active Job Code. Expired Codes are not checked for after a successful Post of the Freight Bill.

This field is not a required field, but it can be added or amended at any time. If an incorrectly assigned Job Code is caught after billing, and the current User has the 'Allow edit of Job Code' flag enabled on the Security Setup program > Security > Business Events > Allow Changes Tab, then he/she can modify this field for an interfaced bill.

Note: This field is disabled completely if the Application Configurator program > CSERV.EXE > 'Recursive Job Quotes' option is set to 'True'. Also, when creating Extra Stops, this value will be copied onto the Child Bills (if populated).

Current Status

This field displays the Status Code most recently applied to the Freight Bill. Click the Status Tab to view a history of the Freight Bill’s status. Status Code changes occur when Freight Bills are posted in the Customer Service program, when Freight Bills are assigned to trips, dispatched and delivered in the Dispatch program, when Freight Bills are approved for billing in the Customer Service program, and when Freight Bills are updated to the Accounts Receivable module using the Billing Register program.

Changed Date / Time

This field shows the date and time of the last edit to the record.

Sales Agent

Double-click this field (or click the search button) to select the Sales Agent Code associated with the Operations Code you have specified (if required). Defining a Sales Agent Code will allow for easier tracking of Brokerage Commissions, for example.

Sales Agent Codes are configured in the Customer & Vendor Profiles program (on the Vendor > Types Tab). You can specify which kind of Users may be selected as Sales Agents by using the Application Configurator program > CSERV.EXE > Sales Agent option.

Dispatch Agent

Double-click this field (or click the search button) to select the Dispatch Agent Code associated with the Operations Code you have specified (if required). Defining a Dispatch Agent Code will allow for easier tracking of Brokerage Commissions, for example.

Dispatch Agent Codes are configured in the Customer & Vendor Profiles program (on the Vendor > Types Tab).You can specify which kind of Users may be selected as Sales Agents by using the Application Configurator program > CSERV.EXE > Sales Agent option.

Notes

The Notes window has several of its own Tabs near the bottom of the window. These Tabs are used to quickly enter Notes for the different aspects of the selected Freight Bill. The default Tab is the Billing Tab, where you may enter Notes relating to the Billing information of the Freight Bill. Clicking on any of the other Tabs will allow you to enter free form Notes for the Container, Driver, etc.

If there are no Notes currently associated with a Freight Bill, the Notes Button will appear like this. image33

If there are existing Notes, the button icon will change, like this. image34

Ship Instructions

This button opens a pop-up form that allows the user to select from a list of standard shipping instructions to attach to the Freight Bill. The 'Standard Shipping Instructions' available on the window are configured in the Codes Maintenance program.

image35

Shipping instructions can be associated with a specific Client by entering data in the Customer & Vendor Profiles program > Client Tab > Shipping Instruction Tab. In addition, they need to be based on whether the Client is a Shipper or Consignee (receiver).

The Shipping Instructions button will change in appearance depending on if there are Shipping Instructions attached to the displayed Freight Bill, similar to the behavior of the 'Notes' button (above).

Trace #

This field displays the trace number as defined in the Trace Tab. This field is populated according to the following logic: It will be populated with the first 'B' type (Bill of Lading) trace number if one or more of B type bills exist. If no 'B' type exists, then it will be populated with the first trace number (as defined in the Trace Tab), except for 'I' type (ProBill). If there is a 'P' type (Purchase Order) it will use the first P type number when the Bill To is the Consignee.

Pieces / Weight / Length / Cube / Volume / Area / Time / Pallets

These fields display the totals of these values from all the detail lines entered on the Details Tab.

Temp

This field is a read-only field and displays the lowest temperature from among all commodity temperatures of commodities entered on the detail lines in the Details Tab. The source of the value displayed in this field can be controlled with an Application Configuration option (App Config). The 'Temperature Lookup Field' in Application Configurator progarm > Billing > CSERV.EXE can be set to have the system either get the value of this field from 'TLORDER.TEMPERATURE', or TLORDER.ROLLUP_TEMPERATURE columns.

Dangerous Goods

If any of the commodities entered on the detail lines on the Details Tab are configured as a Dangerous Good (in the Codes Maintenance program) this box will be checked. You cannot change the value of this box on the Summary Tab.

IDSC Standby

This flag is used by companies who employ the IDSC Load Builder software to optimize their trips. When a freight bill is flagged as 'IDSC Standby', the IDSC Load Builder program will be able to import it for further optimization. For more information, see the IDSC documentation.

Temp. Controlled

If any of the commodities entered on the detail lines on the Details Tab are configured as Temperature Controlled (in the Codes Maintenance program) this box will be checked. You cannot change the value of this box on the Summary Tab.

Tarped

Click on this field to place a checkmark in the box indicating this Freight Bill requires a tarp.

CSA

Place a checkmark in the CSA box if this Freight Bill requires a CSA driver. Placing a checkmark in this box will cause the CSA column in the Dispatch program > Freight Bill Grid to display as 'True', and the 'CSA' column of the Trips Assigned grid of the Driver Call-in program will display as 'True' as well.

The CSA (Customs Self Assessment) program provides CSA importers with the benefits of a streamlined accounting and payment process for all imported goods. The CSA program also provides CSA importers, CSA carriers, and registered drivers with the benefits of a streamlined clearance option for CSA eligible goods.

The streamlined clearance option eliminates the requirement for any transactional transmissions of data related to eligible goods, allowing for the clearance of goods based on their identification as CSA goods and the presentation of the CSA importer’s Business Number, the CSA carrier code, and registered driver identification at the border (called 'Commercial Driver Registration Program (CDRP)'). The signed Delivery receipt will be proof of Canada Customs release for a CSA shipment. For more information refer to the Canada Border Services Agency web-site.

On December 12, 2003, the Customs Program of the Canada Customs and Revenue Agency was transferred to the new Canada Border Services Agency (CBSA).

When you enter your Driver information, in Driver Profiles, ensure you enter the Drivers CDRP # (Commercial Driver Registration Program #). If you attempt to match a Driver (without a CDRP #) with a shipment requiring a CSA Driver, the system will display a warning message. Two CSERV.EXE Application Configurator options are available to assist you in this function: 'Auto Set CSA Flag', and 'Warn Non CSA Driver'. 'Warn Non CSA Driver' is also an Application Configurator option available from DISPATCH.EXE.

High Value

The High Value flag determines if this commodity is of great monetary value. When this option is checked, a green '$' dollar sign will appear within the 'Warning' field of the Customer Service Details Tab. You cannot change the value of this flag within the Summary Tab, it must be configured for the selected commodity from the Codes Maintenance program.

IDSC Standby

Selecting this option will flag the currently displayed freight bill for import into the IDSC Load Builder application for optimization/routing. Freight bills that have this flag checked will be entered into the TLORDER_STATUSES database table, which will be accessed by the IDSC Load Builder application when gathering data.

Note: In order for freight bills to be imported into Load Builder they must also have a 'Current Status' belonging to the status behavior category of 'A' (Availability).

Once freight bills have been processed/optimized in the IDSC Load Builder application, they can be re-imported into TruckMate as Dispatch Trips. See the IDSC documentation for more information.

Specific Filter

Filter queries previously defined in the Filters Tab will appear in the drop-down list offered in. After selecting a filter, two arrow buttons will appear beside the filter field. These buttons are used to move forward and backwards through Freight Bills that match the criteria defined in the selected filter.

For example, if your filter selects bills with the status of 'Complete', clicking the forward arrow button will move to the next Freight Bill with the status of 'Complete'. The arrow buttons on the main navigator bar will continue to move through records consecutively, by Bill Number. To clear the selected filter, click the button labelled 'C' to the right of the Filter field.

Notes

There are nine Tabs available on the Notes form: 'Billing', 'Container', 'Driver', 'OSD', 'Other', 'Write Off', and 'User 1' - 'User 3'. Freight Bill Notes can also be entered and viewed in the Dispatch program, the Local Dispatch program, the Driver Call In program, the Trip Tracer program, and the AR Inquiry program. You can apply special formatting characteristics (such as bolding or colored text) to the Freight Bill notes. Right click in the Notes form for a menu of formatting options. After entering notes, be sure to click the Post button at the bottom right corner of the notes form.

You can also display the Notes window by using the '<CTRL><N>' Hot Key combination.

image57

The 9 Notes Tabs correspond to various areas of the TLORDER Table. You can configure any of the Tab labels by changing their values in the Application Configurator program > NOTES section. The correspond configuration options are labelled 'TLORDER Tab 1 - 9'.

One example would be to change the labels of the custom 'User 1 - 3' Tables to something like 'Shipper', 'Consignee' and 'Bill-To' and enter specific Notes depending on the Freight Bill for each of the attached Clients.

The User can change also the Notes window’s format to either 'Normal' or 'Journal-Style' (which stamps each entry with the User name and Date/Time stamp) by changing a set of options in the Application Configurator program > NOTES section. Each of the 9 Tabs above pulls from the TLORDER Table, so use the NOTES.EXE options 'TLORDER Journal-Style 1 - 9' to change the style.

Using the Application Configurator program > NOTES > 'Rate Logging' option, you can configure one of the 9 Notes Tabs to display how the Rating logic for the attached Freight Bill was determined.

If using 'Journal-Style' Notes, only those users with 'Supervisor' security clearance (as configured by the 'Supervisor' flag on the Security Setup program > Groups Tab per User Group) can edit the top section of the Note.

Supplier

The Supplier Tab is used to manage Supplier transactions (both order records and charge-back transactions). This Tab uses data from within the Supplier Payables Module programs.

image36

The Supplier Tab is split vertically into two sections: the left-hand section will show the user a grid listing Supplier Transaction records (both the order records and any charge-back transactions). Below the grid are various Tabs offering additional details about each transaction. The right-hand section offers summary information about the supplier transactions overall and how they relate to the Customer order.

The List and Details buttons modify the appearance of the Supplier Tab. Selecting the 'List' button will display a record of all Supplier transactions with some initial details. Selecting the 'Details' button will allow you to view the specific details related to the Supplier transactions in your Database.

Supplier Transaction List Grid

This grid lists a record of all Supplier transactions for the selected Freight Bill, with some basic summary information.

Context Menu

Option Definition

Split

Sometimes the supply-side record may be split into multiple records if more than one Supplier or Supplier order will be needed to fulfill the Customer order. To split the original record into multiple orders, highlight the record you wish to split in the Supplier Transaction grid. Then right-click to open the context menu, and then select the 'Split Order' menu option. A window will appear and the user can set the number of Supplier orders to add.

For example: if a Customer order is to be split into two equal Supplier orders, the set the number of orders to add to '1'. This will add one more order to the original order, making two supplier orders in all.

Process

Missing information

Supplier Information

Selecting this option will open the Vendor Profiles program with the selected detail line’s Vendor details.

Copy

Selecting this option will copy the information from the selected detail line, allowing you to paste its contents into a separate line.

Supplier Transaction Details Grid

Column Definition

Supplier Code

The 'Supplier Code' field indicates the Vendor who will be fulfilling the order. Double-click on this field to open an edit-pick form to find a valid Vendor code (of 'Supplier' type). When the Vendor code is set and the record is saved, the program will attempt to match the Vendor, commodity, and currency to a current contract. If a contract is found, the details will be updated with an entry for commission and any automatic extra charges. The order record itself will be updated to include the commission and extra charge amounts. If no contract is found, the information from the special default contract '0' will be used to determine what the commission, valid extra charges, and accounts will be used for the order and detail records.

Supplier Contracts are configured and maintained in the Supplier Contracts program.

Order Number

This field displays the Vendor’s invoice or reference number.

Currency

This field will default to the same currency as the Customer order. It can be manually updated, but if no contract is found to match the Vendor, commodity, and currency, the order details will be updated accordingly.

Type

This field indicates if the transaction is a Bill (Vendor invoice), Debit memo, or Credit memo. This field will determine how the transaction is processed into A/P later on.

Status

This field displays the current status for the order. Users can change the status by double-clicking on the field to open a pop-up form which will let them set the new status, an 'as-of date' if the change is back or future-dated, and any comments needed. All orders will progress from 'Entry' to 'Approved' status. All transactions must be marked 'Approved' before the Freight Bill and Supplier transactions will be allowed to posted through the Billing Register program. In between they may also be updated to 'Confirmed', 'Received', 'Unapproved' or 'OSD' status. See the Status Tab description below for more information.

Context Menu

Option Definition

Split Order

Sometimes the supply-side record may be split into multiple records if more than one Supplier or Supplier order will be needed to fulfill the Customer order. To split the original record into multiple orders, highlight the record you wish to split in the Supplier Transaction grid. Then right-click to open the context menu, and then select the 'Split Order' menu option. A window will appear and the user can set the number of Supplier orders to add.

For Example: if a Customer order is to be split into two equal Supplier orders, the set the number of orders to add to '1'. This will add one more order to the original order, making two supplier orders in all.

Status Change

Selecting this option will open the Supplier Status Change window, which will allow you to update the status of your Supplier transactions. The Customer Service program will test that the associated Vendor is of 'Supplier' type before a Status Change is completed.

image37

Use the drop-down menu at the top of the window to update the invoice’s status, then select a date by double clicking the 'As of' field and choosing a date from the calendar menu.

You may add a comment reflecting the details of the status change, if desired.

Delete Order

Selecting this option will remove the selected detail line from the Supplier Transaction grid.

Supplier Information

Selecting this option will open the Vendor Profiles program with the selected detail line’s Vendor details.

Copy

Selecting this option will copy the information from the selected detail line, allowing you to paste its contents into a separate line.

Layout > Customize Grid

Selecting this option will open the Grid Customization Tool, common to all TruckMate applications.

Details sub-tab

The Details Tab contains a grid which lists records describing the break-down for product, commission, and add-on charges. Users can add, delete, or update records in the grid. When the changes are saved, the Supplier order record they are matched to will be updated accordingly and the changes reflected in the main Supplier Transaction grid above.

Column Definition

Type

This column will indicate if the line item details product, commission, or extra charges. The program will behave differently in the columns that follow depending on the type selected.

Item

If the Type column is set to product, this field will default to the commodity code set in the Supplier order record. If the Type column is set to 'Commission', this field will default to a blank value. If the Type column is set to 'Extra Charges', this field will only allow extra charge code values which exist on the Supplier’s current contract.

Description

This field will default to the commodity description, the contract short description for commission entries, or the extra charge description from the contract.

Unit

Product line items will show this value as the piece unit type.

Quantity

All entries will show this as the item count to apply the rate value to.

Rate

All entries will show a rate to multiply by the quantity.

Cost

All entries will show a cost value extended from the quantity and rate.

Contract

This field will show the contract number used to generate/validate the commission and extra charge entries.

Manual

Users can double-click on this field to toggle it between 'True' and 'False'. If a user wants to manually override a commission or extra-charge Rate value from the contract, or set the Contract field value to blank (indicating a completely manual transaction), they must set this value to 'True'.

Note: When orders are first generated, before the vendor is assigned, this value is set to 'True'. When a Supplier is set, this value will be reset to 'False' and the contract details applied.

Size / Label / Packaging

These fields provide additional information to the Supplier and may only be filled in for product line items. Users will be able to double-click on each field to open an edit-pick form to select from possible values for the given commodity code.

Status sub-tab

The Status Tab displays a grid showing the status history of the currently highlighted order for users to review (but not edit) records with the following fields: Status, Updated, Updated By, and Comment.

As noted above, all records will progress through the 'Entry' and 'Approved' statuses. The following describes what each of the status codes indicates:

  • Entry
    Indicates that order and details have not yet be finalized with the supplier and/or customer.

  • Confirmed
    Will indicate that the order details have been confirmed with the customer and the supplier has confirmed they can fulfill the order.

  • Received
    Indicates a POD document has been received from the carrier and/or customer. If the transaction does not have any product detail, ie. it is a charge-back, then the received status is not required before approval.

  • OSD
    Will indicate the customer has received the order but reports over-shipped, short-shipped, or damaged product. Adjustment of the order details may be needed before approving the transaction for processing.

  • Approved
    Indicates that the transaction details have been reviewed, the order is in balance, and is ready to be processed through the Billing Register.

  • Unapproved
    Will indicate that a user has reversed an approved order.

GL sub-tab

The GL Tab displays a grid which shows the GL entries (distribution) which are associated with each order.

These entries are automatically generated based on the default Supplier Payable for the transaction currency code and the default expense accounts set in the Supplier’s current contract. Users can set a check-box to indicate that the distribution will be done manually. If no contract is found (the transaction is manual), this check-box will be set automatically. However, the distribution will be out of balance as no expense entries will be created and only the Supplier Payable entry will be created. Users are expected to fill in the correct expense accounts.

The GL and order details must match or the order will be flagged as not in balance. An order which is not in balance will not post through the Billing Register program.

User sub-tab

The User Tab will display 15 fields to store additional information for the order which are user defined. Fields 1-5 store text values up to 40 characters each. Fields 6-10 store numeric values. Fields 11-15 store date-time values.

Trace Number (Trace#)

The Trace Tab allows additional identification numbers/text to be added to the Freight Bill. Container numbers, security seal numbers, and Release numbers are a few examples.

image38

An unlimited number of Trace Numbers can be associated with a Freight Bill. They can be formatted to print on Freight Bills, can be used to find Freight Bills and trips using the Trip Tracer program, can be viewed in the Dispatch program, and can be updated and sent through Mobile Communications.

Trace Types are hard-coded into the TRACE_TYPE Table, and cannot be added or deleted. However, you can determine whether a particular Trace Type is available (in edit-pick fields) via the 'Active' flag on the Codes Maintenance program > Trace Number Types Tab.

You can set the description of 3 of the available Trace Types (1,2, and 3) via configuration options in the Application Configurator program > CSERV.EXE section. In some TruckMate applications, if the configs are not set, then these Trace Types may not be available. However, most other applications will still show all 3 with default descriptions like 'User Trace X' (if configs not set).
Field Definition

Trace Number Type

Click on the type of Trace Number that describes this entry. Select the Database Search button to select a Trace Number Type from those available on your system. Trace Number Types are activated or de-activated on the Codes Maintenance program > Trace Number Types Tab.

Number

Enter the Trace Number you wish to use for the selected Trace record.

Ref. Qualifier

The Reference Qualifier field is used for inbound 204 load offers to further qualify the Trace (reference) numbers received via EDI, as EDI Clients often need to return specific reference numbers to their Trading Partners in subsequent EDI Sets (210, 214, 990, etc.), as well as the original reference qualifier code. Thus this field value is how an EDI Client keeps track of a true reference meaning, relative to EDI.

Note: This field is also available in the EDI Audit program and Order Pre-Processor program, but for ease-of-entry, it has been added to the Trace Tab in Customer Service.

Description

This field will automatically populate with the Trace Type description once a Trace Type is chosen. These descriptions are configured on the Codes Maintenance program > Trace Number Types Tab.

User Field 1 - User Field 10

These ten User Fields can be used to enter any relevant data against the Trace number being added to the Freight Bill. The user can modify the field labels of these fields by changing the values of the Application Configurator program > CSERV.EXE > 'Trace User Field 1' - 'Trace User Field 10' options.

Latest Pick Up By for Container

This field can be used to specify the latest Date and Time for container pickup. This value will be shown in the Dispatch program > Trip Grid > 'Latest Pickup' column.

Note: This field uses the main navigator bar, not the navigator bar on the Trace Tab.

Trace Number Grid

This grid can be used to view available Trace Numbers. To give the user an easier way to track and locate trace numbers a sort functionality is applied to this grid. Select a column header to sort the data in the grid using that column. You can also enter Trace Numbers directly into this grid. Use your Tab key to create a new line and then type in the Trace Number, and refer to the Trace Number Type and enter the corresponding letter. The field values should be treated as described above.

Trace Number Validation Rules

If, at any point using the Customer Service program, you are not allowed to post or save a Freight Bill, it may be due to your configured Trace Number Validation Rules. On the Codes Maintenance program > Trace Number Validation Tab, a User can setup various validations rules that will be enforced against Trace Numbers that are added to a Freight Bill. If validation rules exist for the Trace Type you are trying to add to a Freight Bill, there are two ways the system will handle non-compliant Trace Number values:

  • If the Application Configurator program > CSERV.EXE > 'Trace Number Validation Override' option is set to 'False', the User will not be allowed to post (or save) the Freight Bill. Validation rules are strictly enforced.

  • If the Application Configurator program > CSERV.EXE > 'Trace Number Validation Override' option is set to 'True', the User will be warned about the validation rule not being satisfied, but will then offer the option of overriding the validation rule, so that the Freight Bill can be posted/saved.

Trip Resources (Trip Res’s)

The Trip Resources Tab displays additional information regarding the Trips currently attached to this Freight Bill.

image39

Column Definition

Trip Number

Displays the Trip Number, from the Dispatch program, on which the Freight Bill was carried.

Leg Seq

Displays the leg number for the trip (created in the Dispatch program) that was associated with the Freight Bill (Note that a Freight Bill may be associated with more than one leg per trip).

Resource Type

Displays the other resources assigned to the trip. 'D' stands for driver; 'F' stands for Freight Bill; 'P' stands for power unit; 'R' stands for resource (trailer or miscellaneous equipment).

Resource ID

Displays the unit code or Freight Bill number of resources assigned to the trip.

From Zone / To Zone

For resources assigned to each leg, these fields display the Leg From and Leg To zones.

User Defined Fields (User Def’s)

Select this Tab (or use the Hot Key combination '<CTRL><U>') to access ten fields used to store user defined values. These fields display in the Dispatch program > Freight Bill Grid, and in the User Defined Fields form in the Local Dispatch program. You can change the labels that are assigned to these fields by using the Application Configurator program. This Tab refreshes when the main Freight Bill is saved, so that any changes to the user fields will update automatically.

The User Defined Fields Tab can be enabled/disabled for specific Users via the Security Setup program.