[OFBIZ-5063] Stock Move is not working correctly when reservation record has quantity not available value at bulk location.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Release Branch 10.04, Release Branch 11.04, Release Branch 12.04, Trunk
• Component/s: order, product
• Assignee: Anil K Patel
• Reporter: Amardeep Singh Jhajj
• Created: 29/Oct/12 06:25
• Updated: 10/Nov/12 02:45
• Resolved: 10/Nov/12 02:45

Description

The problem will occur when we do stock move on reservation that have quantityNotAvailable value. A reservation with quantity was left in the original inventory item, but the Inventory Item had no Quantity on Hand.

This issue is also reported in OFBIZ-3178.

Here is the steps that I used to reproduce the bug.

After reservation at bulk location when 20 item backordered, inventory record was-

Bulk location inventory item

inventoryItemId : 10004
quantityOnHandTotal: 50
availableToProm : -20

OrderItemShipGrpInvRes -Reservation record at bulk location.

inventoryItemId : 10004
quantity: 70
quantityNotAvailable : 20

After stock move -

Bulk location inventory item

inventoryItemId : 10004
quantityOnHandTotal: 0
availableToProm : 0

Pick/Primary location inventory item
inventoryItemId : 10005
quantityOnHandTotal: 50
availableToProm : -20

Here everything seems to be working fine with Inventory Item.

OrderItemShipGrpInvRes- Reservation record at bulk location

inventoryItemId : 10004
quantity: 50
quantityNotAvailable : 0

OrderItemShipGrpInvRes-Reservation record at pick location

inventoryItemId : 10005
quantity: 70
quantityNotAvailable : 20

Here OrderItemShipGrpInvRes- Reservation record at bulk location should be removed after stock move.

Due to this bug, total reserved quantity of order was changed. For example here-

After stock move, total reserved quantity - 70 + 50 = 120. After deducting quantityNotAvailable, the order reserved quantity calculated was 100 while ordered was 70.

I am attaching the modified patch of OFBIZ-3178 for Release-10.04,11.04, 12.04 and trunk. Please review it and do the needful.

Issue Links

• is related to: OFBIZ-3178 error with stock move and reservation with quantity not available