Re: Inventory Allocation Planning

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: Inventory Allocation Planning

deepak nigam-2
Moving thread to the dev mailing list.

On Thu, Aug 16, 2018 at 3:33 PM Jacques Le Roux <
[hidden email]> wrote:

> Hi Deepak,
>
> Interesting proposition, this should be discussed in dev ML
>
> Thanks
>
> Jacques
>
>
> Le 16/08/2018 à 11:28, deepak nigam a écrit :
> > While creating orders from the backend, we have the option to set
> > parameters like 'Ship After Date' and 'Ship Before Date' to manage the
> > fulfilment cycle more efficiently. Inventory gets reserved for the
> product
> > based on a FIFO basis. Sometimes the fulfilment time for the order is
> high
> > and inventory unnecessarily gets locked for some time period.
> >
> > We can introduce a new parameter (at order item level) 'Reserve After
> Date'
> > which will indicate the date only after which reservation can happen. In
> > this way, we can manage the stock availability more efficiently.
> >
> > On Mon, Aug 13, 2018 at 10:35 AM deepak nigam <
> [hidden email]>
> > wrote:
> >
> >> Thanks, James.
> >>
> >> Here is the JIRA ticket
> >> <https://issues.apache.org/jira/browse/OFBIZ-10518> for the same. Soon
> I
> >> will share detailed design notes here and in the ticker also.
> >>
> >>
> >> Thanks & Regards
> >> --
> >> Deepak Nigam
> >>
> >> On Mon, Aug 13, 2018 at 2:17 AM <[hidden email]> wrote:
> >>
> >>> Deepak - I did not see it in OFbiz but I did in Opentaps.  I can send
> >>> you a video of the functionality
> >>>
> >>> -------- Original Message --------
> >>> Subject: Re: Inventory Allocation Planning
> >>> From: deepak nigam <[hidden email]>
> >>> Date: Thu, August 09, 2018 2:24 am
> >>> To: [hidden email], [hidden email]
> >>>
> >>> Hi James,
> >>>
> >>> Did you get a chance to confirm it in OFBiz?
> >>>
> >>>
> >>> @All,
> >>> As far as I came to know, the feature to allocate the inventory (not
> >>> actual reservation at this point) is not available OOTB. We can think
> >>> about the idea of its implementation.
> >>>
> >>>
> >>>
> >>>
> >>> Thanks & Regards
> >>> --
> >>> Deepak Nigam
> >>>
> >>>
> >>>
> >>>
> >>> On Sun, Aug 5, 2018 at 10:14 PM <[hidden email]> wrote:
> >>>
> >>> This will only allocate the current inventory.  I see it in
> >>>   opentaps...let me confirm in Ofbiz.
> >>>
> >>>   -------- Original Message --------
> >>>   Subject: Re: Inventory Allocation Planning
> >>>   From: deepak nigam <[hidden email]>
> >>>   Date: Fri, August 03, 2018 12:40 am
> >>>   To: [hidden email]
> >>>
> >>>   Thanks, James.
> >>>
> >>>   Will this method honour the upcoming supply also? I am more
> interested
> >>>   in a
> >>>   supply allocation plan by using which I can allocate the available
> and
> >>>   upcoming supply amongst the open orders.
> >>>
> >>>
> >>>   Thanks & Regards
> >>>   --
> >>>   Deepak Nigam
> >>>
> >>>   On Wed, Aug 1, 2018 at 12:26 AM Paul Mandeltort <[hidden email]>
> >>>   wrote:
> >>>
> >>>   > Where is this screen located? Or are you referring to the order
> >>>   > priority field in ordermgr?
> >>>   >
> >>>   > —P
> >>>   >
> >>>   > > On Jul 31, 2018, at 1:48 PM, <[hidden email]> <
> >>>   > [hidden email]> wrote:
> >>>   > >
> >>>   > >
> >>>   > > There is a way to reallocate using the order priority screen. You
> >>> can
> >>>   > > bump backorders up and give them a higher priority.
> >>>   > >
> >>>   > > Thanks,
> >>>   > >
> >>>   > > James
> >>>   > > -------- Original Message --------
> >>>   > > Subject: Inventory Allocation Planning
> >>>   > > From: deepak nigam <[hidden email]>
> >>>   > > Date: Tue, July 31, 2018 5:28 am
> >>>   > > To: [hidden email]
> >>>   > >
> >>>   > > Hi All,
> >>>   > >
> >>>   > > In the current implementation of inventory reservation flow,
> >>> inventory
> >>>   > > gets
> >>>   > > reserved for the order based on the reservation algorithm (FIFO,
> >>> LIFO
> >>>   > > etc).
> >>>   > > Many times, the fulfilment cycle of the order is too long or due
> to
> >>> some
> >>>   > > unexpected circumstances, the order holds the inventory for a
> long
> >>> time.
> >>>   > > In
> >>>   > > such scenarios, inventory availability becomes one of the major
> >>>   > > bottlenecks
> >>>   > > in fulfilling the other sales order and businesses often remains
> >>> short
> >>>   > > supplied against the demand.
> >>>   > >
> >>>   > > Is there a way to allocate the available and any future supply
> >>>   > > judiciously
> >>>   > > amongst existing customers orders by considering different
> factors
> >>> like
> >>>   > > estimated delivery dates, order priority, customer preference
> etc?
> >>>   > >
> >>>   > >
> >>>   > > Thanks & Regards
> >>>   > > --
> >>>   > > Deepak Nigam
> >>>   >
> >>>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Inventory Allocation Planning

deepak nigam-2
I have started some implementation regarding this. Here is the link for the
reference,

https://github.com/Deepak27021990/ofbiz-framework/tree/sales-allocation-plan

Thanks & Regards
--
Deepak Nigam

On Thu, Aug 16, 2018 at 5:39 PM deepak nigam <[hidden email]>
wrote:

> Moving thread to the dev mailing list.
>
> On Thu, Aug 16, 2018 at 3:33 PM Jacques Le Roux <
> [hidden email]> wrote:
>
>> Hi Deepak,
>>
>> Interesting proposition, this should be discussed in dev ML
>>
>> Thanks
>>
>> Jacques
>>
>>
>> Le 16/08/2018 à 11:28, deepak nigam a écrit :
>> > While creating orders from the backend, we have the option to set
>> > parameters like 'Ship After Date' and 'Ship Before Date' to manage the
>> > fulfilment cycle more efficiently. Inventory gets reserved for the
>> product
>> > based on a FIFO basis. Sometimes the fulfilment time for the order is
>> high
>> > and inventory unnecessarily gets locked for some time period.
>> >
>> > We can introduce a new parameter (at order item level) 'Reserve After
>> Date'
>> > which will indicate the date only after which reservation can happen. In
>> > this way, we can manage the stock availability more efficiently.
>> >
>> > On Mon, Aug 13, 2018 at 10:35 AM deepak nigam <
>> [hidden email]>
>> > wrote:
>> >
>> >> Thanks, James.
>> >>
>> >> Here is the JIRA ticket
>> >> <https://issues.apache.org/jira/browse/OFBIZ-10518> for the same.
>> Soon I
>> >> will share detailed design notes here and in the ticker also.
>> >>
>> >>
>> >> Thanks & Regards
>> >> --
>> >> Deepak Nigam
>> >>
>> >> On Mon, Aug 13, 2018 at 2:17 AM <[hidden email]> wrote:
>> >>
>> >>> Deepak - I did not see it in OFbiz but I did in Opentaps.  I can send
>> >>> you a video of the functionality
>> >>>
>> >>> -------- Original Message --------
>> >>> Subject: Re: Inventory Allocation Planning
>> >>> From: deepak nigam <[hidden email]>
>> >>> Date: Thu, August 09, 2018 2:24 am
>> >>> To: [hidden email], [hidden email]
>> >>>
>> >>> Hi James,
>> >>>
>> >>> Did you get a chance to confirm it in OFBiz?
>> >>>
>> >>>
>> >>> @All,
>> >>> As far as I came to know, the feature to allocate the inventory (not
>> >>> actual reservation at this point) is not available OOTB. We can think
>> >>> about the idea of its implementation.
>> >>>
>> >>>
>> >>>
>> >>>
>> >>> Thanks & Regards
>> >>> --
>> >>> Deepak Nigam
>> >>>
>> >>>
>> >>>
>> >>>
>> >>> On Sun, Aug 5, 2018 at 10:14 PM <[hidden email]> wrote:
>> >>>
>> >>> This will only allocate the current inventory.  I see it in
>> >>>   opentaps...let me confirm in Ofbiz.
>> >>>
>> >>>   -------- Original Message --------
>> >>>   Subject: Re: Inventory Allocation Planning
>> >>>   From: deepak nigam <[hidden email]>
>> >>>   Date: Fri, August 03, 2018 12:40 am
>> >>>   To: [hidden email]
>> >>>
>> >>>   Thanks, James.
>> >>>
>> >>>   Will this method honour the upcoming supply also? I am more
>> interested
>> >>>   in a
>> >>>   supply allocation plan by using which I can allocate the available
>> and
>> >>>   upcoming supply amongst the open orders.
>> >>>
>> >>>
>> >>>   Thanks & Regards
>> >>>   --
>> >>>   Deepak Nigam
>> >>>
>> >>>   On Wed, Aug 1, 2018 at 12:26 AM Paul Mandeltort <[hidden email]
>> >
>> >>>   wrote:
>> >>>
>> >>>   > Where is this screen located? Or are you referring to the order
>> >>>   > priority field in ordermgr?
>> >>>   >
>> >>>   > —P
>> >>>   >
>> >>>   > > On Jul 31, 2018, at 1:48 PM, <[hidden email]> <
>> >>>   > [hidden email]> wrote:
>> >>>   > >
>> >>>   > >
>> >>>   > > There is a way to reallocate using the order priority screen.
>> You
>> >>> can
>> >>>   > > bump backorders up and give them a higher priority.
>> >>>   > >
>> >>>   > > Thanks,
>> >>>   > >
>> >>>   > > James
>> >>>   > > -------- Original Message --------
>> >>>   > > Subject: Inventory Allocation Planning
>> >>>   > > From: deepak nigam <[hidden email]>
>> >>>   > > Date: Tue, July 31, 2018 5:28 am
>> >>>   > > To: [hidden email]
>> >>>   > >
>> >>>   > > Hi All,
>> >>>   > >
>> >>>   > > In the current implementation of inventory reservation flow,
>> >>> inventory
>> >>>   > > gets
>> >>>   > > reserved for the order based on the reservation algorithm (FIFO,
>> >>> LIFO
>> >>>   > > etc).
>> >>>   > > Many times, the fulfilment cycle of the order is too long or
>> due to
>> >>> some
>> >>>   > > unexpected circumstances, the order holds the inventory for a
>> long
>> >>> time.
>> >>>   > > In
>> >>>   > > such scenarios, inventory availability becomes one of the major
>> >>>   > > bottlenecks
>> >>>   > > in fulfilling the other sales order and businesses often remains
>> >>> short
>> >>>   > > supplied against the demand.
>> >>>   > >
>> >>>   > > Is there a way to allocate the available and any future supply
>> >>>   > > judiciously
>> >>>   > > amongst existing customers orders by considering different
>> factors
>> >>> like
>> >>>   > > estimated delivery dates, order priority, customer preference
>> etc?
>> >>>   > >
>> >>>   > >
>> >>>   > > Thanks & Regards
>> >>>   > > --
>> >>>   > > Deepak Nigam
>> >>>   >
>> >>>
>>
>>
Reply | Threaded
Open this post in threaded view
|

Re: Inventory Allocation Planning

Jacques Le Roux
Administrator
Hi Deepak,

Will you later provide a patch in a Jira? It's easier for review.

Jacques


Le 17/08/2018 à 07:42, deepak nigam a écrit :

> I have started some implementation regarding this. Here is the link for the
> reference,
>
> https://github.com/Deepak27021990/ofbiz-framework/tree/sales-allocation-plan
>
> Thanks & Regards
> --
> Deepak Nigam
>
> On Thu, Aug 16, 2018 at 5:39 PM deepak nigam <[hidden email]>
> wrote:
>
>> Moving thread to the dev mailing list.
>>
>> On Thu, Aug 16, 2018 at 3:33 PM Jacques Le Roux <
>> [hidden email]> wrote:
>>
>>> Hi Deepak,
>>>
>>> Interesting proposition, this should be discussed in dev ML
>>>
>>> Thanks
>>>
>>> Jacques
>>>
>>>
>>> Le 16/08/2018 à 11:28, deepak nigam a écrit :
>>>> While creating orders from the backend, we have the option to set
>>>> parameters like 'Ship After Date' and 'Ship Before Date' to manage the
>>>> fulfilment cycle more efficiently. Inventory gets reserved for the
>>> product
>>>> based on a FIFO basis. Sometimes the fulfilment time for the order is
>>> high
>>>> and inventory unnecessarily gets locked for some time period.
>>>>
>>>> We can introduce a new parameter (at order item level) 'Reserve After
>>> Date'
>>>> which will indicate the date only after which reservation can happen. In
>>>> this way, we can manage the stock availability more efficiently.
>>>>
>>>> On Mon, Aug 13, 2018 at 10:35 AM deepak nigam <
>>> [hidden email]>
>>>> wrote:
>>>>
>>>>> Thanks, James.
>>>>>
>>>>> Here is the JIRA ticket
>>>>> <https://issues.apache.org/jira/browse/OFBIZ-10518> for the same.
>>> Soon I
>>>>> will share detailed design notes here and in the ticker also.
>>>>>
>>>>>
>>>>> Thanks & Regards
>>>>> --
>>>>> Deepak Nigam
>>>>>
>>>>> On Mon, Aug 13, 2018 at 2:17 AM <[hidden email]> wrote:
>>>>>
>>>>>> Deepak - I did not see it in OFbiz but I did in Opentaps.  I can send
>>>>>> you a video of the functionality
>>>>>>
>>>>>> -------- Original Message --------
>>>>>> Subject: Re: Inventory Allocation Planning
>>>>>> From: deepak nigam <[hidden email]>
>>>>>> Date: Thu, August 09, 2018 2:24 am
>>>>>> To: [hidden email], [hidden email]
>>>>>>
>>>>>> Hi James,
>>>>>>
>>>>>> Did you get a chance to confirm it in OFBiz?
>>>>>>
>>>>>>
>>>>>> @All,
>>>>>> As far as I came to know, the feature to allocate the inventory (not
>>>>>> actual reservation at this point) is not available OOTB. We can think
>>>>>> about the idea of its implementation.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> Thanks & Regards
>>>>>> --
>>>>>> Deepak Nigam
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Sun, Aug 5, 2018 at 10:14 PM <[hidden email]> wrote:
>>>>>>
>>>>>> This will only allocate the current inventory.  I see it in
>>>>>>    opentaps...let me confirm in Ofbiz.
>>>>>>
>>>>>>    -------- Original Message --------
>>>>>>    Subject: Re: Inventory Allocation Planning
>>>>>>    From: deepak nigam <[hidden email]>
>>>>>>    Date: Fri, August 03, 2018 12:40 am
>>>>>>    To: [hidden email]
>>>>>>
>>>>>>    Thanks, James.
>>>>>>
>>>>>>    Will this method honour the upcoming supply also? I am more
>>> interested
>>>>>>    in a
>>>>>>    supply allocation plan by using which I can allocate the available
>>> and
>>>>>>    upcoming supply amongst the open orders.
>>>>>>
>>>>>>
>>>>>>    Thanks & Regards
>>>>>>    --
>>>>>>    Deepak Nigam
>>>>>>
>>>>>>    On Wed, Aug 1, 2018 at 12:26 AM Paul Mandeltort <[hidden email]
>>>>>>    wrote:
>>>>>>
>>>>>>    > Where is this screen located? Or are you referring to the order
>>>>>>    > priority field in ordermgr?
>>>>>>    >
>>>>>>    > —P
>>>>>>    >
>>>>>>    > > On Jul 31, 2018, at 1:48 PM, <[hidden email]> <
>>>>>>    > [hidden email]> wrote:
>>>>>>    > >
>>>>>>    > >
>>>>>>    > > There is a way to reallocate using the order priority screen.
>>> You
>>>>>> can
>>>>>>    > > bump backorders up and give them a higher priority.
>>>>>>    > >
>>>>>>    > > Thanks,
>>>>>>    > >
>>>>>>    > > James
>>>>>>    > > -------- Original Message --------
>>>>>>    > > Subject: Inventory Allocation Planning
>>>>>>    > > From: deepak nigam <[hidden email]>
>>>>>>    > > Date: Tue, July 31, 2018 5:28 am
>>>>>>    > > To: [hidden email]
>>>>>>    > >
>>>>>>    > > Hi All,
>>>>>>    > >
>>>>>>    > > In the current implementation of inventory reservation flow,
>>>>>> inventory
>>>>>>    > > gets
>>>>>>    > > reserved for the order based on the reservation algorithm (FIFO,
>>>>>> LIFO
>>>>>>    > > etc).
>>>>>>    > > Many times, the fulfilment cycle of the order is too long or
>>> due to
>>>>>> some
>>>>>>    > > unexpected circumstances, the order holds the inventory for a
>>> long
>>>>>> time.
>>>>>>    > > In
>>>>>>    > > such scenarios, inventory availability becomes one of the major
>>>>>>    > > bottlenecks
>>>>>>    > > in fulfilling the other sales order and businesses often remains
>>>>>> short
>>>>>>    > > supplied against the demand.
>>>>>>    > >
>>>>>>    > > Is there a way to allocate the available and any future supply
>>>>>>    > > judiciously
>>>>>>    > > amongst existing customers orders by considering different
>>> factors
>>>>>> like
>>>>>>    > > estimated delivery dates, order priority, customer preference
>>> etc?
>>>>>>    > >
>>>>>>    > >
>>>>>>    > > Thanks & Regards
>>>>>>    > > --
>>>>>>    > > Deepak Nigam
>>>>>>    >
>>>>>>
>>>

Reply | Threaded
Open this post in threaded view
|

Re: Inventory Allocation Planning

Pierre Smits-3
Without a JIRA ticket providing the necessary business and use cases, et
al, it is difficult to address this topic.

One thing to keep in mind though, is that the (ultimate) gatekeeper
regarding fulfilment of orders is the warehouse manager.


Best regards,

Pierre Smits

Apache Trafodion <https://trafodion.apache.org>, Vice President
Apache Directory <https://directory.apache.org>, PMC Member
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer

On Sat, Aug 18, 2018 at 9:01 AM, Jacques Le Roux <
[hidden email]> wrote:

> Hi Deepak,
>
> Will you later provide a patch in a Jira? It's easier for review.
>
> Jacques
>
>
>
> Le 17/08/2018 à 07:42, deepak nigam a écrit :
>
>> I have started some implementation regarding this. Here is the link for
>> the
>> reference,
>>
>> https://github.com/Deepak27021990/ofbiz-framework/tree/
>> sales-allocation-plan
>>
>> Thanks & Regards
>> --
>> Deepak Nigam
>>
>> On Thu, Aug 16, 2018 at 5:39 PM deepak nigam <[hidden email]>
>> wrote:
>>
>> Moving thread to the dev mailing list.
>>>
>>> On Thu, Aug 16, 2018 at 3:33 PM Jacques Le Roux <
>>> [hidden email]> wrote:
>>>
>>> Hi Deepak,
>>>>
>>>> Interesting proposition, this should be discussed in dev ML
>>>>
>>>> Thanks
>>>>
>>>> Jacques
>>>>
>>>>
>>>> Le 16/08/2018 à 11:28, deepak nigam a écrit :
>>>>
>>>>> While creating orders from the backend, we have the option to set
>>>>> parameters like 'Ship After Date' and 'Ship Before Date' to manage the
>>>>> fulfilment cycle more efficiently. Inventory gets reserved for the
>>>>>
>>>> product
>>>>
>>>>> based on a FIFO basis. Sometimes the fulfilment time for the order is
>>>>>
>>>> high
>>>>
>>>>> and inventory unnecessarily gets locked for some time period.
>>>>>
>>>>> We can introduce a new parameter (at order item level) 'Reserve After
>>>>>
>>>> Date'
>>>>
>>>>> which will indicate the date only after which reservation can happen.
>>>>> In
>>>>> this way, we can manage the stock availability more efficiently.
>>>>>
>>>>> On Mon, Aug 13, 2018 at 10:35 AM deepak nigam <
>>>>>
>>>> [hidden email]>
>>>>
>>>>> wrote:
>>>>>
>>>>> Thanks, James.
>>>>>>
>>>>>> Here is the JIRA ticket
>>>>>> <https://issues.apache.org/jira/browse/OFBIZ-10518> for the same.
>>>>>>
>>>>> Soon I
>>>>
>>>>> will share detailed design notes here and in the ticker also.
>>>>>>
>>>>>>
>>>>>> Thanks & Regards
>>>>>> --
>>>>>> Deepak Nigam
>>>>>>
>>>>>> On Mon, Aug 13, 2018 at 2:17 AM <[hidden email]> wrote:
>>>>>>
>>>>>> Deepak - I did not see it in OFbiz but I did in Opentaps.  I can send
>>>>>>> you a video of the functionality
>>>>>>>
>>>>>>> -------- Original Message --------
>>>>>>> Subject: Re: Inventory Allocation Planning
>>>>>>> From: deepak nigam <[hidden email]>
>>>>>>> Date: Thu, August 09, 2018 2:24 am
>>>>>>> To: [hidden email], [hidden email]
>>>>>>>
>>>>>>> Hi James,
>>>>>>>
>>>>>>> Did you get a chance to confirm it in OFBiz?
>>>>>>>
>>>>>>>
>>>>>>> @All,
>>>>>>> As far as I came to know, the feature to allocate the inventory (not
>>>>>>> actual reservation at this point) is not available OOTB. We can think
>>>>>>> about the idea of its implementation.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Thanks & Regards
>>>>>>> --
>>>>>>> Deepak Nigam
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Sun, Aug 5, 2018 at 10:14 PM <[hidden email]> wrote:
>>>>>>>
>>>>>>> This will only allocate the current inventory.  I see it in
>>>>>>>    opentaps...let me confirm in Ofbiz.
>>>>>>>
>>>>>>>    -------- Original Message --------
>>>>>>>    Subject: Re: Inventory Allocation Planning
>>>>>>>    From: deepak nigam <[hidden email]>
>>>>>>>    Date: Fri, August 03, 2018 12:40 am
>>>>>>>    To: [hidden email]
>>>>>>>
>>>>>>>    Thanks, James.
>>>>>>>
>>>>>>>    Will this method honour the upcoming supply also? I am more
>>>>>>>
>>>>>> interested
>>>>
>>>>>    in a
>>>>>>>    supply allocation plan by using which I can allocate the available
>>>>>>>
>>>>>> and
>>>>
>>>>>    upcoming supply amongst the open orders.
>>>>>>>
>>>>>>>
>>>>>>>    Thanks & Regards
>>>>>>>    --
>>>>>>>    Deepak Nigam
>>>>>>>
>>>>>>>    On Wed, Aug 1, 2018 at 12:26 AM Paul Mandeltort <
>>>>>>> [hidden email]
>>>>>>>    wrote:
>>>>>>>
>>>>>>>    > Where is this screen located? Or are you referring to the order
>>>>>>>    > priority field in ordermgr?
>>>>>>>    >
>>>>>>>    > —P
>>>>>>>    >
>>>>>>>    > > On Jul 31, 2018, at 1:48 PM, <[hidden email]> <
>>>>>>>    > [hidden email]> wrote:
>>>>>>>    > >
>>>>>>>    > >
>>>>>>>    > > There is a way to reallocate using the order priority screen.
>>>>>>>
>>>>>> You
>>>>
>>>>> can
>>>>>>>    > > bump backorders up and give them a higher priority.
>>>>>>>    > >
>>>>>>>    > > Thanks,
>>>>>>>    > >
>>>>>>>    > > James
>>>>>>>    > > -------- Original Message --------
>>>>>>>    > > Subject: Inventory Allocation Planning
>>>>>>>    > > From: deepak nigam <[hidden email]>
>>>>>>>    > > Date: Tue, July 31, 2018 5:28 am
>>>>>>>    > > To: [hidden email]
>>>>>>>    > >
>>>>>>>    > > Hi All,
>>>>>>>    > >
>>>>>>>    > > In the current implementation of inventory reservation flow,
>>>>>>> inventory
>>>>>>>    > > gets
>>>>>>>    > > reserved for the order based on the reservation algorithm
>>>>>>> (FIFO,
>>>>>>> LIFO
>>>>>>>    > > etc).
>>>>>>>    > > Many times, the fulfilment cycle of the order is too long or
>>>>>>>
>>>>>> due to
>>>>
>>>>> some
>>>>>>>    > > unexpected circumstances, the order holds the inventory for a
>>>>>>>
>>>>>> long
>>>>
>>>>> time.
>>>>>>>    > > In
>>>>>>>    > > such scenarios, inventory availability becomes one of the
>>>>>>> major
>>>>>>>    > > bottlenecks
>>>>>>>    > > in fulfilling the other sales order and businesses often
>>>>>>> remains
>>>>>>> short
>>>>>>>    > > supplied against the demand.
>>>>>>>    > >
>>>>>>>    > > Is there a way to allocate the available and any future supply
>>>>>>>    > > judiciously
>>>>>>>    > > amongst existing customers orders by considering different
>>>>>>>
>>>>>> factors
>>>>
>>>>> like
>>>>>>>    > > estimated delivery dates, order priority, customer preference
>>>>>>>
>>>>>> etc?
>>>>
>>>>>    > >
>>>>>>>    > >
>>>>>>>    > > Thanks & Regards
>>>>>>>    > > --
>>>>>>>    > > Deepak Nigam
>>>>>>>    >
>>>>>>>
>>>>>>>
>>>>
>
Reply | Threaded
Open this post in threaded view
|

Re: Inventory Allocation Planning

deepak nigam-2
Here is the JIRA ticket for the same:
https://issues.apache.org/jira/browse/OFBIZ-10518

I will provide the updated patch soon.

On Sat, Aug 18, 2018 at 5:51 PM Pierre Smits <[hidden email]> wrote:

> Without a JIRA ticket providing the necessary business and use cases, et
> al, it is difficult to address this topic.
>
> One thing to keep in mind though, is that the (ultimate) gatekeeper
> regarding fulfilment of orders is the warehouse manager.
>
>
> Best regards,
>
> Pierre Smits
>
> Apache Trafodion <https://trafodion.apache.org>, Vice President
> Apache Directory <https://directory.apache.org>, PMC Member
> Apache Incubator <https://incubator.apache.org>, committer
> *Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
> since 2008*
> Apache Steve <https://steve.apache.org>, committer
>
> On Sat, Aug 18, 2018 at 9:01 AM, Jacques Le Roux <
> [hidden email]> wrote:
>
> > Hi Deepak,
> >
> > Will you later provide a patch in a Jira? It's easier for review.
> >
> > Jacques
> >
> >
> >
> > Le 17/08/2018 à 07:42, deepak nigam a écrit :
> >
> >> I have started some implementation regarding this. Here is the link for
> >> the
> >> reference,
> >>
> >> https://github.com/Deepak27021990/ofbiz-framework/tree/
> >> sales-allocation-plan
> >>
> >> Thanks & Regards
> >> --
> >> Deepak Nigam
> >>
> >> On Thu, Aug 16, 2018 at 5:39 PM deepak nigam <
> [hidden email]>
> >> wrote:
> >>
> >> Moving thread to the dev mailing list.
> >>>
> >>> On Thu, Aug 16, 2018 at 3:33 PM Jacques Le Roux <
> >>> [hidden email]> wrote:
> >>>
> >>> Hi Deepak,
> >>>>
> >>>> Interesting proposition, this should be discussed in dev ML
> >>>>
> >>>> Thanks
> >>>>
> >>>> Jacques
> >>>>
> >>>>
> >>>> Le 16/08/2018 à 11:28, deepak nigam a écrit :
> >>>>
> >>>>> While creating orders from the backend, we have the option to set
> >>>>> parameters like 'Ship After Date' and 'Ship Before Date' to manage
> the
> >>>>> fulfilment cycle more efficiently. Inventory gets reserved for the
> >>>>>
> >>>> product
> >>>>
> >>>>> based on a FIFO basis. Sometimes the fulfilment time for the order is
> >>>>>
> >>>> high
> >>>>
> >>>>> and inventory unnecessarily gets locked for some time period.
> >>>>>
> >>>>> We can introduce a new parameter (at order item level) 'Reserve After
> >>>>>
> >>>> Date'
> >>>>
> >>>>> which will indicate the date only after which reservation can happen.
> >>>>> In
> >>>>> this way, we can manage the stock availability more efficiently.
> >>>>>
> >>>>> On Mon, Aug 13, 2018 at 10:35 AM deepak nigam <
> >>>>>
> >>>> [hidden email]>
> >>>>
> >>>>> wrote:
> >>>>>
> >>>>> Thanks, James.
> >>>>>>
> >>>>>> Here is the JIRA ticket
> >>>>>> <https://issues.apache.org/jira/browse/OFBIZ-10518> for the same.
> >>>>>>
> >>>>> Soon I
> >>>>
> >>>>> will share detailed design notes here and in the ticker also.
> >>>>>>
> >>>>>>
> >>>>>> Thanks & Regards
> >>>>>> --
> >>>>>> Deepak Nigam
> >>>>>>
> >>>>>> On Mon, Aug 13, 2018 at 2:17 AM <[hidden email]> wrote:
> >>>>>>
> >>>>>> Deepak - I did not see it in OFbiz but I did in Opentaps.  I can
> send
> >>>>>>> you a video of the functionality
> >>>>>>>
> >>>>>>> -------- Original Message --------
> >>>>>>> Subject: Re: Inventory Allocation Planning
> >>>>>>> From: deepak nigam <[hidden email]>
> >>>>>>> Date: Thu, August 09, 2018 2:24 am
> >>>>>>> To: [hidden email], [hidden email]
> >>>>>>>
> >>>>>>> Hi James,
> >>>>>>>
> >>>>>>> Did you get a chance to confirm it in OFBiz?
> >>>>>>>
> >>>>>>>
> >>>>>>> @All,
> >>>>>>> As far as I came to know, the feature to allocate the inventory
> (not
> >>>>>>> actual reservation at this point) is not available OOTB. We can
> think
> >>>>>>> about the idea of its implementation.
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>> Thanks & Regards
> >>>>>>> --
> >>>>>>> Deepak Nigam
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>> On Sun, Aug 5, 2018 at 10:14 PM <[hidden email]> wrote:
> >>>>>>>
> >>>>>>> This will only allocate the current inventory.  I see it in
> >>>>>>>    opentaps...let me confirm in Ofbiz.
> >>>>>>>
> >>>>>>>    -------- Original Message --------
> >>>>>>>    Subject: Re: Inventory Allocation Planning
> >>>>>>>    From: deepak nigam <[hidden email]>
> >>>>>>>    Date: Fri, August 03, 2018 12:40 am
> >>>>>>>    To: [hidden email]
> >>>>>>>
> >>>>>>>    Thanks, James.
> >>>>>>>
> >>>>>>>    Will this method honour the upcoming supply also? I am more
> >>>>>>>
> >>>>>> interested
> >>>>
> >>>>>    in a
> >>>>>>>    supply allocation plan by using which I can allocate the
> available
> >>>>>>>
> >>>>>> and
> >>>>
> >>>>>    upcoming supply amongst the open orders.
> >>>>>>>
> >>>>>>>
> >>>>>>>    Thanks & Regards
> >>>>>>>    --
> >>>>>>>    Deepak Nigam
> >>>>>>>
> >>>>>>>    On Wed, Aug 1, 2018 at 12:26 AM Paul Mandeltort <
> >>>>>>> [hidden email]
> >>>>>>>    wrote:
> >>>>>>>
> >>>>>>>    > Where is this screen located? Or are you referring to the
> order
> >>>>>>>    > priority field in ordermgr?
> >>>>>>>    >
> >>>>>>>    > —P
> >>>>>>>    >
> >>>>>>>    > > On Jul 31, 2018, at 1:48 PM, <[hidden email]> <
> >>>>>>>    > [hidden email]> wrote:
> >>>>>>>    > >
> >>>>>>>    > >
> >>>>>>>    > > There is a way to reallocate using the order priority
> screen.
> >>>>>>>
> >>>>>> You
> >>>>
> >>>>> can
> >>>>>>>    > > bump backorders up and give them a higher priority.
> >>>>>>>    > >
> >>>>>>>    > > Thanks,
> >>>>>>>    > >
> >>>>>>>    > > James
> >>>>>>>    > > -------- Original Message --------
> >>>>>>>    > > Subject: Inventory Allocation Planning
> >>>>>>>    > > From: deepak nigam <[hidden email]>
> >>>>>>>    > > Date: Tue, July 31, 2018 5:28 am
> >>>>>>>    > > To: [hidden email]
> >>>>>>>    > >
> >>>>>>>    > > Hi All,
> >>>>>>>    > >
> >>>>>>>    > > In the current implementation of inventory reservation flow,
> >>>>>>> inventory
> >>>>>>>    > > gets
> >>>>>>>    > > reserved for the order based on the reservation algorithm
> >>>>>>> (FIFO,
> >>>>>>> LIFO
> >>>>>>>    > > etc).
> >>>>>>>    > > Many times, the fulfilment cycle of the order is too long or
> >>>>>>>
> >>>>>> due to
> >>>>
> >>>>> some
> >>>>>>>    > > unexpected circumstances, the order holds the inventory for
> a
> >>>>>>>
> >>>>>> long
> >>>>
> >>>>> time.
> >>>>>>>    > > In
> >>>>>>>    > > such scenarios, inventory availability becomes one of the
> >>>>>>> major
> >>>>>>>    > > bottlenecks
> >>>>>>>    > > in fulfilling the other sales order and businesses often
> >>>>>>> remains
> >>>>>>> short
> >>>>>>>    > > supplied against the demand.
> >>>>>>>    > >
> >>>>>>>    > > Is there a way to allocate the available and any future
> supply
> >>>>>>>    > > judiciously
> >>>>>>>    > > amongst existing customers orders by considering different
> >>>>>>>
> >>>>>> factors
> >>>>
> >>>>> like
> >>>>>>>    > > estimated delivery dates, order priority, customer
> preference
> >>>>>>>
> >>>>>> etc?
> >>>>
> >>>>>    > >
> >>>>>>>    > >
> >>>>>>>    > > Thanks & Regards
> >>>>>>>    > > --
> >>>>>>>    > > Deepak Nigam
> >>>>>>>    >
> >>>>>>>
> >>>>>>>
> >>>>
> >
>
Reply | Threaded
Open this post in threaded view
|

Re: Inventory Allocation Planning

deepak nigam-2
Here is the JIRA ticket for the 'reserverAfterDate' feature.
https://issues.apache.org/jira/browse/OFBIZ-10534

I have uploaded the patch and screenshots of the feature.

Thanks & Regards
--
Deepak Nigam
HotWax Systems

On Mon, Aug 20, 2018 at 2:31 PM deepak nigam <[hidden email]>
wrote:

> Here is the JIRA ticket for the same:
> https://issues.apache.org/jira/browse/OFBIZ-10518
>
> I will provide the updated patch soon.
>
> On Sat, Aug 18, 2018 at 5:51 PM Pierre Smits <[hidden email]>
> wrote:
>
>> Without a JIRA ticket providing the necessary business and use cases, et
>> al, it is difficult to address this topic.
>>
>> One thing to keep in mind though, is that the (ultimate) gatekeeper
>> regarding fulfilment of orders is the warehouse manager.
>>
>>
>> Best regards,
>>
>> Pierre Smits
>>
>> Apache Trafodion <https://trafodion.apache.org>, Vice President
>> Apache Directory <https://directory.apache.org>, PMC Member
>> Apache Incubator <https://incubator.apache.org>, committer
>> *Apache OFBiz <https://ofbiz.apache.org>, contributor (without
>> privileges)
>> since 2008*
>> Apache Steve <https://steve.apache.org>, committer
>>
>> On Sat, Aug 18, 2018 at 9:01 AM, Jacques Le Roux <
>> [hidden email]> wrote:
>>
>> > Hi Deepak,
>> >
>> > Will you later provide a patch in a Jira? It's easier for review.
>> >
>> > Jacques
>> >
>> >
>> >
>> > Le 17/08/2018 à 07:42, deepak nigam a écrit :
>> >
>> >> I have started some implementation regarding this. Here is the link for
>> >> the
>> >> reference,
>> >>
>> >> https://github.com/Deepak27021990/ofbiz-framework/tree/
>> >> sales-allocation-plan
>> >>
>> >> Thanks & Regards
>> >> --
>> >> Deepak Nigam
>> >>
>> >> On Thu, Aug 16, 2018 at 5:39 PM deepak nigam <
>> [hidden email]>
>> >> wrote:
>> >>
>> >> Moving thread to the dev mailing list.
>> >>>
>> >>> On Thu, Aug 16, 2018 at 3:33 PM Jacques Le Roux <
>> >>> [hidden email]> wrote:
>> >>>
>> >>> Hi Deepak,
>> >>>>
>> >>>> Interesting proposition, this should be discussed in dev ML
>> >>>>
>> >>>> Thanks
>> >>>>
>> >>>> Jacques
>> >>>>
>> >>>>
>> >>>> Le 16/08/2018 à 11:28, deepak nigam a écrit :
>> >>>>
>> >>>>> While creating orders from the backend, we have the option to set
>> >>>>> parameters like 'Ship After Date' and 'Ship Before Date' to manage
>> the
>> >>>>> fulfilment cycle more efficiently. Inventory gets reserved for the
>> >>>>>
>> >>>> product
>> >>>>
>> >>>>> based on a FIFO basis. Sometimes the fulfilment time for the order
>> is
>> >>>>>
>> >>>> high
>> >>>>
>> >>>>> and inventory unnecessarily gets locked for some time period.
>> >>>>>
>> >>>>> We can introduce a new parameter (at order item level) 'Reserve
>> After
>> >>>>>
>> >>>> Date'
>> >>>>
>> >>>>> which will indicate the date only after which reservation can
>> happen.
>> >>>>> In
>> >>>>> this way, we can manage the stock availability more efficiently.
>> >>>>>
>> >>>>> On Mon, Aug 13, 2018 at 10:35 AM deepak nigam <
>> >>>>>
>> >>>> [hidden email]>
>> >>>>
>> >>>>> wrote:
>> >>>>>
>> >>>>> Thanks, James.
>> >>>>>>
>> >>>>>> Here is the JIRA ticket
>> >>>>>> <https://issues.apache.org/jira/browse/OFBIZ-10518> for the same.
>> >>>>>>
>> >>>>> Soon I
>> >>>>
>> >>>>> will share detailed design notes here and in the ticker also.
>> >>>>>>
>> >>>>>>
>> >>>>>> Thanks & Regards
>> >>>>>> --
>> >>>>>> Deepak Nigam
>> >>>>>>
>> >>>>>> On Mon, Aug 13, 2018 at 2:17 AM <[hidden email]> wrote:
>> >>>>>>
>> >>>>>> Deepak - I did not see it in OFbiz but I did in Opentaps.  I can
>> send
>> >>>>>>> you a video of the functionality
>> >>>>>>>
>> >>>>>>> -------- Original Message --------
>> >>>>>>> Subject: Re: Inventory Allocation Planning
>> >>>>>>> From: deepak nigam <[hidden email]>
>> >>>>>>> Date: Thu, August 09, 2018 2:24 am
>> >>>>>>> To: [hidden email], [hidden email]
>> >>>>>>>
>> >>>>>>> Hi James,
>> >>>>>>>
>> >>>>>>> Did you get a chance to confirm it in OFBiz?
>> >>>>>>>
>> >>>>>>>
>> >>>>>>> @All,
>> >>>>>>> As far as I came to know, the feature to allocate the inventory
>> (not
>> >>>>>>> actual reservation at this point) is not available OOTB. We can
>> think
>> >>>>>>> about the idea of its implementation.
>> >>>>>>>
>> >>>>>>>
>> >>>>>>>
>> >>>>>>>
>> >>>>>>> Thanks & Regards
>> >>>>>>> --
>> >>>>>>> Deepak Nigam
>> >>>>>>>
>> >>>>>>>
>> >>>>>>>
>> >>>>>>>
>> >>>>>>> On Sun, Aug 5, 2018 at 10:14 PM <[hidden email]> wrote:
>> >>>>>>>
>> >>>>>>> This will only allocate the current inventory.  I see it in
>> >>>>>>>    opentaps...let me confirm in Ofbiz.
>> >>>>>>>
>> >>>>>>>    -------- Original Message --------
>> >>>>>>>    Subject: Re: Inventory Allocation Planning
>> >>>>>>>    From: deepak nigam <[hidden email]>
>> >>>>>>>    Date: Fri, August 03, 2018 12:40 am
>> >>>>>>>    To: [hidden email]
>> >>>>>>>
>> >>>>>>>    Thanks, James.
>> >>>>>>>
>> >>>>>>>    Will this method honour the upcoming supply also? I am more
>> >>>>>>>
>> >>>>>> interested
>> >>>>
>> >>>>>    in a
>> >>>>>>>    supply allocation plan by using which I can allocate the
>> available
>> >>>>>>>
>> >>>>>> and
>> >>>>
>> >>>>>    upcoming supply amongst the open orders.
>> >>>>>>>
>> >>>>>>>
>> >>>>>>>    Thanks & Regards
>> >>>>>>>    --
>> >>>>>>>    Deepak Nigam
>> >>>>>>>
>> >>>>>>>    On Wed, Aug 1, 2018 at 12:26 AM Paul Mandeltort <
>> >>>>>>> [hidden email]
>> >>>>>>>    wrote:
>> >>>>>>>
>> >>>>>>>    > Where is this screen located? Or are you referring to the
>> order
>> >>>>>>>    > priority field in ordermgr?
>> >>>>>>>    >
>> >>>>>>>    > —P
>> >>>>>>>    >
>> >>>>>>>    > > On Jul 31, 2018, at 1:48 PM, <[hidden email]> <
>> >>>>>>>    > [hidden email]> wrote:
>> >>>>>>>    > >
>> >>>>>>>    > >
>> >>>>>>>    > > There is a way to reallocate using the order priority
>> screen.
>> >>>>>>>
>> >>>>>> You
>> >>>>
>> >>>>> can
>> >>>>>>>    > > bump backorders up and give them a higher priority.
>> >>>>>>>    > >
>> >>>>>>>    > > Thanks,
>> >>>>>>>    > >
>> >>>>>>>    > > James
>> >>>>>>>    > > -------- Original Message --------
>> >>>>>>>    > > Subject: Inventory Allocation Planning
>> >>>>>>>    > > From: deepak nigam <[hidden email]>
>> >>>>>>>    > > Date: Tue, July 31, 2018 5:28 am
>> >>>>>>>    > > To: [hidden email]
>> >>>>>>>    > >
>> >>>>>>>    > > Hi All,
>> >>>>>>>    > >
>> >>>>>>>    > > In the current implementation of inventory reservation
>> flow,
>> >>>>>>> inventory
>> >>>>>>>    > > gets
>> >>>>>>>    > > reserved for the order based on the reservation algorithm
>> >>>>>>> (FIFO,
>> >>>>>>> LIFO
>> >>>>>>>    > > etc).
>> >>>>>>>    > > Many times, the fulfilment cycle of the order is too long
>> or
>> >>>>>>>
>> >>>>>> due to
>> >>>>
>> >>>>> some
>> >>>>>>>    > > unexpected circumstances, the order holds the inventory
>> for a
>> >>>>>>>
>> >>>>>> long
>> >>>>
>> >>>>> time.
>> >>>>>>>    > > In
>> >>>>>>>    > > such scenarios, inventory availability becomes one of the
>> >>>>>>> major
>> >>>>>>>    > > bottlenecks
>> >>>>>>>    > > in fulfilling the other sales order and businesses often
>> >>>>>>> remains
>> >>>>>>> short
>> >>>>>>>    > > supplied against the demand.
>> >>>>>>>    > >
>> >>>>>>>    > > Is there a way to allocate the available and any future
>> supply
>> >>>>>>>    > > judiciously
>> >>>>>>>    > > amongst existing customers orders by considering different
>> >>>>>>>
>> >>>>>> factors
>> >>>>
>> >>>>> like
>> >>>>>>>    > > estimated delivery dates, order priority, customer
>> preference
>> >>>>>>>
>> >>>>>> etc?
>> >>>>
>> >>>>>    > >
>> >>>>>>>    > >
>> >>>>>>>    > > Thanks & Regards
>> >>>>>>>    > > --
>> >>>>>>>    > > Deepak Nigam
>> >>>>>>>    >
>> >>>>>>>
>> >>>>>>>
>> >>>>
>> >
>>
>