Cyrious Control integrates with FedEx Ship Manager so that shipping address information may be automatically retrieved and tracking and cost information can be fed back into Control during the closeout process.

*NOTE:* This article describes how to configure the FedEx Ship Manager using UDFs and not the Order Shipping Tab. Go to this article to configure FedEx Ship Manager with the Order Shipping Tab.

• FedEx Tracking Number : Text Field, Edit Box, Not Required.
• FedEx Package Weight : Number Field, Not Required.
• FedEx Actual Price: Number Field, Not Required.
• FedEx List Price : Number Field, Not Required.
• FedEx Shipment Date : Text Field, Not Required.
• FedEx Service Type: Text Field, Drop-Down Values, Not Required. Enter the values below in the drop-down box.

code

Priority Overnight

Standard Overnight

2 Day

First Overnight

Express Saver

Ground

Ground Home

1 Day Freight

2 Day Freight

3 Day Freight

International Priority Overnight

International First overnight

International Economy

International Priority Freight

International Economy Freight

code

• FedEx Package Type: Text Field, Drop-down list, Not Required. Enter the values below in the drop-down box.

code

Your Packaging

FedEx Pak

FedEx Box

FedEx Tube

FedEx Envelope

FedEx 10kg Box

FedEx 25kg Box

code

• Restart Control (so the UDFs are actually created in the database).

1. Log into SSLIP.

1. Open Database Browser and go to Advanced tab.

1. Copy text into SQL window from ShipperInfoTable and Execute.

1. Copy text into SQL window from FedExShippingLogTable and Execute.

1. Copy text into SQL window from CreateTableIndex and Execute.

1. Copy text into SQL window from CreateTrigger and Execute.

1. Run SQL Server's Management Studio application and log into SQL Server.

1. Expand Security folder then right-click Logins and click New Login.

1. Login Name will be shipper.

1. Select SQL Server Authentication.

1. Password will be autoshipper.

1. Uncheck “Enforce Password Policy”.

1. Select “Server Roles” on left hand list.

1. Select ALL checkboxes on right side.

1. Click OK and close Management Studio.

1. Open Control panel in Windows and go to Administrative Tools.

1. Open Data Sources(ODBC).

1. Click on System DSN tab.

1. Click Add and select SQL Server entry from list.(Bottom of list)

1. Name Data Source ControlSQL.

1. Server value will be \

1. Click Next.

1. Choose “With SQL Server authentication…” option.

1. Click “Client Configuration” button.

1. Select TCP/IP and uncheck “Dynamically Determine Port” option.

1. Set Port Number to 1433.

1. Click OK.

1. Login ID should be shipper.

1. Password will be autoshipper.

1. Click Next.

1. Select “Change the default database to:” option to StoreData.

1. Click Next and click Finish.

1. Test the data source and verify that you are able to connect to the server.

1. Click OK to close ODBC Administator.

1. NOTE: If you are using Windows x64 edition then the ODBC connection you created will likely not appear in FedEx. This is because FedEx ShipManager uses a 32-bit ODBC connection and by default when you create an ODBC connection in 64-bit windows it is only available to 64-bit applications. If you encounter this problem you need to create a 32-bit ODBC connection by going to C:\Windows\SysWOW64\odbcad32.EXE. Create your connection under this ODBC configuration utility and then it will be available for use within FedEx.

1. Go to the Integration menu and select FedEx Integration Assistant.

1. Select Continue on the Introduction and Before You Begin screens.

1. Select the option “Both Import and Export” and click OK.

1. Select ODBC (Open Database Connectivity Data Source Name)

1. Choose ControlSQL from the Data Source list.

1. Select Login from the pop up window that appears.

1. Username will be shipper. Password will be FedExUPS!14 going forward ( formerly autoshipper ). Click OK.

1. Select Yes for all options shown.

1. Choose the first option for “After I enter a lookup value”.

1. Select Recipient and choose:
   • Address1
   • City
   • Contact Name
   • Postal Code
   • Address2
   • Company
   • Country
   • Phone
   • State/Province
   • Account Number
   • ID

1. Click OK.

1. Select the drop down menu for the “Select your table” drop down list and choose the ShipperInfo table.

1. Select the “Don't Show” option and click Yes on the popup window.

1. Associate fields using the following: (after first field is associated, you will receive a pop up box. Select “Don't Show” and click OK)
   • Address 1 : StreetAddress1
   • Address 2 : StreetAddress2
   • City : City
   • Company : CompanyName
   • Contact Name : ContactFullName
   • Country : Country
   • Phone : PhoneNumber
   • Postal Code : PostalCode
   • State/Province : State
   • Account Number : AccountID
   • ID : OrderNumber

1. Click on “Select Index” button, click OrderNumber, and click OK.

1. Click Continue and Continue again.

1. Choose ControlSQL again from the Data Source list.

1. Select the two options:
   • Each time a shipment is completed
   • Insert a new record

1. Click Continue.

1. Select Tracking Number and choose:
   • Tracking Number

1. Click OK

1. Select Charges and choose:
   • Net Charge (Under Customer Rates and List Rates)

1. Click OK

1. Select Package and choose:
   • Delivery Date
   • Package Type
   • Ship Date
   • Weight
   • Declared Value
   • Delivery Instructions
   • Service Type

1. Click OK

1. Select Recipient and choose:
   • ID

1. Click OK and Continue.

1. From the drop down table list, select FedExShippingLog.

1. Select “Don't Show” option and click All Categories on the pop up window that appears.

1. Associate fields using the following:
   • Tracking Number : TrackingNumber
   • Net Charge(Customer) : ActualPrice
   • Net Charge(List) : ListPrice
   • Declared Value : DeclaredValue
   • Delivery Date : DeliveryDate
   • Delivery Instructions : DeliveryInstructions
   • Package Type : PackageType
   • Service Type : ServiceType
   • Ship Date : ShipDate
   • Weight : Weight
   • ID : OrderNumber

1. Click Continue through the next couple of screens then click Finish.

1. Select Yes and Save the name as MyProfile.

Typically whenever a Profile is setup in FedEx, it will automatically load the profile whenever FedEx Ship Manager starts and you will see the input box for to type in the Order Number you wish to ship.

1. Type the Order Number into the Lookup Value box and click OK.

1. Process shipment in FedEx like a normal package.

1. Once the package is Shipped, open Control and look into the UDF's of that Order for shipping information for that package.

include_componentbacklinks_pagefedex_integration_process_limit10