Table of Contents

METHOD03 - Layer EUR Equivalent

Overview

The Layer EUR Equivalent method calculates the number of handling units needed using layer-based calculation and then converts the result to EUR pallet equivalent. This allows you to standardize different handling unit types to a common EUR pallet format for comparison and planning purposes.

Purpose

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

  1. Calculating the number of handling units needed based on quantity and handling unit capacity
  2. Converting the result to EUR pallet equivalent using surface area ratio
  3. Providing a standardized handling unit count regardless of actual handling unit type used

Parameters

This method has no configurable parameters.

Algorithm

Step 1: Determine Handling Unit Type

The method determines which handling unit type to use in the following order:

  1. Use DocumentLine."Handling Unit Type Code" if available

    • Go to Step 2 if found

  2. Get handling unit type from Customer Item:

    • Try CustItem."Handling Unit Type Code (Shipment)"
    • If empty, try CustItem."Handling Unit Type Code (Receipt)"
    • Go to Step 2 if found

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

Retrieve the default handling unit type from WMS Setup:

  • This is typically configured as EUR pallet (1200 × 800 mm)
  • Used as the reference for equivalent calculation

Step 3: Get Handling Unit Type UOM

Retrieve the Handling Unit Type Unit of Measure record:

  • Look up CarrierTypeUOM for the customer item, unit of measure, and handling unit type
  • If not found, try to get from the same handling unit type group
  • If handling unit type group is empty, use the handling unit type directly

Step 4: Calculate Equivalent Factor

Calculate the surface area ratio between the actual handling unit type and EUR pallet:

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

Where:

  • CarrierType = The actual handling unit type being used
  • EURCarrierType = The default handling unit type from setup (EUR pallet)

Step 5: Calculate Base Handling Unit Quantity

Calculate the number of handling units needed:

BaseCarrierQty = Quantity / CarrierTypeUOM."Qty. per UOM Code"

Step 6: Convert to EUR Equivalent

Multiply the base handling unit quantity by the equivalent factor:

Result = Round(BaseCarrierQty × Equivalent, 0.001, '>')

Calculation Steps

Variable Definitions

  • A = Base handling unit quantity
  • B = Equivalent factor (surface area ratio)
  • C = Final result (EUR pallet equivalent)

Step-by-Step Formula

  1. Calculate base handling unit quantity:

    A = Quantity / CarrierTypeUOM."Qty. per UOM Code"

  2. Calculate equivalent factor:

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

  3. Convert to EUR equivalent:

    C = Round(A × B, 0.001, '>')

Examples

Example 1: Block Pallet to EUR Pallet

Scenario:

  • Quantity = 100 pieces
  • CarrierTypeUOM."Qty. per UOM Code" = 50 pieces per handling unit
  • Actual handling unit type: Block pallet (1000 × 1200 mm)
  • EUR pallet (default): 1200 × 800 mm

Calculation:

  1. Base handling unit quantity: A = 100 / 50 = 2 handling units
  2. Equivalent factor: B = (1000 × 1200) / (1200 × 800) = 1,200,000 / 960,000 = 1.25
  3. EUR equivalent: C = Round(2 × 1.25, 0.001, '>') = 2.5 EUR pallets

Result: 2.5 EUR pallet equivalent

Example 2: Smaller Handling Unit to EUR Pallet

Scenario:

  • Quantity = 150 pieces
  • CarrierTypeUOM."Qty. per UOM Code" = 30 pieces per handling unit
  • Actual handling unit type: Half pallet (600 × 800 mm)
  • EUR pallet (default): 1200 × 800 mm

Calculation:

  1. Base handling unit quantity: A = 150 / 30 = 5 handling units
  2. Equivalent factor: B = (600 × 800) / (1200 × 800) = 480,000 / 960,000 = 0.5
  3. EUR equivalent: C = Round(5 × 0.5, 0.001, '>') = 2.5 EUR pallets

Result: 2.5 EUR pallet equivalent

Example 3: Same as EUR Pallet

Scenario:

  • Quantity = 200 pieces
  • CarrierTypeUOM."Qty. per UOM Code" = 50 pieces per handling unit
  • Actual handling unit type: EUR pallet (1200 × 800 mm)
  • EUR pallet (default): 1200 × 800 mm

Calculation:

  1. Base handling unit quantity: A = 200 / 50 = 4 handling units
  2. Equivalent factor: B = (1200 × 800) / (1200 × 800) = 1.0
  3. EUR equivalent: C = Round(4 × 1.0, 0.001, '>') = 4.0 EUR pallets

Result: 4.0 EUR pallet equivalent (same as actual handling units since it's already EUR pallet)

Important Notes

  • The equivalent factor is based on surface area (length × width), not volume
  • Height is not considered in the equivalent calculation
  • The default handling unit type must be configured in WMS Setup
  • Both handling unit types must have Length and Width defined
  • The result is rounded to 3 decimal places
Edit this page