← Inventory & Replenishment Exceptions
Lesson 3 of 4
Project stock without losing exceptions
Join trusted arrivals while keeping the stock master complete.
Do the work
- The stock master owns the product cohort.
- A LEFT JOIN preserves products with no purchase orders.
- Default missing due units to zero while leaving unknown physical stock NULL.
See the method
No matching inbound row means no known inbound units.
Read every demonstration step
- No matching inbound row means no known inbound units.
- Unknown on-hand stays unknown even when inbound is known.
- An inbound SKU absent from stock needs an exception report.
Practice independently
Exercise 1
List unmatched inbound product keys
Open practice →Exercise 2Build projected stock positions
Open practice →Take it further
Compare the product count before and after the join to catch duplicated keys.