Phone 1-866-278-6243
Free Trial Free Trial Schedule a Demo Schedule a Demo

Using FedEx Ship Manager with All Orders

Using FedEx Ship Manager with All Orders

All Orders 4.X
All Orders 5.X

On the machine having your UPS World Ship please perform the following steps.

STEP 1 - CREATE ODBC SOURCE

  1. Click the Start Menu.

  2. Click Settings/Control Panel.

  3. Double click ODBC data sources icon (found under Administrative Tool in Windows XP) to open the ODBC Data Source Administrator.

  4. Click on the System DSN tab.

  5. Click the Add button.

  6. Select SQL Server from the list of drivers and click Finish.

  7. For Name enter AllOrders and Select the server that contains your All Orders database e.g. SERVER\ALLORDERS then click Next>

  8. Click Next > to accept Windows NT authentication

  9. Change the default database from 'master' to the name of your MDF file and click Next >

  10. Click Finished

STEP 2 - CREATE IMPORT/EXPORT PROFILE

  1. Start UPS FedEx Ship Manager

  2. Click Integration, then click Continue twice

  3. Select Import and click Continue

  4. Select ODBC and AllOrders then click Continue

  5. On 'How will you create shipping labels',  select 'Yes' for all questions and click Continue

  6. On 'How do you want to lookup and import information', select 'After I enter a lookup value' then click Continue

  7. On What type of information you want to Import click Recipient and select:

    • Address 1

    • Address 2

    • City

    • Company

    • Contact Name

    • Country

    • Phone

    • Postal Code

    • State / Province

    • ID

     

  8. Click OK and then Continue

  9. In 'Match FedEx Ship Manager', select qryShippingAddresses and ma them to the Recipient Fields as follows:

    • Address 1 - Addr2

    • Address 2 - Addr3

    • City - City

    • Company - CompanyName

    • Contact Name - Contact

    • Country - Country

    • Phone - Phone

    • Postal Code - Zip

    • State / Province - State

    • ID - NCRef

     

  10. Click Select Index then highlight NCRef then click OK

  11. Click Continue

  12. Click Continue

  13. In 'Where do you want to send shipping information'  select AllOrders the click Continue

  14. In 'How will your data source receive exported information', under When select 'Each time a shipment is completed' and under 'How' select 'Insert a new record' then click 'Continue'

  15. Under 'What type of information do you want to export select All Fields and then select

    • Tracking Number

    • Weight

    • Recipient ID

    • Gross Charge

  16. Press OK then Continue

  17. For the table select tblShippingPackages and Map as follows

    • Tracking Number - TrackingNo

    • Gross Charge - Cost

    • Weight - Weight

    • ID - NCRef

     

  18. Click Continue

  19. Click Finish

  20. Save the Profile as AllOrders

When you do your next shipment you will see a little pop-up box called Lookup enter Shipping-X where x is the ship doc #.  When the shipment is saved, the tracking number will be imported into the ship doc within All Orders.

1/9/2008



Call Cruncher
More questions?

Call to speak with a NumberCruncher Solutions Consultant at:

call us