To Configure the FedEx Ship Manager, please follow the following steps:
- Open FedEx Ship Manager and select Integration>FedEx Integration Assistant
- Continue until you are prompted to Create a new profile, then continue
- Select Both Import and Export, then continue
- Select ODBC then scroll down to select the ODBC driver you created, then continue
- A window will appear prompting you to login using your Login ID (sa) and password
- Complete the next 2 windows as show below, then continue
Images may vary depending on FedEx Ship Manager version
You will now choose the information you want to import. Click All Fields to bring up a list of available fields and check the following:
Recipient>Address
Address 1
Address 2
City
Company
Contact Name
Postal Code
State/Province
Package>Miscellaneous
Bill Transportation To
Number of Packages
Payor Account Number
Service Type
Shipment ID
Weight
Service Type
Shipment ID
Weight
After you have checked the required fields click OK, then Continue
The next step is to match the FedEx fields with the Presidio fields as follows. For all fields, select Presidio table “vwShipIntegrationSource”.
FedEx Field | Presidio Field |
Address 1 | sShipToAddress1 |
Address 2 | sShipToAddress2 |
City | sShipToCity |
Company | sShipToName1 |
Contact Name | sShipToContactFirstLast or other Contact Format Option |
Postal Code | sShipToZip |
State/Province | sShipToState |
Bill Transportation To | sBillingOption |
Number of Packages | nCartonsTotal |
Payor Account Number | sShip3rdPartyAcctFedEx |
Service Type | sServiceCode |
Shipment ID | sLookUpJobSeq |
Note:
· You can select a default Service Type to be used if a matching type is not found.
· Weight is not a mapped field, but must be set with a default value or “Read Scale”
From the same screen you will need to click Select Index and choose sLookUpJobSeq, then click OK, then Continue.
The last part of the Import integration is to convert Presidio field data to the corresponding FedEx fields.
The last part of the Import integration is to convert Presidio field data to the corresponding FedEx fields.
Click Service Type and the following screen will appear:
Map the fields as follows:
FedEx Field | Presidio Field |
Priority Overnight | 1 |
Standard Overnight | 5 |
2 Day | 3 |
First Overnight | 6 |
Express Saver | 20 |
Ground | 92 |
Ground Home Delivery | 90 |
1 Day Freight | 70 |
2 Day Freight | 80 |
3 Day Frieght | 83 |
All Others | <None> |
Click Bill Transportation To and the following screen will appear:
To (F SM value) | From (your value) |
Leave "Select a default" untouched | |
Bill Sender | SHP |
Bill Recipient | None |
Bill Third Party | TP |
FedEX Ground Collect | None |
SmartPost Prepaid | None |
Note:
Bill Sender can be set as the default Bill Transportation to. To enable 3rd Party, go to Shipment Data in the Conversion Tab and select "Bill Transportation To" . Bill Sender needs to be assigned to "SHP" and Bill Third Party needs to be assigned to "TP"