Purchase Additional Charges and Landed Cost FAQ

Question: How are additional charges calculated, and when are additional charges added to landed cost?

Answer: Purchase additional charges can be added to a purchase order and/or to a shipment (a shipment is comprised of containers, where each container can store multiple purchase orders/lines/quantities). Additional charges are added to the landed cost calculation only when the Include in Landed Cost check box is selected.

Note If the Include in Landed Cost check box is not selected for an additional charge, then it will have no effect on the landed cost of the product(s).

Purchase additional charges are calculated based on the amount type selected, as follows:

Amount Type

Purchase Order

Shipment

Description

Percent

An additional charge is created by multiplying the cost times the additional percentage regardless of whether it originates from a purchase order or a shipment.

Example A 10% additional charge is assigned to a purchase order. The purchase order cost (before the additional charge) is $1,000. The purchase order additional charge is $100, so the total purchase order is $1,100. A partial receipt of products totaling $500 is made, so additional charges of $50 ($500 x 10%) are added to the landed cost.

Per Unit

An additional charge is created by multiplying the quantity times the additional cost per unit regardless of whether it originates from a purchase order or a shipment.

Note The units of measure on each line might be different units of measure. So, if the additional charge is $1 per unit, then 5 eaches and 5 cases is $10 of additional charges

Example A $10 per unit additional charge is assigned to a purchase order that has 4 lines and 25 total units. The purchase order cost (before the additional charge) is $1,000. The purchase order additional charge is $250 (25 x $10 per unit), so the total purchase order is $1,250. A partial receipt of product units totaling 10 is made, so additional charges of $100 (10 units x $10) are added to the landed cost.

Per Unit Weight

An additional charge is created by multiplying the total weight times the additional cost per weight unit regardless of whether it originates from a purchase order or a shipment.

Example A $10 per lb. additional charge is assigned to a purchase order that has 3 lines and 50 lbs. The purchase order cost (before the additional charge) is $1,000. The purchase order additional charge is $500 (50 lbs. x $10 per lb.), so the total purchase order is $1,500. A partial receipt of product weight totaling 20 lbs. is made, so additional charges of $200 (20 lbs. x $10 per lb.) are added to the landed cost.

Per Receipt

 

An additional charge is created each time there is another receipt if it originates from a purchase order; it is then distributed according to the Distribute by option selected.

Example A $100 per receipt additional charge (distribute by cost) is assigned to a purchase order that has 5 lines. The purchase order cost (before the additional charge) is $1,000. The purchase order additional charge is $100 (assumes that the purchase order will be received in full) so the total purchase order is $1,100. A partial receipt of 3 line items is made, so additional charges of $100 are distributed by cost to the landed cost of the three line items. Another partial receipt of two line items is made, so another additional charge of $100 is distributed by cost to the landed cost of the two line items.

Per Receipt

 

An additional charge is created for every receipt of a container on a shipment. It is then distributed according to the Distribute by option selected.

Note The Per Receipt amount type is generally not used for shipment additional charges.

Example Two purchase orders are created and placed on the same shipment, which is comprised of three containers. A per receipt additional charge of $100 (distribute by cost) is set up for the shipment. The first container is received and $100 is distributed (by cost) to the products in the first container. The second container is received and another $100 is distributed (by cost) to the products in the second container. The third container is received and another $100 is distributed (by cost) to the products in the third container.

First Receipt

 

An additional charge is created only the first time there is a receipt if it originates from a purchase order; it is then distributed according to the Distribute by option selected.

Example A $100 first receipt additional charge (distribute by cost) is assigned to a purchase order that has five lines. The purchase order cost (before the additional charge) is $1,000. The purchase order additional charge is $100 so the total purchase order is $1,100. A first receipt of three line items is made, so additional charges of $100 are distributed (by cost) to the landed cost of the three line items. Another partial receipt of two line items is made, but no further additional charges are distributed.

First Receipt

 

You cannot use additional charges with this amount type for shipments.

Total Receipt

 

An additional charge is created and then pro-rated upon receipt if it originates from a purchase order; it is then distributed according to the Distribute by option selected.

Example A $100 total receipt additional charge (distribute by cost) is assigned to a purchase order that has five lines. The purchase order cost (before the additional charge) is $1,000. The purchase order additional charge is $100 so the total purchase order is $1,100. The first receipt is for two line items that total $200, so additional charges of $20 ($200 / $1,000 x $100) are distributed (by cost) to the landed cost of the two line items. Another partial receipt of two line items that total $500 is made, so additional charges of $50 ($500 / $1,000 x $100) are distributed (by cost) to the landed cost of those two line items.

Note If the purchase order is not fully received, then it is possible that the full amount of the total receipt additional charge may not be used (depending on the Distribute by option and its related data).

Total Receipt

 

An additional charge is created for the total of a shipment. It is then distributed regardless of the container according to the Distribute by option selected.

Example Two purchase orders are created and placed on the same shipment, which is comprised of three containers and totals $1,000. A total receipt additional charge of $100 (distribute by cost) is set up for the shipment. The first container that totals $300 is received and $30 ($300 / $1,000 x $100) is distributed (by cost) to the products in the first container. The second container that totals $500 is received and $50 ($500 / $1,000 x $100) is distributed (by cost) to the products in the second container.

Note A container of a shipment can only be received one time (not multiple times like a purchase order). Care should be taken when constructing the shipment and its related containers. Container contents should be changed as necessary before receiving.

Note When creating additional charges for shipments, it is recommended that you use an amount type of either Total Receipt or Percent. When creating additional charges for purchase orders that will be placed on shipments, it is recommended that you use an amount type of either Per Unit or Percent.

Question: How are additional charges calculated if the supplier overage percentage is set to the Absorb option?

Answer: When over receiving a purchase order line item where the supplier of the purchase order is set to absorb overage, the purchase additional charges of per unit and percent stop accumulating when the ordered quantity is reached.

Example On the last receipt of a purchase order, 730 were received with 10 being an overage. The per unit additional charges for the first additional charge and second additional charge stopped accumulating at 720 on this receipt. 

To have the per unit additional charges accumulate for the full received quantity, you'll need to change the overage option for the supplier. Selecting Send Back will not allow the warehouse to receive more than was ordered. Setting it to Warn will allow the warehouse to over receive but will display a warning message when you are over receiving x% over the quantity ordered, i.e. a message informing the user is over receiving and asking if they want to proceed with it.

If you select Warn and enter 100.00% in the Overage Percent field,  the user will never receive the warning message unless they happen to receive more then double the quantity ordered.

Question: What hierarchy is used to determine the purchase automatic additional charge that is added to a purchase order if criteria for multiple purchase automatic additional charges are met?

Answer: The following hierarchy is used for order-level charges:

  1. Supplier

  2. Purchase Order Ship-To Location

  3. To Country

  4. From Country

  5. Purchase Date

  6. Purchase Class

The following hierarchy is used for line item charges:

  1. Product

  2. Harmonization Code, From Country, and To Country

  3. Product Category and Subcategory

  4. Product Category

  5. Supplier

  6. Purchase Order Ship-To Location

  7. To Country

  8. From Country

  9. Purchase Date

  10. Purchase Class