We set this up in 2005, and the same method works now with current WorldShip, DBA, and Win 7. No external software is used.
First set up the ODBC database (Control Panel, ODBC...)
In UPS Worldship, create an export map like this:
Field Mappings:
WorldShip Field (Container::Field)
ODBC Data Source Field (Table::Field)
Package::Tracking Number
BKARDESC::BK_DESC_NOTES
Shipment Information::Service Type
BKARDESC::BK_DESC_NOTES
Shipment Information::Void Indicator
BKARDESC::BK_DESC_NOTES
Shipment Information::Collection date
BKARDESC::BK_DESC_NOTES
Package::Reference 2
BKARDESC::BK_DESC_NUM
Still in Worldship, set up Auto Export, Export after shipment processing for this export map.
When you enter a shipment, DBA SO number goes into UPS shipment reference field 2 (this could be changed in above map)
Result in DBA Classic notes looks like this:
1Z6566X90156041201 UPS Next Day Air 20140618
I do have two problems that I'd really like resolved:
The Evo wiki (
https://evoerp.com/wiki/index.php?title=Evo/DBA_Shipping_information_to_UPS_%26_
pass_freight_%26_Tracking_number_back ) explains that the note should start with Tracking #. I can't find a way to put text at the beginning of the exported note.
The note is only in DBA classic note form. It can't be edited in Evo if you're using Evo Notes. This is the only thing that makes us still have to use DBA classic.