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