Hi all, I'd like to get community feedback on OFBIZ-830, which touches how OFBiz reassigns inventory reservations when stock arrives while a pick is in progress.
https://issues.apache.org/jira/browse/OFBIZ-830 Short version of what I confirmed on current trunk: - Order 2 of a product with only 1 in stock -> one reservation row with quantity 2 and quantityNotAvailable 1 (1 reserved, 1 backordered). - Create a picklist for the available unit. - Receive the second unit. The backorder does NOT clear -- not on receipt, and not after the picklist completes. It only clears if the inventory balance runs again later, on some unrelated receipt. The reason: the available and backordered quantities live on the same OrderItemShipGrpInvRes row, and the picklist references that row. The reassign logic clears backorders by cancelling and re-reserving the whole row, so it (correctly) won't touch it while a picklist is active. The operational need I'd like to raise: when stock arrives during an active pick, the backordered portion should become reservable against the new stock right away -- without waiting for the pick to finish and without disturbing the pick of the already-available unit. That means reassigning only the not-available portion, i.e. splitting the reservation rather than cancel-and-re-reserve. That's a change to core reservation semantics, so before anyone codes it I'd like input on the preferred direction: - Split a reservation row on demand (keep the picked qty, move only the backordered qty to fresh stock)? Or model available vs backordered quantities as separate rows from the start so the backordered part can be reassigned independently? - For those running real fulfillment on OFBiz: is immediate mid-pick reassignment the behavior you'd expect, or do you rely on the current "settle it after the pick" behavior? Details, exact entity states, and the reproduction steps are in the Jira comment. Feedback and real-world experience much appreciated. Thanks and Regards Anil Patel CEO HotWax Systems http://www.hotwaxsystems.com Cell: + 1 509 398 3120
