[
https://issues.apache.org/jira/browse/OFBIZ-13263?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17979912#comment-17979912
]
Yashwant Dhakad commented on OFBIZ-13263:
-----------------------------------------
h3. *Work Order Reservation Implementation Plan for Substitute Product*
This implementation plan outlines enhancements to the Apache OFBiz
manufacturing module to support a robust {*}work order reservation flow{*},
including future support for {*}substitute product reservations{*}.
h3. *Objectives*
* {*}Substitute Reservation (Phase 2){*}:
Enable reservation of substitute products when primary components are
unavailable. Substitution will be tracked via a unique reference
number(wegsProductId) and controlled through configuration(allowSubstitutes).
h3. *Phased Implementation Overview*
h4. *Phase 1 – Work Order Reservation Flow*
* Implement standard inventory reservation support for work orders using the
new WorkEffortInvRes entity.
* Align the data model and service layer for manual and automatic
reservations, similar to existing order reservation logic.
h4. *Phase 2 – Substitute Product Reservation Support*
* Once the standard reservation flow is implemented and stable, enhance it to
support reservation of {*}substitute products{*}.
h3. *Data Model Enhancements*
h4. *1. Extend ProductAssoc Entity*
To control whether a BoM component can use substitute products during
reservation, extend the ProductAssoc entity as follows:
|*Field Name*|*Type*|*Default*|*Description*|
|allowSubstitutes|Indicator
(Y/N)|N|Indicates whether substitute products (defined through
productAssocTypeId = "PRODUCT_SUBSTITUTE") can be used for this BoM component
during reservation.|
*
If set to {*}'Y'{*}, the system will consider substitute product inventory.
* If set to {*}'N'{*}, only the original product will be reserved.
h5. *Purpose*
This configuration allows granular control over substitute usage in
manufacturing. It enhances flexibility and resiliency in inventory planning,
especially under supply constraints.
h3. *Service Implementations*
h4. *(To be updated after Phase 1)*
Once substitute product logic is added, both manual and automatic reservation
services will be enhanced to support substitute handling.
# *Manual Reservation Service*
* {*}Service Name{*}: reserveWorkEffortInventoryItem
* {*}Update{*}: Allow users to select substitute product inventory in the UI,
so they can choose substitute products when needed.
# *Automatic Reservation Service*
* {*}Service Name{*}: autoReserveWorkEffortInventory
* {*}Update{*}: Extend automatic logic to evaluate and reserve substitute
products based on availability and configuration.
> Add Substitute Product Support to Work Order Reservation
> --------------------------------------------------------
>
> Key: OFBIZ-13263
> URL: https://issues.apache.org/jira/browse/OFBIZ-13263
> Project: OFBiz
> Issue Type: Sub-task
> Components: manufacturing
> Affects Versions: Upcoming Branch
> Reporter: Yashwant Dhakad
> Priority: Minor
> Fix For: Upcoming Branch
>
>
> Enhance the work order reservation process to support substitute product
> usage during material shortages. This feature will allow the system to
> consider defined substitute products during reservation, ensuring production
> continuity when primary materials are not available. It will improve
> flexibility in material planning and reduce delays caused by unavailable
> stock.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
