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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0040675
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Advanced Warehouse Operationsmajoralways2019-04-24 17:212019-05-21 09:16
ReporterfranciscoView Statuspublic 
Assigned Tononofrancisco 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix 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 ToSandrahuguet
Regression introduced in release
Summary

0040675: [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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0111376)
nonofrancisco (developer)
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 (developer)
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 (developer)
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 (developer)
2019-05-09 12:16

code review + testing OK
(0111619)
hgbot (developer)
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 (developer)
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
---

- Issue History
Date Modified Username Field Change
2019-04-24 17:21 francisco New Issue
2019-04-24 17:21 francisco Assigned To => Triage Finance
2019-04-24 17:21 francisco Resolution time => 1557871200
2019-04-24 17:26 Sandrahuguet Assigned To Triage Finance => nonofrancisco
2019-04-24 23:24 nonofrancisco Status new => scheduled
2019-04-29 23:32 nonofrancisco Note Added: 0111376
2019-05-08 13:42 Sandrahuguet Note Edited: 0111376 View Revisions
2019-05-08 13:45 Sandrahuguet Note Edited: 0111376 View Revisions
2019-05-09 12:14 hgbot Checkin
2019-05-09 12:14 hgbot Note Added: 0111592
2019-05-09 12:14 hgbot Checkin
2019-05-09 12:14 hgbot Note Added: 0111593
2019-05-09 12:15 Sandrahuguet Status scheduled => resolved
2019-05-09 12:15 Sandrahuguet Resolution open => fixed
2019-05-09 12:16 Sandrahuguet Review Assigned To => Sandrahuguet
2019-05-09 12:16 Sandrahuguet Note Added: 0111594
2019-05-09 12:16 Sandrahuguet Status resolved => closed
2019-05-10 10:44 hgbot Checkin
2019-05-10 10:44 hgbot Note Added: 0111619
2019-05-21 09:16 hgbot Checkin
2019-05-21 09:16 hgbot Note Added: 0111945
2022-09-06 17:18 caristu Category Advance Warehouse Operations => Advanced Warehouse Operations


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker