Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040675ModulesAdvanced Warehouse Operationspublic2019-04-24 17:212019-05-21 09:16
Reporterfrancisco 
Assigned Tononofrancisco 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned ToSandrahuguet
Support ticket
OBNetwork customer
Regression introduced in release
Summary0040675: [AWO back-end] doesn't find the routes assigments with Referenced inventory filter option by product
DescriptionFor this case we will try to configurate the task Put-Away with Inventory Referenced. when is assigning the route it is ignoring the route designed for the Inventory Refenced as product. If there is no alternative it will show the meesage:
"Error:
No Routing Assignment found for: Warehouse: US East Coast. Product: Camembert Cheese. Quantity: 19990. Attribute: [BB1000003]. Inventory Transaction Type: Put-Away StorageDetail"

If there is an alternative route without filter option, it will take that one.
Steps To ReproduceIssue Replicate in pi with AWO
Configuration needed:
Warehouse Definition [Window]:
We create a Route from reception to inspection Routing [Tab]
We create the Routing assignment[Tab] for Put-Away as
    Inventory Transaction: Put-away
    Routing: The previously created
    Filter option Product: Big Box
We box two different products to later put-away
We make sure we have the two products are in reception, because it is where we have create the route.
We create the route to box the products, from reception to reception because we are not moving it, it is to box the products.
In routing assignment we create the route adding the big box as product
    Inventory Transaction: Box Planned Storage Detail
    Routing: the previously created
We move the products to reception
We box the products
we try to put-away the box.
As mentioned before if there is no other route or route without filter it will give the error
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-04-24 17:21franciscoNew Issue
2019-04-24 17:21franciscoAssigned To => Triage Finance
2019-04-24 17:21franciscoResolution time => 1557871200
2019-04-24 17:26SandrahuguetAssigned ToTriage Finance => nonofrancisco
2019-04-24 23:24nonofranciscoStatusnew => scheduled
2019-04-29 23:32nonofranciscoNote Added: 0111376
2019-05-08 13:42SandrahuguetNote Edited: 0111376bug_revision_view_page.php?bugnote_id=0111376#r18729
2019-05-08 13:45SandrahuguetNote Edited: 0111376bug_revision_view_page.php?bugnote_id=0111376#r18730
2019-05-09 12:14hgbotCheckin
2019-05-09 12:14hgbotNote Added: 0111592
2019-05-09 12:14hgbotCheckin
2019-05-09 12:14hgbotNote Added: 0111593
2019-05-09 12:15SandrahuguetStatusscheduled => resolved
2019-05-09 12:15SandrahuguetResolutionopen => fixed
2019-05-09 12:16SandrahuguetReview Assigned To => Sandrahuguet
2019-05-09 12:16SandrahuguetNote Added: 0111594
2019-05-09 12:16SandrahuguetStatusresolved => closed
2019-05-10 10:44hgbotCheckin
2019-05-10 10:44hgbotNote Added: 0111619
2019-05-21 09:16hgbotCheckin
2019-05-21 09:16hgbotNote Added: 0111945
2022-09-06 17:18caristuCategoryAdvance Warehouse Operations => Advanced Warehouse Operations

Notes
(0111376)
nonofrancisco   
2019-04-29 23:32   
(edited on: 2019-05-08 13:45)
Test Plan
Log in as Openbravo
Change to role AWO QA Admin
In Warehouse Definition Window:
Select warehouse US East Coast
Create a Routing from Reception to Inspection
  Task Type: PA Goods PutAway
  IRA From: RCT
  IRA To: INS
Create a Routing from Reception to Reception
  Task Type: Box
  IRA From: RCT
  IRA To: RCT
Create an Internal Routing assignment
  Inventory Transaction: Put-away
  Routing: Reception to Inspection
  Filter option Product: Big Box
Create an Internal Routing assignment
  Inventory Transaction: Box Planned
  Routing: Reception to Reception
Create an Internal Routing assignment
  Inventory Transaction: Move Storage Detail
  Routing: STGN - RCT
Create an Storage Bin
  Search Key: INS01
  Storage Bin Group: Inspection

Move 10 unit of products Manchego Cheese and Idiazabal Cheese from Food003 to RCT201
Confirm the tasks
Box both products in RCT201 Storage bin using Big Box Referenced Inventory
Confirm tasks
Select Manchego Cheese in RCT201 with Referenced Inventory BigBox
Put Away the Storage Detail
Verify a task was generated for both Storage Details with Referenced Inventory BigBox
Verify in both tasks the Expected locator to is INS01
(0111592)
hgbot   
2019-05-09 12:14   
Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: f4facf7c17840b3f808d3a3e350d5445ba6d83c1
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed May 08 16:38:57 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/f4facf7c17840b3f808d3a3e350d5445ba6d83c1 [^]

related to issue 40675 apply new java formatting

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/task/InternalRoutingAssignmentUtils.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/task/WarehouseAlgorithmsUtils.java
---
(0111593)
hgbot   
2019-05-09 12:14   
Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: ee46eeadb4128817a32e545caa210ff9caf38963
Author: Nono Carballo <nonofce <at> gmail.com>
Date: Wed May 08 17:12:49 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/ee46eeadb4128817a32e545caa210ff9caf38963 [^]

Fix for issue 40675: Considers Referenced Inventory product when getting IR-A

Pior this fix, query to get Internal Routing Assignment just considered th
product setted in task requirement, ignoring if the storage detail containing
the product has referenced inventory.

In this fix, when selecting the product to retrieve the Internal Routing
Assignment, if the storage detail has Referenced Inventory, the Referenced
Inventory product and it's category will be used, otherwise, the product
present in task requirement and it's category will be used.

Also when getting Warehouse Algorithm Assignments, the product category of the
Referenced Inventory product, if exists, is used in the query; otherwise the
category of the product present in task requirement.

This fix also updates automated tests affected due this change.

---
M src-test/org/openbravo/warehouse/advancedwarehouseoperations/test/AWOrii_CountReferencedInventory.java
M src-test/org/openbravo/warehouse/advancedwarehouseoperations/test/AWOrii_MoveReferencedInventory.java
M src-test/org/openbravo/warehouse/advancedwarehouseoperations/test/AWOrii_OccupancyReferencedInventory.java
M src-test/org/openbravo/warehouse/advancedwarehouseoperations/test/AWOrii_ReferencedInventoryImprovementBoxTest.java
M src-test/org/openbravo/warehouse/advancedwarehouseoperations/test/AWOu07_ToleranceBoxTest.java
M src-test/org/openbravo/warehouse/advancedwarehouseoperations/test/ToleranceBaseTest.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/task/InternalRoutingAssignmentUtils.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/task/WarehouseAlgorithmsUtils.java
A src/org/openbravo/warehouse/advancedwarehouseoperations/task/ProductConsideringReferencedInventoryUtils.java
---
(0111594)
Sandrahuguet   
2019-05-09 12:16   
code review + testing OK
(0111619)
hgbot   
2019-05-10 10:44   
Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: f7f209398aac34eab40994aacd844d45fa42be25
Author: Nono Carballo <nonofce <at> gmail.com>
Date: Thu May 09 22:43:37 2019 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/f7f209398aac34eab40994aacd844d45fa42be25 [^]

Related to issue 40675: Adds javadoc and reduces class visibility to package

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/task/ProductConsideringReferencedInventoryUtils.java
---
(0111945)
hgbot   
2019-05-21 09:16   
Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: 00ad31d0288c2a76e3cd0372f2dd137399ae6b7f
Author: Nono Carballo <nonofce <at> gmail.com>
Date: Fri May 10 10:09:38 2019 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/00ad31d0288c2a76e3cd0372f2dd137399ae6b7f [^]

Related to issue 40675: Fixes AWO Occupancy Test with RI

---
M src-test/org/openbravo/warehouse/advancedwarehouseoperations/test/AWOri_ReferencedInventoryBoxTest.java
M src-test/org/openbravo/warehouse/advancedwarehouseoperations/test/AWOrii_OccupancyReferencedInventory.java
---