Internal Order-Entry System

Client Description:

 The client is a manufacturer and importer/exporter of high-end specialty garments.



The challenge was to use shipment information contained in their internal order-entry program to eliminate redundant data entry.  Their existing technology and processes required the use of costly internal clerical staff to print shipping documents from the order-entry program and fax them to their US Customs Broker.  Once received, the Broker would keypunch the data into their ABI system.

A further challenge was to provide the ability to incorporate information that was not available either on the forms or in their databases.


Ability to Provide Data Electronically:

Client uses an internally developed Order Entry System.


 Solution Implemented:



 Solution Details:

The requirement was to make use of existing shipment data to create the documents and data files required by the Customs Broker.  Working with their Broker, a list of necessary fields was identified.  Most of the fields were available in the order-entry system.  The remainder of the fields were stored inside the TranSendIT installation. 

Prior to creating a shipment, the user generates a CSV file from their order-entry system.  That file is imported into TranSendIT.  The data from the CSV file is meshed with the fields stored in TranSendIT to create a more complete shipping file.

Once the data has been imported, TranSendIT provides automatic edit checks to verify that all specified fields are complete and allows the user to further edit any fields. 

When all the shipments have been completed, the user has the ability to print the required forms.  The data is sent to the Broker using the built-in "Send" function.  This step sends the data to the EC Dynamics WebServer.  From there, several things happen automatically:

  • A computer readable and importable file is generated.  The file is in the format and delivered in the manner required by each individual recipient;

  • The data file is provided to the Customs Broker for importing into their ABI or Cadex system.  This eliminates the redundant data entry.  The Customs Broker reviews the information received.  Once the file is ready, the Broker submits the file to Customs.
  • A copy of the data is sent to other, authorized TranSendIT installations.