Welcome, Guest. Please Login.
04/18/24 at 12:13:23
News:
Home Help Search Login


Pages: 1 2 
Send Topic Print
UPS and FedEx Shipping Automation (Read 11657 times)
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
UPS and FedEx Shipping Automation
04/05/05 at 13:33:52
 
We use UPS and Fed-Ex a ton. We use V-Technologies Star-Ship for processing them. I have set-up the generic Btreive interface for DBA. It works great but to set it up to write the freight and tracking # back to the sales order it requires a real time ADE protocol set-up. See the link  
 
[/url] http://vtechnologies.com/Docs/ADE_Spec.pdf[/url]  
 
Maybe if their is enough interest with other DBAERS we could find a cool way to implement this?
 
John
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
wildco
Full Member
***


I love YaBB 1G -
SP1!

Posts: 174
Re: UPS and FedEx Shipping Automation
Reply #1 - 04/11/05 at 06:53:32
 
Both UPS and Fedex software have built-in capabilities to link to the DBA database.  Currently, we just use it to type in our sales order number and populate the address fields, but the system can write back and stick the tracking number in the SO notes.
 
The only issue we ran into with UPS was that the address line 2 field name has a space in it which the UPS software cannot deal with.  It also does not work well for international addresses as the countries are not selected from a drop-down menu in DBA.
 
This has saved us many $$$ in not having to retype all those addresses.
 
Just a suggestion.
Back to top
 
 

Aaron

2004.1 with ISTECH 1/12/06
  IP Logged
Mike_Habich
Full Member
***




Posts: 227
Re: UPS and FedEx Shipping Automation
Reply #2 - 04/11/05 at 07:20:11
 
Would you...or someone...be kind enough to give detail of how to do this?
Back to top
 
 
Email   IP Logged
wildco
Full Member
***


I love YaBB 1G -
SP1!

Posts: 174
Re: UPS and FedEx Shipping Automation
Reply #3 - 04/12/05 at 05:13:44
 
What I did was call UPS and Fedex and set up appointments with their system integrators.  The integrators came out and actually did the work.  We had to set up a DSN? on the host machine for pervasive.  Then, you can use the integrating programs built into world ship and ship manager to get at the DBA database via the file.ddf file (same one used for Crystal).
 
You then just have to know the correct filename (I believe it is BKARINV, and the ship-to fields in that file), reference them appropriately, and its off to the races.  We chose to bring in the data by Sales Order Number, but any identifier could be used (P/S #, Inv #, etc).
 
All in all, it was relatively painless and works quite well.  We have not yet tried to write the tracking number back to the SO notes.  This is because I don't know the file/field for the first note line in the SO.  It would also require training in our office to prevent order entry from using that field ever when entering an order.
Back to top
 
 

Aaron

2004.1 with ISTECH 1/12/06
  IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: UPS and FedEx Shipping Automation
Reply #4 - 04/20/05 at 08:01:57
 
UPS is offering a free "Webinar" on integration of UOWS. Go to http://upspreferred.webex.com to sign up (I think you have to be a "UPS Preferred Customer").
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
wildco
Full Member
***


I love YaBB 1G -
SP1!

Posts: 174
Re: UPS and FedEx Shipping Automation
Reply #5 - 08/15/05 at 11:00:05
 
One small request: we cannot fully integrate our UPS system with DBA due to the naming conventions of the shipping address fields in the BKARINV.B files.
 
The way I understand it, lines 2 and 3 of the address have a space in them (something like BKARINV.SHPAD 2 instead of BKARINV.SHPAD2).  It this something easy to change (to remove the space) or would it be a major undertaking?
 
If we could fully integrate DBA with UPS, I think it would help many people here.  
 
If this is a big deal, the work around is obviously to put the entire address in the first address line  Grin
Back to top
 
 

Aaron

2004.1 with ISTECH 1/12/06
  IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: UPS and FedEx Shipping Automation
Reply #6 - 08/15/05 at 11:11:47
 
We have both UPS and Fed-Ex ODBC mapped and works great. We use Address line 1 for the attention or M/F field. Address 2 and 3 for the actual address. No problems what so ever. Fortunatly when we started with DBA this is the way we imported all of the addresses. 8)
 
John
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
wildco
Full Member
***


I love YaBB 1G -
SP1!

Posts: 174
Re: UPS and FedEx Shipping Automation
Reply #7 - 08/18/05 at 10:55:07
 
Are you doing an import based upon sales order # (or some other #) or did you just bring in the addresses into the address book.
 
I am very interested in getting this fixed if possible to prevent errors.
 
Thank you for your help!
Back to top
 
 

Aaron

2004.1 with ISTECH 1/12/06
  IP Logged
Lenette
Senior Member
****


That's why they call
it work!!

Posts: 461
Gender: female
Re: UPS and FedEx Shipping Automation
Reply #8 - 08/18/05 at 11:00:06
 
Previously, I attend the Webinar offerred by UPS.  Now I am ready to start on this project and I have contacted my UPS Rep.
 
Is this a LIVE link or will it be export/import??
Back to top
 
 

Version: Current (always current on patches)
Build - 05/21/19 T7-7iR11
Pervasive 12.00 - EVO seats 15 DC seats 5
DBA since 2002

Lenette Egan
McDantim Inc
Helena, Montana
Email WWW   IP Logged
Tim Keating
Senior Member
****


DBA CLASSIC WIN 2000
C/S

Posts: 298
Re: UPS and FedEx Shipping Automation
Reply #9 - 08/18/05 at 19:10:01
 
It could be either but there is no reason not to do an ODBC connection to the sales order data which will give you a direct lookup.
Back to top
 
 

Tim Keating
Motor Guard Corporation
Email WWW   IP Logged
Lenette
Senior Member
****


That's why they call
it work!!

Posts: 461
Gender: female
Re: UPS and FedEx Shipping Automation
Reply #10 - 08/19/05 at 06:30:39
 
Thanks... i just wanted to make sure that it was LIVE info.... otherwise there would be no point for our business to change procedures.
Back to top
 
 

Version: Current (always current on patches)
Build - 05/21/19 T7-7iR11
Pervasive 12.00 - EVO seats 15 DC seats 5
DBA since 2002

Lenette Egan
McDantim Inc
Helena, Montana
Email WWW   IP Logged
Tim Keating
Senior Member
****


DBA CLASSIC WIN 2000
C/S

Posts: 298
Re: UPS and FedEx Shipping Automation
Reply #11 - 08/19/05 at 07:40:41
 
It's live to the extent that it picks up the ship-to address from the sales order.  If you change the customer's address in AR-A after issuing the sales order the change won't be picked up in UPS/FedEx.  
 
It's proven to be a big time saver for us as well as eliminating input errors and has also elimited the issue of unsynchronized databases between DBA and UPS computer.
Back to top
 
 

Tim Keating
Motor Guard Corporation
Email WWW   IP Logged
wildco
Full Member
***


I love YaBB 1G -
SP1!

Posts: 174
Re: UPS and FedEx Shipping Automation
Reply #12 - 08/22/05 at 10:28:01
 
Tim,
 
Are you able to import data from all address lines on the sales order?  I can only get the first address line (and I would love to get them all, it would save some mistakes  Cheesy)
Back to top
 
 

Aaron

2004.1 with ISTECH 1/12/06
  IP Logged
Tim Keating
Senior Member
****


DBA CLASSIC WIN 2000
C/S

Posts: 298
Re: UPS and FedEx Shipping Automation
Reply #13 - 08/22/05 at 12:24:25
 
Maybe its my ignorance, but I believe I've linked to all three address field without a problem.  I either don't understand or can't duplicate the problem discussed above.
 
I linked as follows (DBA :: UPS):
 
BKAR_INV_SHPA1   ::  Street Address
 
BKAR_INV_SHPA2_1  ::  Room/Floor/Address 2
 
BKAR_INV_SHPA2_2  ::  Department/Address 3  
 
We don't issue too many sales orders with data in the second and third lines, but I did create a dummy order with data on those lines and it pulled into UPS.
 
Maybe there's a problem we haven't uncovered yet, I don't know.
Back to top
 
 

Tim Keating
Motor Guard Corporation
Email WWW   IP Logged
Lenette
Senior Member
****


That's why they call
it work!!

Posts: 461
Gender: female
Re: UPS and FedEx Shipping Automation
Reply #14 - 08/22/05 at 13:26:12
 
Tim,
 
did you have to do any "prep-work" to dba before you started the automation??  Such as, address format (like w/ the USPS people).  What happens if UPS doesn't like the info pulled in from DBA?  Does it write back any corrections for the next time?
Back to top
 
 

Version: Current (always current on patches)
Build - 05/21/19 T7-7iR11
Pervasive 12.00 - EVO seats 15 DC seats 5
DBA since 2002

Lenette Egan
McDantim Inc
Helena, Montana
Email WWW   IP Logged
Pages: 1 2 
Send Topic Print