Our Sales Model Saves You Money!

You save with self-help evaluation tools, low cost, single package pricing, and our unique 180-day return policy.

Sales Model Details »

 

Who are we?

At DBA we've been delivering manufacturing, MRP, and accounting solutions to thousands of businesses since 1992

Our story »

Data Exchange

How does DBA interact with UPS and Fedex?

In DBA you pick a sales order in the Order Picking screen and then you generate a numbered "shipment" on the Shipping screen.

From the Shipping screen you print a packing list. The Shipping screen includes the delivery address and calculates the total weight, volume, and number of packs (if you maintain such settings against your products).

UPS and Federal Express both provide software programs that handle their end of the process, such as label printing, calculation of shipping charges, generation of a tracking number, etc.

Once the shipping charges known, you enter them on the DBA Shipping screen. The shipping charges eventually flow through to the customer invoice. No other entry is required. Any tracking of your order after shipment should be done through the UPS or Fedex software.

DBA and the UPS/Fedex software each have a table of customer names and delivery addresses. When you install the UPS/Fedex software for the first time, you can populate this table by exporting delivery address records from DBA into the UPS/Fedex software.

When you ship a new customer for the first time, your shipping department will create a customer name and delivery address record in the UPS/Fedex software. That is only done on a once time basis. Once the record has been created, it is used for all subsequent shipments.

Information entered in UPS/Fedex
  • Customer Name, Contact, Delivery Address
  • Items shipped
  • Dimensions and Weights
  • Sales Order Number or Invoice Number (optional)
After shipment, information entered in DBA
  • Shipping Charges
  • Trace ID - Tracking Number (optional)
  • Weigh, Volume, #Packs (optional)
Exporting delivery addresses from DBA
  • Go to File - Data Export.
  • Select the 'Custdel' table.
  • Choose '.xls spreadsheet'.
  • Place check next to fields to be exported (wizard step 4 of 7). Obtain these fields from UPS.
  • If you wish to save this format for re-use, click the Specifications button (wizard step 4 of 7).
  • Save the spreadsheet.
  • Import the spreadsheet into the shipping application.
Related Links

Web Link - UPS Internet Shipping Demo

Web Link - UPS Shipping and Freight Solution Finder

Web Link - Federal Express Ship Manager Video Demo

Web Link - Federal Express shipping and tracking software

← Back