4.3 Product Filter Codes and Physical Warehouse Dimensions
Key Takeaways
- Dynamics 365 Supply Chain Management provides 10 customizable Product Filter Codes (Code 1 to Code 10) to categorize released products for specialized warehousing, regulatory, and shipping requirements.
- Location directive queries evaluate product filter codes to direct inbound putaway work to dedicated warehouse zones (e.g., hazmat chemical vaults, refrigerated cold-storage rooms, or high-value secure cages).
- Product filter codes enforce vendor reservation constraints and customer shipping restrictions, preventing restricted goods from being sold or dispatched to unauthorized customer accounts or territories.
- Physical inventory dimensions (Gross depth, width, height, gross weight, tare weight, volume) establish the baseline metrics for warehouse location capacity checks and automated containerization.
- Unit sequence group packaging dimensions permit distinct physical dimensions per packaging tier, while the Nestable parameter and nesting offset prevent phantom space overflow for stackable goods.
4.3 Product Filter Codes and Physical Warehouse Dimensions
Quick Answer: In advanced Warehouse Management (WMS), physical and regulatory storage fit is governed by Product filter codes (Codes 1 through 10) and Physical inventory dimensions (gross depth, width, height, gross weight, tare weight, and volume). Filter codes categorize products for dynamic Location directive routing (e.g., hazmat vs. ambient storage), vendor reservation constraints, and customer shipping restrictions. Physical dimensions define the spatial footprint of an item across each level of its Unit sequence group, driving Location capacity limits and Automated containerization during outbound wave processing. For items that stack inside one another, the Nestable parameter and Nesting offset prevent artificial volumetric overflow.
Product Filter Codes (Code 1 to Code 10): Setup and Structure
Standard item groups and category hierarchies are often too broad to drive warehouse execution logic. For example, within an "Industrial Lubricants" item group, some products may be non-hazardous liquids, while others are volatile, flammable solvents requiring specialized fire-suppression storage vaults.
To provide granular classification, D365 SCM offers Product filter codes (Warehouse management > Setup > Product filters > Product filters):
- Code 1 to Code 10: Ten independent alphanumeric filter dimensions. Commonly used for Hazardous Material Class (Code 1), Temperature Control (Code 2), Security/Value Cage (Code 3), and Conveyability (Code 4).
- Product Filter Groups (
Warehouse management > Setup > Product filters > Product filter groups): Combine multiple filter codes into predefined bundles. Assigning a filter group to a released product automatically populates the corresponding individual filter codes on the item'sWarehouse managementFastTab, accelerating master data authoring.
Operational Applications of Product Filter Codes
Product filter codes actively drive automated decision-making engines across warehouse operations:
1. Location Directive Query Routing
When incoming inventory arrives at the dock, the warehouse engine evaluates Location directives (Warehouse management > Setup > Location directives) to determine the destination bin. By editing the query on the Location Directive Action, consultants add a join to the item's product filters (InventTable -> Product filter code 1):
- If
Code 1 == Flammable, the location directive selects storage bins exclusively within warehouse zoneVAULT-FLAM. - If
Code 2 == Frozen, the query restricts putaway locations to freezer rack zoneCOLD-FRZ. - If
Code 4 == Non-Conveyable, putaway directs pallets to oversized floor bulk locations rather than automated narrow-aisle racking.
2. Customer Shipping Restrictions
Certain commercial customers or jurisdictions prohibit shipping specific product categories (e.g., hazardous chemicals, aerosol propellants, or non-recyclable plastics).
Using Customer product filters (Warehouse management > Setup > Product filters > Customer product filters):
- Consultants associate specific filter codes with customer accounts or customer groups.
- If an order taker attempts to add an item carrying a restricted filter code to a sales order line for that customer, D365 SCM validates the shipping restriction and throws a blocking exception, preventing non-compliant dispatches.
3. Vendor Reservation Constraints
In specialized distribution, contracts dictate that inventory supplied by specific approved vendors can only be reserved for designated customers. Product filter codes combined with reservation queries enforce these vendor-to-customer allocation rules during wave release.
Physical Inventory Dimensions and Packaging Metrics
To calculate warehouse capacity and execute automated container packing, D365 SCM requires exact physical dimensions. These are maintained on the released product form (Manage inventory FastTab > Physical dimensions and Manage inventory tab > Packaging dimensions):
| Attribute | Field Name | Unit of Measure | Warehouse Engine Impact |
|---|---|---|---|
| Gross depth | GrossDepth | Distance (cm / in) | Length along depth axis; used for bin fit and container packing. |
| Gross width | GrossWidth | Distance (cm / in) | Width along horizontal axis; used for rack face clearance. |
| Gross height | GrossHeight | Distance (cm / in) | Height along vertical axis; validates location beam clearance. |
| Gross weight | GrossWeight | Mass (kg / lb) | Total weight of product plus packaging; checked against location beam limits. |
| Tare weight | TareWeight | Mass (kg / lb) | Weight of packaging materials alone (carton, pallet, wrapping). |
| Net weight | NetWeight | Mass (kg / lb) | Calculated as $\text{Gross weight} - \text{Tare weight}$; used for freight manifests. |
| Volume | Volume | Cubic volume ($m^3 / ft^3$) | Derived as $\text{Depth} \times \text{Width} \times \text{Height}$, or manually overridden. |
Unit Sequence Group Packaging Dimensions and Nestable Items
A product's physical dimensions change dramatically depending on the packaging level. Under Released products > Warehouse management FastTab > Packaging dimensions, consultants define distinct physical dimensions for each level in the item's Unit Sequence Group (e.g., Each, Box, Pallet).
Handling Nestable Items (Stacking Taper)
Many industrial and consumer products are nestable—meaning they stack partially inside one another when nested vertically (e.g., plastic storage bins, tapered drinking cups, buckets, trash cans, metal trays):
- The Problem: If 10 buckets (each 40 cm tall) are stacked together, a naive calculation evaluates the height as $10 \times 40\text{ cm} = 400\text{ cm}$ (4 meters tall). The system would determine that the stack exceeds location beam limits and reject putaway, even though the physical stack is only 85 cm tall.
- The D365 SCM Solution: On the item's packaging dimensions, consultants check the Nestable parameter and define the Nesting height / offset:
This accurate calculation allows D365 SCM to calculate true physical volume occupied in warehouse storage locations and shipping containers without phantom overflow errors.
Warehouse Volumetrics, Location Capacity, and Containerization
Accurate physical dimensions power two critical advanced warehouse capabilities:
1. Location Capacity Limits
On the Location profile (Warehouse management > Setup > Warehouse > Location profiles) and Location stocking limits form, consultants establish physical storage constraints:
- Maximum weight: Sum of gross weights of all items and license plates in the location cannot exceed the shelf beam load limit.
- Maximum volume: Total cubic volume of stored products cannot exceed usable bin volume.
- Stocking limits by unit/product: Restricts a bin to a maximum number of full pallets or boxes.
When wave putaway runs, the location directive evaluates these limits. If a bin cannot accommodate an incoming pallet without violating weight or volumetric thresholds, the directive moves to the next action line in search of an available location.
2. Automated Wave Containerization
During outbound order fulfillment, packing loose items into shipping cartons manually is labor-intensive. The Containerization wave process method (Warehouse management > Setup > Waves > Wave process methods) automates this during wave processing:
- The containerization engine evaluates the gross depth, width, height, and gross weight of each picked sales line against available Container types (
Warehouse management > Setup > Containers > Container types), such asSmall-Box,Medium-Box, orLarge-Tote. - The algorithm calculates optimal packing configurations, creates container records, assigns unique container License Plates, and prints carton shipping labels before workers begin picking.
Implementation Scenarios and Exam Traps
[!TIP] Exam Tip — Location Directive Query vs. Filter Groups: Product filter codes are only evaluated by location directives if an explicit join to the product filters table (
InventTable/WHSInventFilterCode) is defined in the Location Directive Action query. Creating filter codes without configuring the query has zero effect on putaway routing.
[!IMPORTANT] Exam Tip — Containerization Prerequisite: Automated containerization strictly requires accurate packaging dimensions and weights on the released product's inventory unit. If dimensions are zero or blank, the containerization wave step fails and aborts container generation.
A distribution warehouse stores both general food products and hazardous industrial cleaning chemicals. Inbound receiving dock operators receive palletized shipments containing concentrated bleach and acidic disinfectants. The warehouse manager requires that whenever warehouse putaway work is generated for these hazardous items, the mobile device must direct forklift operators strictly to storage bins located in the secured hazardous containment vault (Zone HAZMAT), while general food items are directed to standard bulk racking. How should the functional consultant configure Dynamics 365 Supply Chain Management to achieve this automated routing?
A wholesale janitorial supplier stocks tapered commercial plastic mop buckets in warehouse pallet racking. Each bucket has a gross height of 40 centimeters. When buckets are placed on storage pallets, workers nest them inside each other, such that each nested bucket adds only 6 centimeters to the total height of the stack. Warehouse supervisors report that the system falsely rejects putaway into standard 150-centimeter rack shelves after only 3 buckets, calculating a height of 120 centimeters and indicating that a fourth bucket would exceed location height capacity. How should the functional consultant resolve this volumetric calculation error?
An omni-channel retail distribution center uses automated containerization during outbound wave processing. Small electronics accessories and charging cables picked for e-commerce customer orders must be automatically assigned to appropriate cardboard shipping box types (Small, Medium, Large) during wave execution before warehouse pickers are dispatched. During wave processing testing, the containerization step runs without generating errors, but fails to assign picked items to containers, leaving work lines uncontainerized. The consultant verifies that container types, container packing policies, and wave template containerization methods are active and valid. What missing product configuration caused this issue?