From notifications-return-32257-archive-asf-public=cust-asf.ponee.io@ofbiz.apache.org Sun Mar 15 07:13:03 2020 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id CBA6B18066D for ; Sun, 15 Mar 2020 08:13:02 +0100 (CET) Received: (qmail 14749 invoked by uid 500); 15 Mar 2020 07:13:02 -0000 Mailing-List: contact notifications-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ofbiz.apache.org Delivered-To: mailing list notifications@ofbiz.apache.org Received: (qmail 14739 invoked by uid 99); 15 Mar 2020 07:13:02 -0000 Received: from mailrelay1-us-west.apache.org (HELO mailrelay1-us-west.apache.org) (209.188.14.139) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 15 Mar 2020 07:13:02 +0000 Received: from jira-he-de.apache.org (static.172.67.40.188.clients.your-server.de [188.40.67.172]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id E8198E2D8D for ; Sun, 15 Mar 2020 07:13:00 +0000 (UTC) Received: from jira-he-de.apache.org (localhost.localdomain [127.0.0.1]) by jira-he-de.apache.org (ASF Mail Server at jira-he-de.apache.org) with ESMTP id 4260C780309 for ; Sun, 15 Mar 2020 07:13:00 +0000 (UTC) Date: Sun, 15 Mar 2020 07:13:00 +0000 (UTC) From: "Swapnil Shah (Jira)" To: notifications@ofbiz.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (OFBIZ-11457) Expected arrival of Incoming Shipment needs to be reflected over back-order MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Swapnil Shah created OFBIZ-11457: ------------------------------------ Summary: Expected arrival of Incoming Shipment needs to be ref= lected over back-order Key: OFBIZ-11457 URL: https://issues.apache.org/jira/browse/OFBIZ-11457 Project: OFBiz Issue Type: New Feature Components: order Affects Versions: 17.12.02 Reporter: Swapnil Shah *Business Case* Many a times its required to promise the delivery date to customers for her= sales orders that are back-order (BO) based on the expected arrival of fut= ure incoming/purchase shipments. Currently its not possible without either = manually pegging the supply to demand or running the whole MRP engine. *Possible Solution* To solve for this problem on real time basis, the Reservation flow can be l= everaged as that makes the determination whether the punched in sales order= (or demand for production run for that matter) is going to be backordered = or not. If and when there is SHIPMENT.ESTIMATED_ARRIVAL_DATE available against the = scheduled or incoming receipts in the system say with SHIPMENT_TYPE_ID=3DPU= RCHASE_SHIPMENT (or INCOMING_SHIPMENT) then the reservation or post-reserva= tion run can be triggered to peg and allocate the expected shipment volume = to backorders on FIFO basis and inherit the earliest SHIPMENT.ESTIMATED_ARR= IVAL_DATE over=C2=A0 ORDER_ITEM_SHIP_GRP_INV_RES.PROMISED_DATETIME which ca= n be promised and communicated to customer. *Use Cases* 1. Product=C2=A0GZ-2644 has 50 units backordered across 2 sales order place= d on different dates: ORDER_1 : Placed as BO on 01/01/2020 with Order Qty =3D 30 units with all u= nits backordered ORDER_2 : Placed as BO on 01/03/2020 with Order Qty =3D 20 units=C2=A0with = all units backordered Two Shipments for Product=C2=A0GZ-2644 scheduled to arrive on different dat= es as follows: SHIPMENT_1 : Estimated Arrival Date on 01/25/2020 with Qty=3D20 units SHIPMENT_2=C2=A0: Estimated Arrival Date on 01/31/2020 with Qty=3D40 units _*Expected Result*_ Upon reservation, here is how they would get their promised date: ORDER_1: Although its pegged to both the shipment (i.e., 20 units from SHIP= MENT_1 and 10 units from SHIPMENT_2) but gets the Promise Date of=C2=A001/2= 5/2020 (as shortness takes precedence over lateness) ORDER_2: It gets pegged to second shipment (20 units from SHIPMENT_2) and g= ets the Promise Date of 01/31/2020=C2=A0 2.=C2=A0Product=C2=A0GZ-2644 has 50 units backordered across 2 sales order = placed on different dates but also has Safety Stock threshold of 30 units t= o be maintained: ORDER_1 : Placed as BO on 01/01/2020 with Order Qty =3D 30 units with all u= nits backordered ORDER_2 : Placed as BO on 01/03/2020 with Order Qty =3D 20 units=C2=A0with = all units backordered Two Shipments for Product=C2=A0GZ-2644 scheduled to arrive on different dat= es as follows: SHIPMENT_1 : Estimated Arrival Date on 01/25/2020 with Qty=3D20 units SHIPMENT_2=C2=A0: Estimated Arrival Date on 01/31/2020 with Qty=3D40 units _*Expected Result*_ Upon reservation, here is how they would get their promised date: ORDER_1: After allocating 30 units for Safety Stock (i,e., 20 units from SH= IPMENT_1 and 10 units from SHIPMENT_2), its pegged to the second shipment (= i.e., 20 units left from SHIPMENT_2) and gets the Promise Date of=C2=A001/3= 1/2020 (as Safety Stock takes precedence over sales orders) ORDER_2: It gets no shipment left to peg to and hence no promised date or c= an be defaulted based on average lead time from supplier.=C2=A0=C2=A0 =C2=A0 -- This message was sent by Atlassian Jira (v8.3.4#803005)