(no text)

joeb

Member
I am interested in any information anyone may have regarding an interface
between JDE & UPS Worldship software.
Has anyone done this? At what point are you interfacing, at ship confirm?
or???? What fields do you send? What information from Worldship are you
getting back?

Thanks,
7.3 cume 11
Joe Bennett
Senior Applications Manager
Johnson Outdoors Inc.
(262) 884-1648
[email protected]
 
Hi Joe,

Gateway had been interfacing with UPS quite some time ago, but it's very
likely that it was totally custom and not through UPS Worldship. I just
thought I'd let you know that they had done it in the past...they might have
some advice.

You might try to find out who their contact is for the forums.

Annamaria Evangelista-France
The Gadget Group, Inc
1-877-523-0586 x203
[email protected]
www.gadgetgroup.com
 
The way we did was we wrote a report (that creates a file) to be accessed by
the UPS software. Pretty simple process. UPS tech people should do all the
mapping to their software from the report created.

----- Original Message -----
From: "joeb" <[email protected]>
To: <[email protected]>
Sent: Wednesday, May 30, 2001 12:23 PM
Subject: (no text)


I am interested in any information anyone may have regarding an interface
between JDE & UPS Worldship software.
Has anyone done this? At what point are you interfacing, at ship confirm?
or???? What fields do you send? What information from Worldship are you
getting back?

Thanks,
7.3 cume 11
Joe Bennett
Senior Applications Manager
Johnson Outdoors Inc.
(262) 884-1648
[email protected]




--------------------------
 
I have written an interface between JDE and UPS Worldship software.

Before the shipping department begins work in the morning, I create a file
from the open orders that contains shipping address, customer's PO, order
number and an email address to notify the customer of the shipment. This
file is used, through Client Access ODBC, by the UPS machine. When an order
number is entered in the UPS machine, the correct ship to address is brought
in along with the cusomer's PO (we use that field in UPS reference 2) and
the email address. This file can be refereshed during the day so it will
pick up same day orders.

We created pick slips with a barcoded order number and pick slip number. We
pick a complete pick slip - if we can't fill a pick slip, we void the pick
slip and reprint a corrected pick slip. Therefore, when we process a package
or group of packages, we enter the order number in the UPS system reference
1, customer's PO in reference 2 and pick slip number in reference 3. The
order and pick slip number are scanned, using a scanner provided by UPS
attached to their system.

At the end of the day, the machine outputs the file (containing ship address
info, order number, pick slip number, package weight, package tracking
number, package charge, COD info, declared value info, shipment billing
option, shipment total, number of packages, void flag, shipment tracking
number, and shipment weight). I have an icon on the UPS machine which FTPs
the file to the AS400, and kicks off a CL to validate the data.

At the end of day, SLEEPER runs a job which changes the status on F4211 to
indicate that shipment confirm was done for each record sent from the UPS
machine (no problem since each order/pick combination is unique). The F4211
record also will contain the Carrier ID for UPS and the tracking number in
the Container ID field. I create the appropriate freight record with the
charges in the UPS record. After that, SLEEPER runs our invoices.

Debra Ferry
Kings Electronics
803-909-5064
[email protected]
JDE 7.3 cum 11
 
Debra,
Do you exclusively ship all of your product via UPS? Do you ever ship
RPS/Fedex? What about LTLs?
 
Back
Top