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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0014406
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2010-09-02 13:482010-09-22 00:00
ReporternetworkbView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version2.50MP22
StatusclosedFix in branchpiFixed in SCM revision03ad86a81a20
ProjectionnoneETAnoneTarget Version2.50MP22
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP20SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0014406: The callout SL_Inventory_Locator.java does not work well in some conditions.

DescriptionThe callout SL_Inventory_Locator.java does not work well in some conditions.
This happens when you have add a secondary UOM to a product after being working
with the product without this secondary UOM.
Steps To Reproduce-Create a product using UNIT as UOM
-Create a good receipt for this product, quantity 100.
-complete it.

-Go to phisycal inventory window. Create a new header and go to the lines.
-Create a new line selecting the product used in the shipment. See that the fields are correctly filled with the quantity 100.

-Add a new secondary UOM to the product used. i.e. kg.
-Add conversions for that new UOM- unit:10<->kg:1
-Create a new good receipt for the product using the secondary UOM. i.e: 5 kg=50 unit. Use the same locator used in the previous shipment
-complete the shipment

--Go to phisycal inventory window. Create a new header and go to the lines.
-Create a new line and select the product we are using.
-See that you have two lines for that producto. one using only the primary UOM,
and the other with the secondary UOM.
-Select the one using the secondary UOM.
-After select, the fields are filled, but another callout is executed
SL_Inventory_Locator and the fields are reseted using the information of the product without secondary UOM.

Proposed SolutionModify the select on the SL_Inventory_Locator_data.xsql and the java file in order to be able to use the new select that should have a new parameter (optional).
The change on the select should be to add a new optional parameter to use in the conditions also the secondary UOM becasue if you don't use it. the select
will select the two lines on the m_storage_detail table, the one using secondary UOM and the other that does not use it.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0030938)
hgbot (developer)
2010-09-10 13:58

Repository: erp/devel/pi
Changeset: 03ad86a81a20906459f660f55fbda5fa92274cb8
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Fri Sep 10 13:57:25 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/03ad86a81a20906459f660f55fbda5fa92274cb8 [^]

Fixes issue 0014406: The callout SL_Inventory_Locator.java does not work well in some conditions.
It has been modified the request of data to take into account the secondary UOM when available to get the correct data line

---
M src/org/openbravo/erpCommon/ad_callouts/SL_Inventory_Locator.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Inventory_Locator_data.xsql
---
(0030939)
adrianromero (manager)
2010-09-10 14:03

* Testing of the issue

Just follow the steps to test and verify that the values are properly assigned when the product is selected with the primary UOM or the secondary UOM. Verify also that the behavior of products with just one UOM has not been modified.

* Other areas affected

It has only been modified the callout of the Physical inventory lines tab SL_Inventory_Locator and its SQL associated. No other areas affected.
(0030954)
hudsonbot (developer)
2010-09-11 04:15

A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/03ad86a81a20 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/bc66d27c7c23 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18368.obx [^]
(0031257)
psarobe (manager)
2010-09-21 10:18

Tested working fine

- Issue History
Date Modified Username Field Change
2010-09-02 13:48 networkb New Issue
2010-09-02 13:48 networkb Assigned To => adrianromero
2010-09-09 11:54 adrianromero Status new => scheduled
2010-09-09 11:54 adrianromero fix_in_branch => pi
2010-09-10 13:58 hgbot Checkin
2010-09-10 13:58 hgbot Note Added: 0030938
2010-09-10 13:58 hgbot Status scheduled => resolved
2010-09-10 13:58 hgbot Resolution open => fixed
2010-09-10 13:58 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/03ad86a81a20906459f660f55fbda5fa92274cb8 [^]
2010-09-10 14:03 adrianromero Note Added: 0030939
2010-09-11 04:15 hudsonbot Checkin
2010-09-11 04:15 hudsonbot Note Added: 0030954
2010-09-21 10:18 psarobe Note Added: 0031257
2010-09-21 10:18 psarobe Status resolved => closed
2010-09-21 10:18 psarobe Fixed in Version => 2.50MP22
2010-09-22 00:00 anonymous sf_bug_id 0 => 3072971


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker