Calculating Shipping in case of multiple Cartons used in the Shipment when Ship API or File Upload is used

This Works with the App Config: Override Invoice Shipping with API Freight Amount. 

This Config Use the freight provided in API call during Ship API or File Upload.

How does it work? 

Let’s take an example of an SO with the Shipping Charges=100

The App Config: Override Invoice Shipping with API Freight Amount. = OFF

Case 1:

  • SO with the Shipping Charges=100
  • Freight add Carrier Cost = Available,
  • Per Carton Cost = Not Available
Item Number Freight CarrierCost FreightPerCarton CarrierCostPerCarton
A 10 151
B 20 152
C 30 153
D 40 154

The result on the Invoice:

  • Shipping Cost (Shipment Info) = 100
  • Carrier Cost (Shipment Info) = 151; Picks only First line 
  • Available Shipping = 100 (Picks the SO shipping cost as per App config)
  • Charge to Customer = 100
  • Shipping Cost in the Invoice shipping tab = 100

Case 2: 

  • SO with the Shipping Charges=100
  • Freight add Carrier Cost = Not Available,
  • Per Carton Cost = Available
Item Number Freight CarrierCost FreightPerCarton CarrierCostPerCarton
A 10 151
B 20 152
C 30 153
D 40 154

Result:

  • Shipping Cost (Shipment Info) = 100
  • Carrier Cost (Shipment Info) = 610; Sum-up of all lines 
  • Available Shipping = 100 (Picks the SO shipping cost as per App config)
  • Charge to Customer = 100
  • Shipping Cost in the Invoice shipping tab = 100

Case 3: 

  • SO with the Shipping Charges=100
  • Freight add Carrier Cost = Available,
  • Per Carton Cost = Available
Item Number Freight CarrierCost FreightPerCarton CarrierCostPerCarton
A 50 151 5000 500
B 60 152 6000 600
C 70 153 7000 700
D 80 154 8000 800

Result:

  • Shipping Cost (Shipment Info) = 26000
  • Carrier Cost (Shipment Info) = 2600; Sum-up of all lines
  • Available Shipping = 100 (Picks the SO shipping cost as per App config)
  • Charge to Customer = 100
  • Shipping Cost in the Invoice shipping tab = 100

The App Config: Override Invoice Shipping with API Freight Amount. = ON

Case 1:

  • SO with the Shipping Charges=100
  • Freight add Carrier Cost = Available,
  • Per Carton Cost = Not Available
Item Number Freight CarrierCost FreightPerCarton CarrierCostPerCarton
A 10 151
B 20 152
C 30 153
D 40 154

Result:

  • Shipping Cost (Shipment Info) = 10
  • Carrier Cost (Shipment Info) = 151; Picks only First line 
  • Available Shipping = 10 (Picked from the Freight)
  • Charge to Customer = 10
  • Shipping Cost in the Invoice shipping tab = 10

Case 2: 

  • SO with the Shipping Charges=100
  • Freight add Carrier Cost = Not Available,
  • Per Carton Cost = Available
Item Number Freight CarrierCost FreightPerCarton CarrierCostPerCarton
A 50 151
B 60 152
C 70 153
D 80 154

Result:

  • Shipping Cost (Shipment Info) = 260
  • Carrier Cost (Shipment Info) = 610; Sum-up of all lines 
  • Available Shipping = 260( sum-up the FreightPerCarton)
  • Charge to Customer = 260
  • Shipping Cost in the Invoice shipping tab = 260

Case 3: 

  • SO with the Shipping Charges=100
  • Freight add Carrier Cost = Available,
  • Per Carton Cost = Available
Item Number Freight CarrierCost FreightPerCarton CarrierCostPerCarton
A 50 151 5000 500
B 60 152 6000 600
C 70 153 7000 700
D 80 154 8000 800

Result:

  • Shipping Cost (Shipment Info) = 26000
  • Carrier Cost (Shipment Info) = 2600; Sum-up of all lines
  • Available Shipping = 50(Picked from the Freight)
  • Charge to Customer = 50
  • Shipping Cost in the Invoice shipping tab = 50

Was this article helpful?