Freight and Shipping Tools
  1. EBMS Knowledge Base
  2. Sales
  3. Freight and Shipping Tools

Calculating Total Weight

How to calculate the total weight of a sales order

The total weight of a sales order is calculated by multiplying the Unit Weight by the Shipped or Ordered quantities. The recommended method is to calculate weight based on the Shipped quantity similar to the extended price of each detail line. Review the Calculating and Comparing Freight Charges section to Calculate based on the ordered amount option.

The Unit Weight is calculated:

  • By the Gross Weight recorded in the General tab of the product record. (See graphic below.)
    OR
  • By the Package Weight found within the optional Shipping tab of the product record.

The Unit Weight can be edited within the sales order.

The total weight of an invoice is often used to calculate shipping charges for shipping methods such as UPS or Fedex shipping. Review the Creating Shipping Methods section for more details on configuring shipping rates. Total weight is also useful when printing shipping documents such as a Bill of Lading.  

The Unit Weight can be present using the following inventory settings:

  1. The Gross Weight setting within the General tab of a product record, as shown below:

    Enter the Gross Weight based on the main unit of measure. Review the Unit of Measure section for more information on the main unit of measure (also referred to as UOM).

  2. The packaging Weight column within the optional Shipping tab of a product record, as shown below:

    Review the Freight and Shipping Calculations section for more details on the optional package weight settings.

Defaulting the Gross Weight

Entering or maintaining the individual weight of each inventory item may be a daunting task. A convenient way to default or set the gross weight for an entire folder group may be a time-saving option if item weights are similar. Often the weight of a sales order is only used to calculate shipping and does not require exact weights. Review the Changing Inventory Defaults section of the inventory documentation for more details.

Entering Weight on a Sales Order

Open a sales order to view the weight columns (Unit Weight and Weight) and weight totals as shown below:

The Unit Weight column shows the weight of the individual product - this number is pulled from the product record. (The Unit Weight can be changed by the user within the sales order.)

The Weight column shows the total weight for the amount of that product ordered (Unit Weight * Ordered).

At the bottom of the sales invoice entry page, note the Weight total and the total number of Items, as shown above. These totals are a running tally for the entire sales document, so look at the table columns for information on individual products and look at the totals for information on the whole order. Note that the window may need to be stretched larger to show this information.

Review the Calculating and Comparing Freight Charges section for details on how the Weight fields are used to calculate freight costs.