[OFBIZ-7096] Inventory received are not getting reserved based on set Est. Delivery Date over Sales Order

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Assignee: Divesh Dutta
• Reporter: Swapnil Shah
• Created: 21/May/16 06:26
• Updated: 28/Nov/18 10:26

Description

Generally system would carry multiple sales order for a SKU with different Est.Delivery Date(EDD) and inventory might not be available that time when orders were created/approved.

Once we start receiving the inventory then reservations gets auto-triggered and allocated based on created/approved date by overlooking the EDD altogether.

A simple scenario could be that we have 3 different orders created in system at 3 different time stamps as follows and all 3 are backordered:
Order A>> Created on 05/21 10 AM >> EDD: 5/25
Order B>> Created on 05/21 11 AM >> EDD: 5/27
Order C>> Created on 05/21 12 AM >> EDD: 5/23

As soon as inventory is received it first get allocated to Order A whereas Order C is supposed to ship first even though it got approved later.

Expected Behavior: System should first honor the EDD and if its not set then use the existing criteria of honoring Created/Approved time stamp for allocating the reservations

Please refer to attached screenshots for reference

Issue Links

• relates to: OFBIZ-6964 Support for replenishment of a secondary warehouse from a main warehouse