[
https://issues.apache.org/jira/browse/OFBIZ-6964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15214187#comment-15214187
]
Swapnil Shah commented on OFBIZ-6964:
-------------------------------------
As an alternative approach, can we try extending ProductStore with
requirementMethodEnumId (RQMEI) and enhance MRP algorithm to suggest the
product-wise requirement for given Product Store's associated Facility based on
set(RQMEI) for given ProductStore. Something like as follows:
{code}
<!-- Enumeration for ProductStore & Facility requirementhMethodEnumId -->
<Enumeration description="When ATP Reaches Minimum Stock for Product-Facility"
enumCode="STOCK_ATP" enumId="PRODRQM_STOCK_ATP" enumTypeId="PROD_REQ_METHOD"/>
<!-- ReqMEI Setting for given Product Store's Facility-->
<ProductStore storeName="OFBiz Physical Retail Store" title="Open For Retail"
inventoryFacilityId="RetailStoreWarehouse"
requirementMethodEnumId="PRODRQM_STOCK_ATP" checkInventory="N"
oneInventoryFacility="Y" productStoreId="9100" requireInventory="N"
reserveInventory="Y" reserveOrderEnumId="INVRO_FIFO_REC" />
<!-- Product Facility Setting -->
<ProductFacility daysToShip="1" facilityId="RetailStoreWarehouse"
lastInventoryCount="18.000000" minimumStock="20.000000" productId="GZ-8544"
reorderQuantity="50.000000"/>
{code}
> Support for replenishment of a secondary warehouse from a main warehouse
> ------------------------------------------------------------------------
>
> Key: OFBIZ-6964
> URL: https://issues.apache.org/jira/browse/OFBIZ-6964
> Project: OFBiz
> Issue Type: New Feature
> Components: manufacturing, product
> Reporter: Shrenik Bhura
> Labels: features
> Fix For: Upcoming Branch
>
>
> Consider a use case wherein there is a website and a physical retail store.
> Each having its own store and facility (for example, retail facility and
> webstore facility). Both the stores share the same catalog/products.
> *Store A (webstore) -> associated with facility 1 (webstore facility)*
> *Store B (retailstore) -> associated with facility 2 (retailstore facility)*
> However, both have different inventory management rules for the same product.
> Store A has a Requirement Method Enum ID (RMEI) of its own for the product
> and Store B also needs a mechanism to fulfil its own requirement.
> The inventory quantities can continue to 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 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/replenishment requests 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 facility, then a request to re-stock is sent to the webstore facility.
> In turn if the webstore facility has ample quantity in stock(ATP) then it
> should approve and initiate a transfer else it should generate a requirement
> based on its RMEI setting.
> There doesn't seem to be an out of the box solution for this in OFBiz. This
> could work if either we build in support for store specific RMEI or there is
> another solution that I have encountered in Opentaps (a system built atop
> OFBiz) - Introduce a facility specific *Replenishment Method Enum ID (RPMEI)*
> with values such as -
> {code:xml}
> <!-- Enumeration for ProductFacility replenishMethodEnumId -->
> <EnumerationType enumTypeId="PFAC_RESPL_METHOD" hasTable="N"
> description="Product Facility Resplenish Methods"/>
> <Enumeration enumId="PF_RM_NEVER" description="Never transfer"
> enumTypeId="PFAC_RESPL_METHOD"/>
> <Enumeration enumId="PF_RM_BACKUP" description="Transfer from backup
> warehouse if available" enumTypeId="PFAC_RESPL_METHOD"/>
> <Enumeration enumId="PF_RM_SPECIF" description="Transfer from specified
> warehouse if available" enumTypeId="PFAC_RESPL_METHOD"/>
> <Enumeration enumId="PF_RM_BACKUP_ALW" description="Always transfer from
> backup warehouse" enumTypeId="PFAC_RESPL_METHOD"/>
> <Enumeration enumId="PF_RM_SPECIF_ALW" description="Always transfer from
> specified warehouse" enumTypeId="PFAC_RESPL_METHOD"/>
> {code}
> Once a product is configured with a facility specific RPMEI, an MRP run
> should create the appropriate Inventory Transfer request and then the flow
> can continue from there.
> This seems to be a rather important feature without which many businesses
> operating brick and mortar stores as well as an ecommerce web-front can't
> easily use OFBiz.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
