For most of the businesses serialized inventory tracking starts only after such eligible products come into physical existence (in Ofbiz parlance we generally try identifying it with inventory having QOH > 0). At application level as well any real & definitive serial number could be assigned once products are physically received or produced in system and are ready to be scanned/shelved at warehouse or store level for further tracking.
Backorders in Ofbiz world create nothing but virtual(dummy) inventory pegged to such orders to identify how much demand still remains unfulfilled after exhausting on hand stock. It doesn't matter whether at application level such virtual inventory data is serialized or non-serialized. Of course any virtual inventory representation in serialized from would create more data debt than non-serialized ones. So if we decide to retain BOs against serialized product tagged with non-serialized inventory (via OISGIR), upon receiving and allocating actual reservations we can make sure to release all non-serialized inventory and reserve them using available serialized inventory (having ATP > 0). Thanks & Regards, Swapnil -----Original Message----- From: james yong [mailto:[email protected]] Sent: Tuesday, December 20, 2016 11:20 AM To: [email protected] Subject: Re: Serialized Inventory issue with backorder item Hi Deepak, Issue ==== Renuka: “when we create an order for product with serialized inventory with quantity more than ATP then a negative ATP Inventory Item record is created, which is of type Non-Serialized.” Pro for using Non-Serialized type ======================== 1. As the placeholder record in Inventory Item is of type Non-Serialized, it can be used to store any number of negative ATP quantity. 2. If the sales order is cancelled, we only need to update that one record. Con for using Non-Serialized type ========================= 1. The placeholder record in Inventory Item cannot be reused when the actual Inventory Item is received. Yes we can further discuss / refine on the serialised inventory item support in the JIRA. I also concur with you that InventoryItemDetail should also be used for serialised item, and the logics for ATP/QOH of a serialised inventory item. Thank you. Regards, James Deepak Dixit-3 wrote > Hi James, > > System create new inventory item each time, it does not use single > InventoryItem for all backorder. So it create incorrect inventory > item(s) data for serialized inventory item. > I think we can refine serialized inventory item support under > https://issues.apache.org/jira/browse/OFBIZ-7762 > > As per current implementation serialized inventory logic implemented > on status, and non-serialized inventory logic implemented on > InventoryItemDetail. > > Ideally both should use IID and if item is serialized than qoh can't > be greater then one, if we go with this route than we can implement > status base check on both type of inventory item. > Like if inventory item is defective than we can set its ATP to zero > for both cases etc.... > > > > > > > > Thanks & Regards > -- > Deepak Dixit > www.hotwaxsystems.com > > On Sat, Dec 17, 2016 at 8:42 PM, james yong < > [email protected] > > wrote: > >> Hi Renuka, >> >> In this case, the non-serialized inventory acts as a placeholder to >> ensure the final ATP is correct. >> This is correct behaviour, and not a bug. >> >> Regards, >> James >> >> >> Renuka Srishti-2 wrote >> > Hello All, >> > >> > In OFBiz, when we create an order for product with serialized >> > inventory with quantity more than ATP then a negative ATP Inventory >> > Item record >> is >> > created, which is of type Non-Serialized. >> > It should be of type serialized . >> > >> > If we resolve this issue, we need to check all scenarios related to >> this >> > process. Please let me know your thoughts. If it looks good I will >> > open >> a >> > ticket for the same. >> > >> > Thanks >> > >> > -- >> > Regards, >> > Renuka Srishti >> >> >> >> >> >> -- >> View this message in context: http://ofbiz.135035.n4.nabble. >> com/Serialized-Inventory-issue-with-backorder-item-tp4700367p4700409. >> html Sent from the OFBiz - Dev mailing list archive at Nabble.com. >> -- View this message in context: http://ofbiz.135035.n4.nabble.com/Serialized-Inventory-issue-with-backorder-item-tp4700367p4700614.html Sent from the OFBiz - Dev mailing list archive at Nabble.com.
