Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011975Openbravo ERP03. Procurement managementpublic2010-01-15 09:372010-01-22 17:05
Reporternetworkb 
Assigned Toharikrishnan 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP9 
Target Version2.50MP11Fixed in Version2.50MP11 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011975: Create Lines From Goods Receipt does not update secondary unit
DescriptionI you define a secondary unit to a product, when creating the Goods Receipt by "Create Lines from" button and setting partial quantity, secondary quantity is not updated.
Steps To Reproduce1. Master Data Management || Product || Product >> UOM : set secondary unit to any product
2. Master Data Management || Product Setup || Unit of Measure: go to its unit and set Conversion for main unit to secondary unit
3. Procurement Management || Transactions || Purchase Order: create new order for any Business Partner; product=beer; quantity=20
4. Procurement Management || Transactions || Goods Receipt: create header for the Business Partner and press "Create Lines From" button
5. Choose the order and set just partial quantity=10
Realize that secondary quantity is not updated and line is created with correct partial quantity but not updated secondary quantity
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00119812.50MP11 closed rafaroda Create lines from in Good Shipment does not filter by Organization 
related to defect 0010431 closed rafaroda UOM is not properly updated in expense sheet lines. 
related to defect 00109232.50MP7 closed gorkaion The SL_ProductionPlan_WRPhase does not work properly 
related to defect 00119602.50MP14 closed harikrishnan Delivery Method is not properly updated when creating a Sales Order 
related to defect 0011807 closed harikrishnan UOM field has to be read-only in Unit of Measure > Conversion tab 
related to defect 00119432.50MP11 closed harikrishnan the quantity of line is rounded when it is created by "create from lines" in goods receipt 
related to feature request 0011911 new rmorley The conversion of UOM is performed only in one direction 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-01-15 09:37networkbNew Issue
2010-01-15 09:37networkbAssigned To => rafaroda
2010-01-15 10:44psarobeStatusnew => scheduled
2010-01-15 10:44psarobeNote Added: 0023467
2010-01-15 10:44psarobefix_in_branch => pi
2010-01-17 16:50rafarodaRelationship addedrelated to 0011981
2010-01-17 16:52rafarodaRelationship addedrelated to 0011943
2010-01-19 13:55rafarodaRelationship addedrelated to 0010431
2010-01-19 13:55rafarodaRelationship addedrelated to 0010923
2010-01-19 13:55rafarodaRelationship addedrelated to 0011960
2010-01-20 10:17harikrishnanAssigned Torafaroda => harikrishnan
2010-01-20 10:18harikrishnanNote Added: 0023599
2010-01-20 10:35hgbotCheckin
2010-01-20 10:35hgbotNote Added: 0023600
2010-01-20 10:35hgbotStatusscheduled => resolved
2010-01-20 10:35hgbotResolutionopen => fixed
2010-01-20 10:35hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ce9f54a31dc75bfae397f94a85be80e17432d703 [^]
2010-01-20 12:54rafarodaRelationship addedrelated to 0011807
2010-01-20 17:36rafarodaNote Edited: 0023599
2010-01-20 17:38rafarodaNote Deleted: 0023599
2010-01-20 17:48hgbotCheckin
2010-01-20 17:48hgbotNote Added: 0023628
2010-01-20 17:48hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/ce9f54a31dc75bfae397f94a85be80e17432d703 [^] => http://code.openbravo.com/erp/devel/pi/rev/2b1b1af06f22a72f83199eb89c9747a0e08d92be [^]
2010-01-20 17:56rafarodaNote Added: 0023629
2010-01-20 18:14rafarodaNote Added: 0023631
2010-01-21 05:55sureshbabuNote Added: 0023685
2010-01-21 05:55sureshbabuStatusresolved => closed
2010-01-21 05:55sureshbabuFixed in Version => 2.50MP11
2010-01-22 00:00anonymoussf_bug_id0 => 2936688
2010-01-22 17:05hudsonbotCheckin
2010-01-22 17:05hudsonbotNote Added: 0023748
2010-01-22 17:05hudsonbotCheckin
2010-01-22 17:05hudsonbotNote Added: 0023756
2010-01-26 08:51rafarodaRelationship addedrelated to 0011911
2010-01-26 13:48rafarodaNote Edited: 0023631

Notes
(0023467)
psarobe   
2010-01-15 10:44   
Rafa, we need to test this very carefully after is fixed. You migh want to talk with me
(0023600)
hgbot   
2010-01-20 10:35   
Repository: erp/devel/pi
Changeset: ce9f54a31dc75bfae397f94a85be80e17432d703
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Wed Jan 20 15:04:02 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/ce9f54a31dc75bfae397f94a85be80e17432d703 [^]

Fixes Issue 11975: Create Lines From Goods Receipt does not update secondary unit.

---
M src-db/database/sourcedata/AD_CALLOUT.xml
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
---
(0023628)
hgbot   
2010-01-20 17:48   
Repository: erp/devel/pi
Changeset: 2b1b1af06f22a72f83199eb89c9747a0e08d92be
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Wed Jan 20 04:05:27 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/2b1b1af06f22a72f83199eb89c9747a0e08d92be [^]

Fixes issue 11975 Now a change in Secondary Quantity field updates Quantity field in Create Lines From Receipt.

---
M src-db/database/sourcedata/AD_MODEL_OBJECT.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
---
(0023629)
rafaroda   
2010-01-20 17:56   
Steps to test the fix:

1. Create a new Unit of Measure (Master Data Management || Product Setup || Unit of Measure || Unit of Measure ) with following details.
* EDI Code =Pk
* Name=Pack

2. Navigate to "Conversion" Tab, select "To Uom"=Unit and "Multiply Rate by"=6.

3. Go to Product (Master Data Management || Product || Product )
* Select product = Beer.

4. Navigate to "UOM" Tab and create a new record with UOM="Pack".

5. Go to Purchase order(Procurement Management || Transactions || Purchase Order || Header ).
* Header:
** Select business partner (vendor/supplier) = McGiver
* Lines:
** Select Product = Beer
** Fill Order Quantity = 4 Packs (you make your order in packs of beer): Ordered Quantity is changed to 6x4 = 24 Units
* Save and complete the record.

6. Go to Goods Receipt( Procurement Management || Transactions || Goods Receipt || Header )
* Create a new record.Select the Business Partner = McGiver
* Click on Create Lines From Button.
** Under the Order drop down select the order created previously.
** You can see Quantity = 24 and Secondary Quantity = 4
** Change Secondary Quantity to 3 (supplier only sends you 3 of the 4 packs ordered): Quantity is updated to 3x6 = 18 Units
** Click on OK button.

7. Go to the Goods Receipt Line and check that:
* Order Quantity = 3 packs
* Movement Quantity = 18 Units

8. Select an Attribute Set and a Storage Bin and save.

9. Go back to the Goods Receipt Header and complete it.
(0023631)
rafaroda   
2010-01-20 18:14   
(edited on: 2010-01-26 13:48)
Please notice that the conversions between the principal UOM and the secondary UOM are always driven by the secondary UOM. This implies the following:

* You can create an order/goods/invoice line and select the order quantity (in its secondary UOM) and the conversion is made in the quantity field (to the principal UOM).

* You can Create Lines From selecting the secondary quantity (in the secondary UOM) and the conversion is made in the quantity field (to the principal UOM).

* Reverse conversions from the principal UOM to the secondary UOM are not done since they would lead to an infinite loop of conversions.

See feature request 0011911 The conversion of UOM is performed only in one direction
(0023685)
sureshbabu   
2010-01-21 05:55   
Tested working fine
(0023748)
hudsonbot   
2010-01-22 17:05   
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/ce9f54a31dc7 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/ba83bb4d9240 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15962.obx [^]
(0023756)
hudsonbot   
2010-01-22 17:05   
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/2b1b1af06f22 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/ba83bb4d9240 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15962.obx [^]