Editing Imported Data

Client Description:

The client is an manufacturer and exporter of hand tools.


To provide a method of using shipment information already stored in the client's order-entry system to:
1. Generate required documents.
2. Create a computer readable file for use by their Customs Broker.

3. To further automate the generation of UPS shipping labels.

Ability to Provide Data Electronically:

The information required by Customs is stored in the client's internal order-entry system..

Solution Implemented:

The TranSendIT program, using the EDI-Link - ODBC Driver program to import the shipment files from the order-entry system.

Solution Details:

The TranSendIT program is a complete and flexible "Export Shipment Processing Service" that provides the means to create, manage and share shipment data across the supply-chain.

Through a use of a "data import" function, the system runs the ODBC link.  This function works by running a "select statement" which accesses the various databases and files in the order-entry system and "builds" a file of all shipments meeting the preset conditions.  The user has the ability to select the record(s) that will be process for actually shipping. 

The solution provides the user with the ability to modify the data that has been imported prior to saving a final version for distribution.  This was critical, as the number of units retrieved from the order-entry system may be changed to deal with back orders.

The solution also contains a UPS rating module that lets the user rate the shipment and generate an approved UPS mailing label.  This is done by selecting a shipment from the imported data and entering the weight of the shipping boxes.