Calculate the rates

Once you have records defined in Shipping Rates, you can obtain rates from:

  • RateWare XL – based on the specific tariff table and tariff effective date for your tariff.
  • FedEx and UPS parcel rates – based on the selected FedEx or UPS service.
FedEx and UPS parcel rate services have weight limits. If the shipment weight exceeds the limit for the selected service, no cost is returned. For example, FedEx Home Delivery has a limit of 70 LB.
  1. Open the Shipping Rates table.
  2. Click Calculate Rates. You see the Calculate Rates form.
  3. Select RateWare XL as the rate provider. If RateWare XL is not currently configured click Configure to access the Rate Data form.
  4. Populate the Tariff Table and Table Date settings based on the tariff you want to use.
  5. If you want to calculate only Shipping Rate records that have not yet been populated with rates, turn the Only Calculate Missing Rates switch on.
  6. Click Calculate. The Rate Source, Cost and Lookup Date columns are populated for all shipping rates that were successfully calculated.
  1. Open the Shipping Rates table.
  2. Click Calculate Rates. You see the Calculate Rates form.
  3. Select one of the FedEx or UPS services as the rate provider.
  4. If you want to calculate only Shipping Rate records that have not yet been populated with rates, turn the Only Calculate Missing Rates switch on.
  5. Click Calculate. The Rate Source, Cost and Lookup Date columns are populated for all shipping rates that were successfully calculated.

Failed parcel rate lookups

Parcel rating lookups can fail when data is missing or invalid.

  • Source Country/Destination Country - If you are using RateWare XL, enter "USA" for United States locations. The lookup will fail with other values such as "US" or "United States".
  • Postal Codes – If the Source Postal Code or Destination Postal Code values are null or invalid, the rate lookup will not return a Cost. The lookups currently require 5-digit postal codes for locations in the United States.
  • Shipment Weight – When generating Shipping Rates records, this value is populated based on one of:
    • Shipment Size when the source is Transportation Policies.
    • Weight, Volume or Quantity when the source is Shipments.

    The Shipment Weight must be populated for a lookup to succeed.

    Shipment Weight must be expressed in LB. If your model weight unit of measure is not "LB - Pound", select LB as the unit of measure in the column value (for example 525 LB).

    If the Shipment Weight exceeds the weight limit for a selected service, the lookup will not return a Cost.

  • Freight Class – If you are using RateWare XL, the Shipping Rate must include a value for Freight Class that matches the accepted set of freight classes.
  • Lookup Table – If the required table is not available, the lookup will fail. A database with the rate data is installed to the \CostData folder.

The following table lists the error codes returned by RateWare XL:

Code Description Error type Resolution
-1 Fatal Error.  Check the log file for details. Server   Please contact SMC3 Technical Support at 1-800-272-3425.  Reference Error Code -1
-2 Warning.  Turn on logging for details. Server Please contact SMC3 Technical Support at 1-800-272-3425.  Reference Error Code -2
0 Function Success Client No error
1 Unknown Error Server Please contact SMC3 Technical Support at 1-800-272-3425.  Reference Error Code 1
2 Open File error Server Please contact SMC3 Technical Support at 1-800-272-3425.  Reference Error Code 2
3 Read File error Server   Please contact SMC3 Technical Support at 1-800-272-3425.  Reference Error Code 3
4 Memory Allocation error Server Please contact SMC3 Technical Support at 1-800-272-3425.  Reference Error Code 4
5 Invalid OrgDestToGateWayPoint Flag Client Please contact SMC3 Technical Support at 1-800-272-3425.  Reference Error Code 5
6 Class Not Found Client Please use the proper NMFC class
7 Invalid Weight Client Please verify the weight for each detail line is between 1 and 999999
8 Maximum weight exceeded Client Total shipment weight cannot exceed 999999
9 Invalid discount Client Please ensure the discount is numeric and does not exceed 99.99
10 Invalid origin postal code Client Please ensure the postal code is correct
11 Origin postal code not in tariff Client Please ensure the origin postal code is correct.  It is possible the postal code is not valid for the effective date of the tariff.
12 Invalid destination postal code Client Please ensure the postal code is correct
13 Destination postal code not in tariff Client Please ensure the destination postal code is correct.  It is possible the postal code is not valid for the effective date of the tariff.
14 Origin/Destination combination not in tariff Client The postal code combination is not within the territory governed by the tariff you are using.  If you are certain both postal codes are part of the territory, then it is possible that the postal code pair is only valid in one direction.
15 Tariff name must be specified Client Please enter the tariff name for a currently installed tariff.
17 Invalid shipment date Client Please ensure the shipment date is in CCYYMMDD format and falls within the effective date of the tariff
21 Ratebase number not found Server Please contact SMC3 Technical Support at 1-800-272-3425.  Reference Error Code 21
22 Maximum number of lane adjustment hits exceeded Server Please contact SMC3 Technical Support at 1-800-272-3425.  Reference Error Code 22
23 No GateWay Flag Client Please contact SMC3 Technical Support at 1-800-272-3425.  Reference Error Code 23
24 Invalid country code/postal code combination Client The postal code does not exist in the country code specified.  Please ensure the postal code and country code are correct.
25 Lane adjustment process error Server Please contact SMC3 Technical Support at 1-800-272-3425.  Reference Error Code 25
26 Unable to open log file Server Please contact SMC3 Technical Support at 1-800-272-3425.  Reference Error Code 26
27 No detail lines found for this shipment Client Please enter detail lines for this shipment before continuing.
28 Invalid origin country Client Please ensure the origin country contains only letters and does not exceed 3 characters
29 Invalid destination country Client Please ensure the destination country contains only letters and does not exceed 3 characters
30 Invalid single shipment, flag must be Y/N Client Please verify single shipment equals "Y" or "N"
31 More than 100 detail lines found for this shipment Client Please reduce the number of detail lines to less than or equal to 100 for this shipment
32 Tariff not found Client Either the date module you want to use has not been installed or the Tariff Name is invalid.
33 Invalid rate adjustment factor Client Please ensure the rate adjustment factor is numeric and does not exceed 9.9999
34 Invalid use discount, flag must be Y/N Client "Y" = Use supplied discounts; "N" = ignore supplied discounts
35 Invalid discount application, flag must be R/C Client Please verify discount application equals "R" or "C".  "R" =discount applied to rates; "C" = discount applied to charges
36 Invalid MC floor Client Please ensure the minimum charge floor amount is numeric and does not exceed 99999.99
37 Invalid LTL surcharge percentage Client Please verify the LTL surcharge percentage is numeric and it does not exceed 99.99
38 Invalid TL surcharge percentage Client Please verify the TL surcharge percentage is numeric and it does not exceed 99.99
39 Invalid surcharge application, flag must be G/N Client Please verify surcharge application equals "G" or "N".  "G" =surcharge applied to gross charges, "N" =surcharge applied to net charges
40 Invalid stop alternation weight Client Please verify the stop alternation weight is numeric and does not exceed 999999
41 Invalid shipment ID Client Please verify shipment ID does not exceed 20 ascii characters
42 Corrupt file Server Please contact SMC3 Technical Support at 1-800-272-3425.  Reference Error Code 42
44 Invalid director version Server Please contact SMC3 Technical Support at 1-800-272-3425.  Reference Error Code 44
45 Invalid state/postal code combination Client The postal code does not exist in the state specified or the state abbreviation is invalid
46 Density not found Client Please verify density.  Value must be numeric and cannot exceed 9999.99
47 Invalid type Client Please verify detail type. "Density" =density and weight of line item.  "CUBE" =cube and weight of line item, "LWH" = length, width, and height and the weight of line item.
48 Invalid pieces Client Please verify total shipment pieces is numeric and does not exceed 999999.
49 Invalid density units Client Please verify density units.  L=pounds/feet3.  K=kilograms/meters3.

Last modified: Wednesday May 15, 2024

Is this useful?