Inventory and transfers

Inventory positions hold stock for each entity by product, warehouse, location, lot number and custody state: Available, Held, Picked, Transit or Production. Every position shows quantity on hand, reserved quantity and available quantity, along with its carrying value. Stock layers keep the remaining quantity and value of each receipt, production output or return, so the cost of a dispatched bag can be traced to where it came from. Every change is a stock events record with its stock movements legs and the journal effect it posts.

A warehouse can hold stock owned by more than one entity. The legal owner stays on each position, so a shared depot does not merge the books of two companies.

• Reserve before promising. inventory reservations claim a position and layer for an order line, a work order material or a transfer line, and move through Soft, Hard, Picked, in transit and Consumed. A reservation is exclusive, so two orders cannot promise the same bags.
• Move stock between warehouses as a transfer. stock transfers are approved, then dispatched in full or in part. Stock in transit stays owned and keeps its cost until it is received, and any shortfall is resolved as an explicit loss quantity on stock transfer lines.
• Count blind and adjust once. count plans lock a scope with count locks, counters record counted quantities in count lines, and variances beyond the tolerances in distribution policies go to review before a single adjustment is posted.

Agree warehouse and location codes, including receiving, picking, dispatch, held, transit and production locations. Set up units of measure with their dimension and decimal places, and product units for bags and bulk with their base conversions. Decide which products are lot-controlled. Bagged cement has a limited shelf life, so agree how expiry allocations record the lot, expiry date and quantity chosen for an order line. Set count tolerances by quantity, percentage and value in the distribution policy.

The plant warehouse sends stock to a depot. The transfer is approved, and the first truck leaves with part of the quantity, so the transfer becomes partially dispatched and the dispatched quantity moves into transit custody. The rest leaves the next day and the transfer becomes in transit.

At the depot, the receipt is short by a few bags. The received quantity is recorded, the transfer becomes partially received, and the shortfall is resolved as a loss quantity with its value. The transfer then closes with quantity and value balanced between the two warehouses.

During the pilot, count a location while a pick is in progress. The lock should cover positions that appear during the count, and the adjustment should post only once after review.

• Stock by location — on-hand, reserved and available quantity by warehouse, location, product, lot and custody state.
• My pick tasks — picks assigned to you with planned start and end, order line and picked quantity.

• Dealer order to delivery: Reservations, picking and dispatch for accepted dealer orders.
• Work order to close: Material issue and output from packing work orders.

Plan the migration order for opening stock.