Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0043835
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Modules] OMSminorN/A2020-04-23 11:572020-08-12 10:44
ReportervmromanosView Statuspublic 
Assigned ToTriage Omni OMS 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0043835: Inventory Status support in OMS engine

DescriptionThe OMS considers as available stock the one with qty on hand - reserved qty > 0. This is a valid and simple to understand rule: "if something is not reserved, it's available for the OMS engine".

However, there are scenarios where, for whatever reason, we might have exceptions to this rule, like for example when the stock is in the store window (valid stock but we don't want to issue) or when the stock is damaged. In these cases the OMS shouldn't take it into account.

Inventory Status should have a new flag called "Available for OMS" to control the stock that is exposed for the OMS. By default in existing installations it will be set equal to the "Available" flag.

With this new configuration, for example, the bin associated to the store window should have associated an inventory status with the "Available for OMS" flag set to false, so the OMS can automatically bypass it.


The Stock By Warehouse window, which is the input stock for the OMS engine execution, should show a new column in grid view "Quantity Available for OMS", which will be the one taken into account by the OMS engine. Existing fields "Qty on Hand" and "Nettable Qty" will remain in form view but they will be hidden in grid view.


This change represents a functional API change that should be properly communicated.

Steps To ReproduceNA
Proposed SolutionIn Inventory Status definition we will add a new mandatory Y/N column "Available for OMS", with a default value equal to the "Available" flag.

In Stock By Warehouse window we will add the new column to display the "Quantity Available for OMS".

The triggers that populate the Stock By Warehouse window (OBOMS_LOCATOR_TRG and OBOMS_STORAGE_DETAIL_TRG) should be adapted to maintain the new column. The logic is similar to the already implemented QTYNETTEABLE.

The org.openbravo.oms.retail.hook.StockByWarehouseHook OrderLoaderHook should be adapted to update the new "Quantity Available for OMS", in a similar way to the QTYNETTEABLE.

Adapt the OMS engine (StockProposedHelper.java) to use the new "Quantity Available for OMS" instead of the current quantity on hand [in insertAvailableStock() method, replace sbw.quantityOnHand by the new column].

Finally it is necessary to adapt the OMS module script that populates the Stock By Warehouse table (PopulateStockByWarehouse_data.xsql) to calculate the new column (similar logic to the already implemented QTYNETTEABLE).
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0122001)
davidverrier (reporter)
2020-08-12 10:44

We have implemented this in the Caroll projects.

- Issue History
Date Modified Username Field Change
2020-04-23 11:57 vmromanos New Issue
2020-04-23 11:57 vmromanos Assigned To => Triage Finance
2020-04-23 12:12 vmromanos Description Updated View Revisions
2020-04-28 14:22 vmromanos Summary Netteable support in OMS engine => Inventory Status support in OMS engine
2020-04-28 14:22 vmromanos Description Updated View Revisions
2020-04-28 14:22 vmromanos Proposed Solution updated
2020-08-12 10:44 davidverrier Note Added: 0122001


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker