Support for replenishment of a secondary warehouse from a main warehouse

[Shrenik]

I have a use case wherein there is a website and a physical retail store.
Have created separate stores and facilities (for example, retail warehouse and
webstore warehouse) for each of them in OFBiz.
Both the stores share the same catalog/products.

However, both have different inventory management rules for the same product.
The inventory quantities can be independently managed via the facilities tab for
a product.
Where the difficulty crops up is the management of Requirements. A product can
have only one Requirement Method Enum Id (RMEI).
The webstore warehouse is the main facility at which replenishment from
suppliers and order fulfilment and shipping happens. The retail warehouse is
just stocked via indents from the webstore warehouse and does not issue direct
purchase orders to suppliers. The desired behaviour is that whenever item
quantity is below ATP for the retail warehouse, then a request to re-stock is
sent to the webstore warehouse. If it has ample quantity in stock(ATP) then it
should approve and initiate a transfer else it should generate a requirement
based on the RMEI.

I did find something in Opentaps to handle this situation but would prefer
something in pure OFBiz. I can't fathom a way to handle this scenario out of the
box in OFBiz or may be I am missing something obvious. Before I embark on some
customisation, would like to have the community's thoughts on it as this seems a
pretty routine scenario which others may have already encountered.

All thoughts are welcome.

--

Shrenik Bhura
Founder, Intelliant
Intelliant: Consulting and Development of Free / Open Source Software

[Pierre Smits]

Hi Shrenik

So you have:

   - Store A (webstore) -> associated with facility 1 (webstore facility),
   - Store B (retailstore) -> associated with facility 2 (retailstore
   facility).


You might consider defining a new requirementMethodEnumId that:

   - triggers a stock move/transfer request from the webstore facility to
   the retailstore facility when the inventory in the retailstore facility
   falls below the threshold

And create the appropriate function for this.

Best regards,

Pierre Smits

ORRTIZ.COM <http://www.orrtiz.com>
OFBiz based solutions & services

OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/

On Thu, Mar 24, 2016 at 12:32 PM, Shrenik Bhura <
[hidden email]> wrote:

> I have a use case wherein there is a website and a physical retail store.
> Have created separate stores and facilities (for example, retail warehouse
> and webstore warehouse) for each of them in OFBiz.
> Both the stores share the same catalog/products.
>
> However, both have different inventory management rules for the same
> product. The inventory quantities can be independently managed via the
> facilities tab for a product.
> Where the difficulty crops up is the management of Requirements. A product
> can have only one Requirement Method Enum Id (RMEI).
> The webstore warehouse is the main facility at which replenishment from
> suppliers and order fulfilment and shipping happens. The retail warehouse
> is just stocked via indents from the webstore warehouse and does not issue
> direct purchase orders to suppliers. The desired behaviour is that whenever
> item quantity is below ATP for the retail warehouse, then a request to
> re-stock is sent to the webstore warehouse. If it has ample quantity in
> stock(ATP) then it should approve and initiate a transfer else it should
> generate a requirement based on the RMEI.
>
> I did find something in Opentaps to handle this situation but would prefer
> something in pure OFBiz. I can't fathom a way to handle this scenario out
> of the box in OFBiz or may be I am missing something obvious. Before I
> embark on some customisation, would like to have the community's thoughts
> on it as this seems a pretty routine scenario which others may have already
> encountered.
>
> All thoughts are welcome.
>
> --
>
> Shrenik Bhura
> Founder, Intelliant
> Intelliant: Consulting and Development of Free / Open Source Software
>
>

[Pierre Smits]

Eg.:

<!-- PRODRQM_STR: request stock transfer on .... -->

    <Enumeration description="Request stock transfer" enumCode="PRODRQM_STR"
enumId="PRODRQM_STR" sequenceId="08" enumTypeId="PROD_REQ_METHOD"/>

You have to take into consideration that when there are more than one
alternative facilities it checks each to ensure it has enough inventory.

Best regards,

Pierre Smits

ORRTIZ.COM <http://www.orrtiz.com>
OFBiz based solutions & services

OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/

On Fri, Mar 25, 2016 at 12:42 PM, Pierre Smits <[hidden email]>
wrote:

> Hi Shrenik
>
> So you have:
>
>    - Store A (webstore) -> associated with facility 1 (webstore facility),
>    - Store B (retailstore) -> associated with facility 2 (retailstore
>    facility).
>
>
> You might consider defining a new requirementMethodEnumId that:
>
>    - triggers a stock move/transfer request from the webstore facility to
>    the retailstore facility when the inventory in the retailstore facility
>    falls below the threshold
>
> And create the appropriate function for this.
>
> Best regards,
>
> Pierre Smits
>
> ORRTIZ.COM <http://www.orrtiz.com>
> OFBiz based solutions & services
>
> OFBiz Extensions Marketplace
> http://oem.ofbizci.net/oci-2/
>
> On Thu, Mar 24, 2016 at 12:32 PM, Shrenik Bhura <
> [hidden email]> wrote:
>
>> I have a use case wherein there is a website and a physical retail store.
>> Have created separate stores and facilities (for example, retail
>> warehouse and webstore warehouse) for each of them in OFBiz.
>> Both the stores share the same catalog/products.
>>
>> However, both have different inventory management rules for the same
>> product. The inventory quantities can be independently managed via the
>> facilities tab for a product.
>> Where the difficulty crops up is the management of Requirements. A
>> product can have only one Requirement Method Enum Id (RMEI).
>> The webstore warehouse is the main facility at which replenishment from
>> suppliers and order fulfilment and shipping happens. The retail warehouse
>> is just stocked via indents from the webstore warehouse and does not issue
>> direct purchase orders to suppliers. The desired behaviour is that whenever
>> item quantity is below ATP for the retail warehouse, then a request to
>> re-stock is sent to the webstore warehouse. If it has ample quantity in
>> stock(ATP) then it should approve and initiate a transfer else it should
>> generate a requirement based on the RMEI.
>>
>> I did find something in Opentaps to handle this situation but would
>> prefer something in pure OFBiz. I can't fathom a way to handle this
>> scenario out of the box in OFBiz or may be I am missing something obvious.
>> Before I embark on some customisation, would like to have the community's
>> thoughts on it as this seems a pretty routine scenario which others may
>> have already encountered.
>>
>> All thoughts are welcome.
>>
>> --
>>
>> Shrenik Bhura
>> Founder, Intelliant
>> Intelliant: Consulting and Development of Free / Open Source Software
>>
>>
>

[Pierre Smits]

Looking forward to see the JIRA issue created and a patch submitted.

Best regards,

Pierre Smits

ORRTIZ.COM <http://www.orrtiz.com>
OFBiz based solutions & services

OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/

On Fri, Mar 25, 2016 at 12:50 PM, Pierre Smits <[hidden email]>
wrote:

> Eg.:
>
> <!-- PRODRQM_STR: request stock transfer on .... -->
>
>     <Enumeration description="Request stock transfer" enumCode=
> "PRODRQM_STR" enumId="PRODRQM_STR" sequenceId="08" enumTypeId=
> "PROD_REQ_METHOD"/>
>
> You have to take into consideration that when there are more than one
> alternative facilities it checks each to ensure it has enough inventory.
>
> Best regards,
>
> Pierre Smits
>
> ORRTIZ.COM <http://www.orrtiz.com>
> OFBiz based solutions & services
>
> OFBiz Extensions Marketplace
> http://oem.ofbizci.net/oci-2/
>
> On Fri, Mar 25, 2016 at 12:42 PM, Pierre Smits <[hidden email]>
> wrote:
>
>> Hi Shrenik
>>
>> So you have:
>>
>>    - Store A (webstore) -> associated with facility 1 (webstore
>>    facility),
>>    - Store B (retailstore) -> associated with facility 2 (retailstore
>>    facility).
>>
>>
>> You might consider defining a new requirementMethodEnumId that:
>>
>>    - triggers a stock move/transfer request from the webstore facility
>>    to the retailstore facility when the inventory in the retailstore facility
>>    falls below the threshold
>>
>> And create the appropriate function for this.
>>
>> Best regards,
>>
>> Pierre Smits
>>
>> ORRTIZ.COM <http://www.orrtiz.com>
>> OFBiz based solutions & services
>>
>> OFBiz Extensions Marketplace
>> http://oem.ofbizci.net/oci-2/
>>
>> On Thu, Mar 24, 2016 at 12:32 PM, Shrenik Bhura <
>> [hidden email]> wrote:
>>
>>> I have a use case wherein there is a website and a physical retail store.
>>> Have created separate stores and facilities (for example, retail
>>> warehouse and webstore warehouse) for each of them in OFBiz.
>>> Both the stores share the same catalog/products.
>>>
>>> However, both have different inventory management rules for the same
>>> product. The inventory quantities can be independently managed via the
>>> facilities tab for a product.
>>> Where the difficulty crops up is the management of Requirements. A
>>> product can have only one Requirement Method Enum Id (RMEI).
>>> The webstore warehouse is the main facility at which replenishment from
>>> suppliers and order fulfilment and shipping happens. The retail warehouse
>>> is just stocked via indents from the webstore warehouse and does not issue
>>> direct purchase orders to suppliers. The desired behaviour is that whenever
>>> item quantity is below ATP for the retail warehouse, then a request to
>>> re-stock is sent to the webstore warehouse. If it has ample quantity in
>>> stock(ATP) then it should approve and initiate a transfer else it should
>>> generate a requirement based on the RMEI.
>>>
>>> I did find something in Opentaps to handle this situation but would
>>> prefer something in pure OFBiz. I can't fathom a way to handle this
>>> scenario out of the box in OFBiz or may be I am missing something obvious.
>>> Before I embark on some customisation, would like to have the community's
>>> thoughts on it as this seems a pretty routine scenario which others may
>>> have already encountered.
>>>
>>> All thoughts are welcome.
>>>
>>> --
>>>
>>> Shrenik Bhura
>>> Founder, Intelliant
>>> Intelliant: Consulting and Development of Free / Open Source Software
>>>
>>>
>>
>

[Jacques Le Roux]

Yes please, thanks Pierre!

Jacques

Le 25/03/2016 12:51, Pierre Smits a écrit :

> Looking forward to see the JIRA issue created and a patch submitted.
>
> Best regards,
>
> Pierre Smits
>
> ORRTIZ.COM <http://www.orrtiz.com>
> OFBiz based solutions & services
>
> OFBiz Extensions Marketplace
> http://oem.ofbizci.net/oci-2/
>
> On Fri, Mar 25, 2016 at 12:50 PM, Pierre Smits <[hidden email]>
> wrote:
>
>> Eg.:
>>
>> <!-- PRODRQM_STR: request stock transfer on .... -->
>>
>>      <Enumeration description="Request stock transfer" enumCode=
>> "PRODRQM_STR" enumId="PRODRQM_STR" sequenceId="08" enumTypeId=
>> "PROD_REQ_METHOD"/>
>>
>> You have to take into consideration that when there are more than one
>> alternative facilities it checks each to ensure it has enough inventory.
>>
>> Best regards,
>>
>> Pierre Smits
>>
>> ORRTIZ.COM <http://www.orrtiz.com>
>> OFBiz based solutions & services
>>
>> OFBiz Extensions Marketplace
>> http://oem.ofbizci.net/oci-2/
>>
>> On Fri, Mar 25, 2016 at 12:42 PM, Pierre Smits <[hidden email]>
>> wrote:
>>
>>> Hi Shrenik
>>>
>>> So you have:
>>>
>>>     - Store A (webstore) -> associated with facility 1 (webstore
>>>     facility),
>>>     - Store B (retailstore) -> associated with facility 2 (retailstore
>>>     facility).
>>>
>>>
>>> You might consider defining a new requirementMethodEnumId that:
>>>
>>>     - triggers a stock move/transfer request from the webstore facility
>>>     to the retailstore facility when the inventory in the retailstore facility
>>>     falls below the threshold
>>>
>>> And create the appropriate function for this.
>>>
>>> Best regards,
>>>
>>> Pierre Smits
>>>
>>> ORRTIZ.COM <http://www.orrtiz.com>
>>> OFBiz based solutions & services
>>>
>>> OFBiz Extensions Marketplace
>>> http://oem.ofbizci.net/oci-2/
>>>
>>> On Thu, Mar 24, 2016 at 12:32 PM, Shrenik Bhura <
>>> [hidden email]> wrote:
>>>
>>>> I have a use case wherein there is a website and a physical retail store.
>>>> Have created separate stores and facilities (for example, retail
>>>> warehouse and webstore warehouse) for each of them in OFBiz.
>>>> Both the stores share the same catalog/products.
>>>>
>>>> However, both have different inventory management rules for the same
>>>> product. The inventory quantities can be independently managed via the
>>>> facilities tab for a product.
>>>> Where the difficulty crops up is the management of Requirements. A
>>>> product can have only one Requirement Method Enum Id (RMEI).
>>>> The webstore warehouse is the main facility at which replenishment from
>>>> suppliers and order fulfilment and shipping happens. The retail warehouse
>>>> is just stocked via indents from the webstore warehouse and does not issue
>>>> direct purchase orders to suppliers. The desired behaviour is that whenever
>>>> item quantity is below ATP for the retail warehouse, then a request to
>>>> re-stock is sent to the webstore warehouse. If it has ample quantity in
>>>> stock(ATP) then it should approve and initiate a transfer else it should
>>>> generate a requirement based on the RMEI.
>>>>
>>>> I did find something in Opentaps to handle this situation but would
>>>> prefer something in pure OFBiz. I can't fathom a way to handle this
>>>> scenario out of the box in OFBiz or may be I am missing something obvious.
>>>> Before I embark on some customisation, would like to have the community's
>>>> thoughts on it as this seems a pretty routine scenario which others may
>>>> have already encountered.
>>>>
>>>> All thoughts are welcome.
>>>>
>>>> --
>>>>
>>>> Shrenik Bhura
>>>> Founder, Intelliant
>>>> Intelliant: Consulting and Development of Free / Open Source Software
>>>>
>>>>

[Shrenik]

Be rest assured, a JIRA issue will be created with the feature request. And once
implemented a solution as well.
As of now it looks like the way it has been done in Opentaps is the only
workable solution.

On 25-03-2016 19:41, Jacques Le Roux wrote:

>
> Yes please, thanks Pierre!
>
> Jacques
>
> Le 25/03/2016 12:51, Pierre Smits a écrit :
>> Looking forward to see the JIRA issue created and a patch submitted.
>>
>> Best regards,
>>
>> Pierre Smits
>>

[Pierre Smits]

I don't know how OpenTabs works...

Pierre Smits

ORRTIZ.COM <http://www.orrtiz.com>
OFBiz based solutions & services

OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/

On Fri, Mar 25, 2016 at 3:30 PM, Shrenik Bhura <[hidden email]
> wrote:

> Be rest assured, a JIRA issue will be created with the feature request.
> And once implemented a solution as well.
> As of now it looks like the way it has been done in Opentaps is the only
> workable solution.
>
>
> On 25-03-2016 19:41, Jacques Le Roux wrote:
>
>>
>> Yes please, thanks Pierre!
>>
>> Jacques
>>
>> Le 25/03/2016 12:51, Pierre Smits a écrit :
>>
>>> Looking forward to see the JIRA issue created and a patch submitted.
>>>
>>> Best regards,
>>>
>>> Pierre Smits
>>>
>>>
>

[Shrenik]

JIRA issue created - https://issues.apache.org/jira/browse/OFBIZ-6964
Am not sure I shall be able to submit a patch any time soon as I don't have any development resources available as of now and neither can I develop. So am available to assist any developer who may wish to take this up.

On 2016-03-25 20:32, Pierre Smits <[hidden email]> wrote:

> I don't know how OpenTabs works...
>
> Pierre Smits
>
> ORRTIZ.COM <http://www.orrtiz.com>
> OFBiz based solutions & services
>
> OFBiz Extensions Marketplace
> http://oem.ofbizci.net/oci-2/
>
> On Fri, Mar 25, 2016 at 3:30 PM, Shrenik Bhura <[hidden email]
> > wrote:
>
> > Be rest assured, a JIRA issue will be created with the feature request.
> > And once implemented a solution as well.
> > As of now it looks like the way it has been done in Opentaps is the only
> > workable solution.
> >
> >
> > On 25-03-2016 19:41, Jacques Le Roux wrote:
> >
> >>
> >> Yes please, thanks Pierre!
> >>
> >> Jacques
> >>
> >> Le 25/03/2016 12:51, Pierre Smits a écrit :
> >>
> >>> Looking forward to see the JIRA issue created and a patch submitted.
> >>>
> >>> Best regards,
> >>>
> >>> Pierre Smits
> >>>
> >>>
> >
>

------
Sent via Pony Mail for [hidden email].
View this email online at:
https://pony-poc.apache.org/list.html?user@...