Verify data before warehouse automation: Check item, unit and location fields against physical stock and records; Confirm system uses correct identifiers and dimensions for product variants; Hold work if unknown variant, conversion or location could cause errors
Image: Fulfillment Technology Guide

Warehouse Reporting

Part of Warehouse automation readiness

Checking data accuracy before adding automation equipment

Check the item, unit, location, stock and work fields that will direct a proposed warehouse automation flow.

Before equipment acts on warehouse instructions, check the fields that direct its particular flow. Match a sample of physical goods and positions to the source records and proposed messages, then resolve discrepancies that could move the wrong goods or create uncertain work.

Identify the instruction fields

Ask the integrator which fields the equipment receives and returns, and which system owns each value. A tote-to-station flow may use tote ID, contained item and quantity, source position, destination station, work ID and completion state. A pallet move may need different handling-unit and load fields. Audit the fields the proposed design actually uses.

Field groupCheck againstHold the affected flow if
Item and variantCode on goods and approved item recordA code resolves to the wrong variant
Unit and quantityPhysical pack and approved conversionA carton could be treated as one piece
LocationLabel and actual positionWork points to an obsolete or wrong position
Stock stateGoods and current recordHeld goods could enter ordinary work
Work identitySource work, equipment instruction and resultA result cannot be matched or a retry could duplicate work

For an MHAX-style interface, verify both message directions: WMS outbound events are created from work lines, and equipment polls for relevant events; equipment then submits inbound events. Compare each message with the source work and the agreed interface contract, including the work-line identity used to match the result to its instruction.

Test the proposed flow with an outbound instruction, an inbound completion and an inbound short pick. Confirm that each result updates or routes the intended work as agreed. Resubmit a result in a controlled test to check whether a retry could duplicate work or cause an incorrect update; confirm the expected handling with the integrator.

Field Validation Checklist for Warehouse Automation Integration

Item and variant
Code on goods vs approved item record
Unit and quantity
Physical pack vs approved conversion
Location
Label vs actual position
Stock state
Goods vs current record
Work identity
Source work, equipment instruction, result match

Check identity with the unit

A description alone may not distinguish variants. In Dynamics 365 Supply Chain Management, Microsoft says an item number cannot uniquely identify a product variant and requires the item number together with all product dimensions defined on the product master. Confirm the identifiers and dimensions the proposed system uses for the physical unit it will handle.

For relevant single units, full cartons and mixed or partial cartons, compare the printed code, raw scan value, product record and quantity conversion. Assign an owner to approve a disputed conversion; do not fill a gap with an estimate.

Check positions and rule outcomes

Walk a sample of pick faces, reserve positions and equipment hand-off points. Record the system ID, label, goods present and observation time. Include empty or blocked positions. A location file alone does not prove that labels and physical stock agree.

Check how the proposed system chooses its next location. Microsoft's Dynamics 365 location-directive documentation describes directives as rules for identifying pick and put locations and lists fields including Unit, Restrict by unit and Round up to unit. Check the configured values and the actual rule outcome for the proposed flow, including its exception route.

Resolve and recheck discrepancies

Keep each original value, physical finding, affected work, authorised correction and recheck together. Distinguish master-data errors from current stock differences or unfinished transactions. Correct both the source record and physical label or position when both are wrong.

Set a release rule for the affected flow. An unknown variant, conversion or location that could enter an equipment instruction should hold that work. Recheck after changes to packaging, layout or message mapping.

More from Warehouse Reporting