METHOD04 - Height EUR Equivalent

Overview

The Height EUR Equivalent method calculates the number of handling units needed based on stacking height limits and then converts the result to EUR pallet equivalent. This combines height-based calculation with standardization to EUR pallet format.

Purpose

This method calculates the Expected Shipment Handling Unit Qty. by:

1. Calculating handling units needed based on total height and maximum stacking height
2. Accounting for interleave handling units (if applicable)
3. Converting the result to EUR pallet equivalent using surface area ratio
4. Providing standardized handling unit count for height-constrained scenarios

Parameters

This method has no configurable parameters, but it uses conditions for:

• Maximum handling unit height
• Interleave handling unit requirements

Algorithm

Step 1: Get Calculation Parameters

Retrieve the following parameters:

• Customer Item (CustItem)
• Unit of Measure (UnitOfMeasure)
• Handling Unit Type (CarrierType)
• Handling Unit Type UOM (CarrierTypeUOM)
• Quantity (Quantity)
• Maximum height, weight, and cubage from conditions

Step 2: Calculate Total Height

1. Calculate number of layers needed:

   Number of Layers = Round(Quantity / CarrierTypeUOM."Qty. per Layer", 1, '>')
   

2. Calculate total height:

   ThisHeight = Number of Layers × CarrierTypeUOM.Height
   

Step 3: Add Interleave Handling Unit Height (if applicable)

If interleave handling units are needed (InclInterleaveCarrier = true AND condition indicates interleave):

• Add handling unit type height to total height:

  ThisHeight = ThisHeight + CarrierType.Height
  

Step 4: Get Maximum Height

Determine maximum allowed height:

• If maximum height from conditions (MaxHeight) > 0:
  • Use MaxHeight from conditions
• Else:
  • Use CarrierType."Pick Max. Load Height"

Step 5: Calculate Base Handling Unit Quantity

BaseCarrierQty = ThisHeight / MaxHeight

Step 6: Determine Handling Unit Type for Equivalent Calculation

Determine which handling unit type was actually used:

1. Use DocumentLine."Handling Unit Type Code" if available
2. Otherwise, get from Customer Item (Shipment or Receipt)
3. This is the handling unit type that will be converted to EUR equivalent

Step 7: Get Default Handling Unit Type (EUR Pallet)

Retrieve the default handling unit type from WMS Setup (typically EUR pallet).

Step 8: Calculate Equivalent Factor

Calculate the surface area ratio:

Equivalent = Round((CarrierType.Length × CarrierType.Width) / (EURCarrierType.Length × EURCarrierType.Width), 0.001, '>')

Step 9: Convert to EUR Equivalent

Result = BaseCarrierQty × Equivalent

Calculation Steps

Variable Definitions

• A = Number of layers (rounded up)
• B = Total height (ThisHeight)
• C = Maximum allowed height (MaxHeight)
• D = Base handling unit quantity
• E = Equivalent factor (surface area ratio)
• F = Final result (EUR pallet equivalent)

Step-by-Step Formula

1. Calculate layers:

   A = Round(Quantity / CarrierTypeUOM."Qty. per Layer", 1, '>')
   

2. Calculate base height:

   B = A × CarrierTypeUOM.Height
   

3. Add interleave height (if applicable):

   B = B + CarrierType.Height
   

4. Determine maximum height:

   C = Max(MaxHeight from Conditions, CarrierType."Pick Max. Load Height")
   

5. Calculate base handling unit quantity:

   D = B / C
   

6. Calculate equivalent factor:

   E = (CarrierType.Length × CarrierType.Width) / (EURCarrierType.Length × EURCarrierType.Width)
   E = Round(E, 0.001, '>')
   

7. Convert to EUR equivalent:

   F = D × E
   

Examples

Example 1: Basic Height Calculation with EUR Conversion

Scenario:

• Quantity = 150 pieces
• CarrierTypeUOM."Qty. per Layer" = 10 pieces
• CarrierTypeUOM.Height = 0.20 m per layer
• CarrierType."Pick Max. Load Height" = 1.60 m
• Actual handling unit type: Block pallet (1000 × 1200 mm)
• EUR pallet (default): 1200 × 800 mm
• No interleave handling units

Calculation:

1. Number of layers: A = Round(150 / 10, 1, '>') = 15 layers
2. Total height: B = 15 × 0.20 = 3.00 m
3. Maximum height: C = 1.60 m
4. Base handling unit quantity: D = 3.00 / 1.60 = 1.875 handling units
5. Equivalent factor: E = (1000 × 1200) / (1200 × 800) = 1.25
6. EUR equivalent: F = 1.875 × 1.25 = 2.344 EUR pallets

Result: 2.344 EUR pallet equivalent

Example 2: With Interleave Handling Units

Scenario:

• Quantity = 200 pieces
• CarrierTypeUOM."Qty. per Layer" = 20 pieces
• CarrierTypeUOM.Height = 0.15 m per layer
• CarrierType.Height = 0.15 m (interleave pallet)
• CarrierType."Pick Max. Load Height" = 1.50 m
• Actual handling unit type: EUR pallet (1200 × 800 mm)
• EUR pallet (default): 1200 × 800 mm
• Interleave handling units enabled

Calculation:

1. Number of layers: A = Round(200 / 20, 1, '>') = 10 layers
2. Base height: B = 10 × 0.15 = 1.50 m
3. Add interleave: B = 1.50 + 0.15 = 1.65 m
4. Maximum height: C = 1.50 m
5. Base handling unit quantity: D = 1.65 / 1.50 = 1.10 handling units
6. Equivalent factor: E = (1200 × 800) / (1200 × 800) = 1.0
7. EUR equivalent: F = 1.10 × 1.0 = 1.10 EUR pallets

Result: 1.10 EUR pallet equivalent

Example 3: Maximum Height from Conditions

Scenario:

• Quantity = 300 pieces
• CarrierTypeUOM."Qty. per Layer" = 25 pieces
• CarrierTypeUOM.Height = 0.18 m per layer
• Maximum height from conditions = 1.80 m
• Actual handling unit type: Half pallet (600 × 800 mm)
• EUR pallet (default): 1200 × 800 mm

Calculation:

1. Number of layers: A = Round(300 / 25, 1, '>') = 12 layers
2. Total height: B = 12 × 0.18 = 2.16 m
3. Maximum height: C = 1.80 m (from conditions)
4. Base handling unit quantity: D = 2.16 / 1.80 = 1.20 handling units
5. Equivalent factor: E = (600 × 800) / (1200 × 800) = 0.5
6. EUR equivalent: F = 1.20 × 0.5 = 0.60 EUR pallets

Result: 0.60 EUR pallet equivalent

Important Notes

• Height calculation is performed first, then converted to EUR equivalent
• Interleave handling units affect the height calculation before conversion
• Maximum height can come from conditions or handling unit type settings
• Equivalent factor is based on surface area (length × width)
• The result maintains the precision from the height calculation