Excel for the warehouse: receipts and picks
A warehouse workbook on the floor is two lists. Receipts: what the order said, and what you counted when it arrived. Picks: what the line asked for, and what left the location. The gap on each row is the work. A carrier promise date is not on these sheets. A reorder point is not on these sheets. You are checking quantities at the dock and at the pick face. The guide below builds both lists in one workbook. Elyx writes the difference formulas on the sheets you already use. You still count. The trial lasts 7 days, with no card.
Frequently asked questions
What is on the receipt sheet?
Order number, line, item, quantity ordered, quantity counted, and the difference. A negative difference is a short receipt.
What is on the pick sheet?
Order line, item, quantity to pick, quantity picked, and the difference. It does not record where a truck is.
Why two sheets?
A short delivery into the warehouse and a short pick out of a location are different rows. One table hides one of the two gaps.