Using Dynamic Code Coloring
Just had a support call with a customer who wanted to highlight a single field with different colors based on multiple conditions. For example, if the shipment was late, it should be highlighted in red ; if it was to be delivered in the next 3 hours, highlight it in yellow. If to be delivered today, in green otherwise leave it
How do you do this? With Dynamic color coding, included with Horizon Dispatch.
Anyways, the problem is that Dynamic Color coding expects that you want every row to be the same, so the default expression put into DynamicBackColor expression in the Customizer reads COLCODE("RUN","DRIVER").
In this case, we wanted some conditions to be used for ONE set of columns (delivery date) and another set of conditions to be used for another set of columns (Driver,tractor, trailer). How did we accomplish this?
We changed the alias in Dynamic Color Coding to be unique for each set. So one said DRDATE and another said DRINFO and another said DRIVER.
The tricky part (and one that has been passed onto Development to make it easier to do) was to change the DynamicBackColor expression in the Customizer to say
COLCODE("RUN","DRDATE") or COLCODE("RUN","DRINFO") instead of the default DRIVER field.
Once that was done, it worked really well!
And it's not hard at all. Check out the screen shot above.
Here is the end result. The Delivery Date and Time fields use special codes to identify if they are late or on time. The Driver and Tractor fields use the SAME logic but ALSO will change to the grey, if the driver has broken down.
New Horizon Update Posted
Our development group just posted a new update to Horizon. Make sure you use the Horizon Installation Manager and update your files accordingly.
Here's a quick summary of what was updated:
Custom Booking - 2.0.15.0
ADD SUPPORT FOR EDI LOAD TENDERING (3805)
Custom Booking has been modified to allow users to book EDI Tendered loads. All of the normal customization and validation features are now available for those loads.
AUTO FILL STOPS (4008)
Custom Booking will now reset the filter used in Customer (Shipper, Consignee, Bill to) lookups so that all customers are accessible when booking loads.
Not showing total rate when USING MAKE BILL (4067)
NEED TO ADD SUPPORT FOR CLOSING DATE/TIMES AND COMMENTS (4109)
Custom Booking now accepts Closing Dates and Times, and Comments from the EDI Load Tender object.
Dispatch History Transfer - 2.0.19.0
UNMANIFESTED AND EMPTY MANIFEST CHECKCALLS NOT MOVING TO HIST (4121)
All checkcalls will now be checked when running the Transfer to History process. Any checkcall that has been completed based on linked Horizon applications will now be moved to history.
E-Settlements - 2.0.4.0
SETTLEMENT SHEETS DO NOT PRINT AFTER EMAIL IS SENT (4122)
A new option has been added to Electronic Settlement Sheets to enable the regular printing of the settlements sheets once they have been e-mailed. This option, Print Sheets After Email is found in the Service Properties screen for this service.
Horizon Circle of Service - 2.0.15.0
ERROR DURING EXPORT LEAVE CSEXPORT.FLG SET ACTIVE (4078)
New behavior is as follows: An error during export will no longer pause execution. It will also no longer terminate the run schedule, meaning that should an error occur, the program will attempt to run again at the next scheduled time. Any error condition during export of transactions should now leave csexport.flg file set to "FREE" instead of "ACTIVE"
Horizon Compliance - 2.0.48.0
FALSE 14HR ON-DUTY VIOLATIONS REPORTED (4097)
Driver Compliance now respects the FMCSA rule (stated below) of extended on-duty time by using the sleeper berth. Sleeper Berth Exception: Drivers may split on-duty time by using sleeper berth periods, but must comply with the new hours-of-service rules. These drivers may accumulate the equivalent of 10 consecutive hours off-duty by taking 2 periods of rest in the sleeper berth, provided: Neither period is less than 2 hours; Driving time in the period immediately before and after each rest period when added together does not exceed 11 hours; and The driver does not drive after the 14th hour after coming on duty following 10 hours off-duty, where the 14th hour is calculated by: (A) Excluding any sleeper berth period of at least 2 hours which, when added to a subsequent sleeper berth period, totals at least 10 hours; and (B) Including all on-duty time, all off-duty time not spent in the sleeper berth, all sleeper berth periods of less than 2 hours, and any sleeper berth period not described in paragraph 3(A).
Horizon Dispatch - 2.0.57.0
SYSTEM ALLOWS USER TO ASSIGN SHIPMENTS TO EMPTY MANIFEST (4104)
Dispatch will no longer allow shipments to be inserted onto empty manifests. Additional manifests must be assigned first.
indexing di files does not index dipo (4128)
Indexing System Files will now include the Purchase Orders file (DIPO).
Important Item about the New Release
We're noticing a few problems with users running the new release on networks where either the tables are getting corrupted or the network connection is dying.
To help resolve this, open the file CONFIG.FPW in Windows Notepad and add a line that says
TABLEVALIDATE=0
Then close the file, save it and restart Horizon.
While we are updating the product to ensure this is always added, this is an interim fix.
Why do you need to do this?
Horizon 2.0 uses a more recent version of the FoxPro runtime that is more strict about potential table corruption. By adding TABLEVALIDATE=0 to the CONFIG.FPW, Horizon will not be as strict about these problems.
See - right-click on the shipment and you can choose Edit and then edit the shipment!
Editing Shipments in the Checkcall Window
Glad to see people are reading their newsletters and answering the poll. Just saw one of the responses asking for the ability to edit shipments in the Checkcall window.
I'm not sure which screen you are thinking of but right now, if you go to the Assignment screen (F6 or F8 from the Dispatch window), you can right-click on a shipment, click Edit and you should be able to modify the entire shipment.
Keep in mind the full edit is only available if you are using Custom Booking but even if you aren't, you can modify some aspects about it.
Or maybe the request is for another such window. If it is, please leave me a comment here and we'll take a look at it.
Thanks
What does that RSS button do?
Some of you may be coming to the web site wondering what that RSS button
means. Basically, it's a great way for people to find out about what's
happening on the blog without having to visit the web site each time. RSS is
short for Real Simple Syndication and is essentially a news feed , like
having a teletype device right in your office.
It uses what's called a News Aggregator to collect information.
Here's one news aggregator I use, called NewsGator. This one works right
within Outlook.
http://www.newsgator.com
Welcome to the Front Lines
Welcome everyone to the first posting on the Horizon Frontlines.
I'm the Technology Marketing Manager for MTI and the purpose of this blog is to share some of my thoughts and ideas about Horizon that may not be neccessarily worth a news release but are worth talking about. There are so many different ways that our customers use trucking software and the best way to learn how to use it is to see what others are working on.
I'll be sharing some of the stories some of our customers are going through as well as some of the great things you can do with the Horizon trucking software product line.
I hope you enjoy it!
