Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0014406 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 04. Warehouse management | major | always | 2010-09-02 13:48 | 2010-09-22 00:00 | |||
Reporter | networkb | View Status | public | |||||
Assigned To | adrianromero | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP22 | |||
Status | closed | Fix in branch | pi | Fixed in SCM revision | 03ad86a81a20 | |||
Projection | none | ETA | none | Target Version | 2.50MP22 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | 2.50MP20 | SCM revision | ||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | OBPS | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0014406: The callout SL_Inventory_Locator.java does not work well in some conditions. | |||||||
Description | The 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 Solution | Modify 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. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
|
![]() |
|
(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 (viewer) 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 (viewer) 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 (viewer) 2010-09-21 10:18 |
Tested working fine |
![]() |
|||
Date Modified | Username | Field | Change |
2010-09-02 13:48 | networkb | New Issue | |
2010-09-02 13:48 | networkb | Assigned To | => adrianromero |
2010-09-02 13:48 | networkb | OBNetwork customer | => Yes |
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 |