Re: Order Allocation
*Dear James,* *With minor customization reservation sequence can be modified FIFO Received, LIFO Received, FIFO Expire, LIFO Expire, Greater Unit Cost, Less Unit Cost sequence. For serialize inventory assignment and lot inventory you may need to do more customization.* *I'm not sure about the serialize inventory, but Lot data mode supported in OFBiz but no support code available.* *HTH!* Best Regards, -- Rishi Solanki *CTO, Mindpath Technology* Intelligent Solutions cell: +91-98932-87847 http://www.mindpathtech.com On Tue, Jan 7, 2020 at 4:23 AM wrote: > Is there a way to allow the user to select what products (serialized or > lot) that they would like to allocate to an order rather than have the > system auto allocate based on FIFO? > > We sell pipe by weight. Each pipe has a unique weight in pounds. If a > customer orders 1 pounds of pipe that could consist of several > different pieces of the same item. We are trying to manage via serial > number or lot. What is the best way to handle this in Ofbiz? > > Thanks, > > James >
Order Allocation
Is there a way to allow the user to select what products (serialized or lot) that they would like to allocate to an order rather than have the system auto allocate based on FIFO? We sell pipe by weight. Each pipe has a unique weight in pounds. If a customer orders 1 pounds of pipe that could consist of several different pieces of the same item. We are trying to manage via serial number or lot. What is the best way to handle this in Ofbiz? Thanks, James
Re: Order Allocation
Hi, This is already been proposed under OFBIZ-6964 <https://issues.apache.org/jira/browse/OFBIZ-6964>. HTH. -- *Suraj Khurana* | Sr. Enterprise Software Engineer HotWax Commerce by HotWax Systems Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010 On Tue, Dec 19, 2017 at 12:08 PM, Vaibhav Jain < vaibhav.j...@hotwaxsystems.com> wrote: > Hello James, > > We can enhance data model to handle the scenarios defined above: > > *FacilityAssoc* > facilityId* > facilityIdTo* > facilityAssocTypeId* > fromDate* > thruDate > sequenceNo (For Ex: A facility have more than one alternate facility then > seqneceNum is used for sequencing) > *FacilityAssocType* > facilityAssocTypeId* > description > > Please share your thoughts on this. > > Thanks & Regards > > Vaibhav Jain > Hotwax Systems, > vaibhav.j...@hotwaxsystems.com > > On Tue, Dec 12, 2017 at 7:27 PM, <ja...@productive1.com> wrote: > > > > > I have a scenario where I have 2 warehouses. I always want to ship > > products from the nearest warehouse to the client. How does ofbiz > > handle order allocation of product on sales orders to a specific > > warehouse. Can we set up customers to get products from a specific > > warehouse? > > > > Thanks, > > > > James > > >
Re: Order Allocation
Hello James, We can enhance data model to handle the scenarios defined above: *FacilityAssoc* facilityId* facilityIdTo* facilityAssocTypeId* fromDate* thruDate sequenceNo (For Ex: A facility have more than one alternate facility then seqneceNum is used for sequencing) *FacilityAssocType* facilityAssocTypeId* description Please share your thoughts on this. Thanks & Regards Vaibhav Jain Hotwax Systems, vaibhav.j...@hotwaxsystems.com On Tue, Dec 12, 2017 at 7:27 PM, <ja...@productive1.com> wrote: > > I have a scenario where I have 2 warehouses. I always want to ship > products from the nearest warehouse to the client. How does ofbiz > handle order allocation of product on sales orders to a specific > warehouse. Can we set up customers to get products from a specific > warehouse? > > Thanks, > > James >
Re: Order Allocation
This said, if you engage this way, we could maybe share the burden. OFBiz is lacking logistics aspects... Jacques Le 13/12/2017 à 17:06, Jacques Le Roux a écrit : Hi James, I think, as Suraj suggested, you have to implement that yourself... Jacques Le 13/12/2017 à 16:08, ja...@productive1.com a écrit : Thanks Suraj. Would they see the available inventory of the warehouse that is nearest to them when placing the order? Can they see all warehouse inventory from the sales order? Original Message Subject: Re: Order Allocation From: Suraj Khurana <suraj.khur...@hotwaxsystems.com> Date: Wed, December 13, 2017 2:49 am To: user@ofbiz.apache.org Hi James, IMO, OFBiz data model supports this feature but can require some custom logic implementation over it. You can use Geo related entities for it to find the nearest location and set it at ship group level in the cart that leads the current logic as it is and do reservations from nearest facility. HTH. -- Thanks and Regards, *Suraj Khurana* | Sr. Enterprise Software Engineer *HotWax Commerce* by *HotWax Systems* Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010 On Tue, Dec 12, 2017 at 7:27 PM, <ja...@productive1.com> wrote: I have a scenario where I have 2 warehouses. I always want to ship products from the nearest warehouse to the client. How does ofbiz handle order allocation of product on sales orders to a specific warehouse. Can we set up customers to get products from a specific warehouse? Thanks, James
Re: Order Allocation
Hi James, I think, as Suraj suggested, you have to implement that yourself... Jacques Le 13/12/2017 à 16:08, ja...@productive1.com a écrit : Thanks Suraj. Would they see the available inventory of the warehouse that is nearest to them when placing the order? Can they see all warehouse inventory from the sales order? Original Message Subject: Re: Order Allocation From: Suraj Khurana <suraj.khur...@hotwaxsystems.com> Date: Wed, December 13, 2017 2:49 am To: user@ofbiz.apache.org Hi James, IMO, OFBiz data model supports this feature but can require some custom logic implementation over it. You can use Geo related entities for it to find the nearest location and set it at ship group level in the cart that leads the current logic as it is and do reservations from nearest facility. HTH. -- Thanks and Regards, *Suraj Khurana* | Sr. Enterprise Software Engineer *HotWax Commerce* by *HotWax Systems* Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010 On Tue, Dec 12, 2017 at 7:27 PM, <ja...@productive1.com> wrote: I have a scenario where I have 2 warehouses. I always want to ship products from the nearest warehouse to the client. How does ofbiz handle order allocation of product on sales orders to a specific warehouse. Can we set up customers to get products from a specific warehouse? Thanks, James
RE: Order Allocation
Thanks Suraj. Would they see the available inventory of the warehouse that is nearest to them when placing the order? Can they see all warehouse inventory from the sales order? Original Message Subject: Re: Order Allocation From: Suraj Khurana <suraj.khur...@hotwaxsystems.com> Date: Wed, December 13, 2017 2:49 am To: user@ofbiz.apache.org Hi James, IMO, OFBiz data model supports this feature but can require some custom logic implementation over it. You can use Geo related entities for it to find the nearest location and set it at ship group level in the cart that leads the current logic as it is and do reservations from nearest facility. HTH. -- Thanks and Regards, *Suraj Khurana* | Sr. Enterprise Software Engineer *HotWax Commerce* by *HotWax Systems* Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010 On Tue, Dec 12, 2017 at 7:27 PM, <ja...@productive1.com> wrote: > > I have a scenario where I have 2 warehouses. I always want to ship > products from the nearest warehouse to the client. How does ofbiz > handle order allocation of product on sales orders to a specific > warehouse. Can we set up customers to get products from a specific > warehouse? > > Thanks, > > James >
Re: Order Allocation
Hi James, IMO, OFBiz data model supports this feature but can require some custom logic implementation over it. You can use Geo related entities for it to find the nearest location and set it at ship group level in the cart that leads the current logic as it is and do reservations from nearest facility. HTH. -- Thanks and Regards, *Suraj Khurana* | Sr. Enterprise Software Engineer *HotWax Commerce* by *HotWax Systems* Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010 On Tue, Dec 12, 2017 at 7:27 PM, <ja...@productive1.com> wrote: > > I have a scenario where I have 2 warehouses. I always want to ship > products from the nearest warehouse to the client. How does ofbiz > handle order allocation of product on sales orders to a specific > warehouse. Can we set up customers to get products from a specific > warehouse? > > Thanks, > > James >
Order Allocation
I have a scenario where I have 2 warehouses. I always want to ship products from the nearest warehouse to the client. How does ofbiz handle order allocation of product on sales orders to a specific warehouse. Can we set up customers to get products from a specific warehouse? Thanks, James