Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0021589Openbravo ERP04. Warehouse managementpublic2012-09-10 13:342012-09-26 17:19
gorkaion 
dmiguelez 
normalmajoralways
closedfixed 
20Gentoo
 
3.0MP163.0MP16 
gorkaion
Core
No
0021589: Costing Migration fails if product has transactions in different uoms or attribute set
When an instance has products that have changed their UOM or Attribute Set. So they have material transactions with different UOMs or Attribute Sets the process fails. With errors like "UOM Mismatch" or "products with or without attributes"
On an instance using old engine.
1 Change the UOM of a product that has material transactions.
2 Try to run the cost migration process.
Modify the trigger in the m_transaction so it does not fail at least when the cost of the transaction is set.

Maybe the fix could be to do the UOM and Attribute Set check might on more specific scenarios:
* Inserting
* Updating some defined columns: Product, Quantity, UOM,...
No tags attached.
Issue History
2012-09-10 13:34gorkaionNew Issue
2012-09-10 13:34gorkaionAssigned To => dmiguelez
2012-09-10 13:34gorkaionModules => Core
2012-09-11 12:21dmiguelezStatusnew => scheduled
2012-09-11 12:21dmiguelezfix_in_branch => pi
2012-09-12 18:50dmiguelezNote Added: 0052037
2012-09-12 19:05dmiguelezNote Edited: 0052037bug_revision_view_page.php?bugnote_id=0052037#r3838
2012-09-18 16:41hgbotCheckin
2012-09-18 16:41hgbotNote Added: 0052209
2012-09-18 16:42hgbotStatusscheduled => resolved
2012-09-18 16:42hgbotResolutionopen => fixed
2012-09-18 16:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/292bdf82cd53cd0b665263914b60bb94fd3b1132 [^]
2012-09-18 16:43gorkaionClosed by => gorkaion
2012-09-18 16:43gorkaionStatusresolved => closed
2012-09-18 16:43gorkaionFixed in Version => 3.0MP16
2012-09-26 17:19hudsonbotCheckin
2012-09-26 17:19hudsonbotNote Added: 0052780

Notes
(0052037)
dmiguelez   
2012-09-12 18:50   
(edited on: 2012-09-12 19:05)
Test Plan:

On an instance using old engine.
1 Change the UOM of a product that has material transactions.
2 Update Core and run the Costing Migration Process. It should not fail because of UOM Mismatch or because exists Products with or without attributes. If everything else is OK, it should Migrate without problems.

(0052209)
hgbot   
2012-09-18 16:41   
Repository: erp/devel/pi
Changeset: 292bdf82cd53cd0b665263914b60bb94fd3b1132
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu Sep 13 19:27:19 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/292bdf82cd53cd0b665263914b60bb94fd3b1132 [^]

Fixes issue 21589: Checks what columns are updated before doing
other operations.

---
M src-db/database/model/triggers/M_TRANSACTION_TRG.xml
---
(0052780)
hudsonbot   
2012-09-26 17:19   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b780e90c6452 [^]

Maturity status: Test