Sage 100

Sage 100 2015. UPS just installed a new computer. The customer would like to set up World Ship so they can enter a Sage 100 order number and the ship to address will populate the World Ship program. Does anyone have instructions on how to do this?

@DougHiggs - see page 21 and the following pages for the Keyed Import Map for UPS World Ship in this document: http://www.dsdinc.com/enh/downloads/SOSI520.pdf

Thanks @BrianKelly !

You are welcome!

UPS will normally provide an integration for free. The ODBC connection has to be configured.

@alanniergarth That is what I thought. I have worked with UPS and FedEx several times over the years. The Sage 100 end user claims they talked to two different people at UPS and both told her that they needed to talk to the Sage partner. I am just going to go out there Wednesday and see if I can set it up. Sometime it is easier to just do it yourself.

I forget the name of the interface they use. We typically get a call from the UPS resource when they get to the point of the ODBC setup. CROSSWARE is what they used to use.

Cough, Cough..... Access DB running a PTQ on the SO header table. Link Worldship to the PTQ table in the Access DB. The db (Sage_Mirror.mdb?) can reside on the server. Server does NOT need a copy of Access. You can set up the PTQ on your PC, then transfer it to the server. To test, you can use a local copy of Excel to pull a query on the header PTQ. Setting up Worldship to pull the data through takes about 10 minutes. If you want to get fancy, print a bar code of the order number on the shipping paper work. Client can buy a BC snanner with USB connection. One click and they have it. If you want to get fancy, create a x-ref table in Worldship to translate Sage ship via codes into UPS speak for next day, 2nd day, ground and any other UPS codes required. Finally, if you really, really want to impress the client, contact @MyronStevenson. He wrote some VB scripting to pull the UPS shipping charges, weight, tracking number, etc. back into the SO shipping with a single button push. SOP for me for over 10 years now. You don't need no stinkin UPS tech guy to do this.........

Sample Sage Mirror DB and a couple screen shots explaining the PTQ set up. Remember, this is a PTQ table, NOT a LINKED table which needs to be refreshed occasionally. Also, you will need to create UPS_Access DSN on the UPS workstation to connect Worldship to the Access DB Preferably a system one (instead of a user) in case there are multiple users signing on to that workstation.

Thanks for all of the detailed information @JeffSchwenk It looks like you have spent a lot of time developing this.