Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2012-09-10 13:342012-09-26 17:19
ReportergorkaionView Statuspublic 
Assigned Todmiguelez 
PrioritynormalResolutionfixedFixed in Version3.0MP16
StatusclosedFix in branchpiFixed in SCM revision292bdf82cd53
ProjectionnoneETAnoneTarget Version3.0MP16
OSLinux 32 bitDatabaseOracleJava version1.5.0_15
OS VersionGentooDatabase version11gAnt version1.7.0
Product VersionSCM revision 
Review Assigned Togorkaion
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0021589: Costing Migration fails if product has transactions in different uoms or attribute set

DescriptionWhen 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"
Steps To ReproduceOn an instance using old engine.
1 Change the UOM of a product that has material transactions.
2 Try to run the cost migration process.
Proposed SolutionModify 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,...
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
dmiguelez (developer)
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.

hgbot (developer)
2012-09-18 16:41

Repository: erp/devel/pi
Changeset: 292bdf82cd53cd0b665263914b60bb94fd3b1132
Author: David Miguelez <david.miguelez <at>>
Date: Thu Sep 13 19:27:19 2012 +0200
URL: [^]

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

M src-db/database/model/triggers/M_TRANSACTION_TRG.xml
hudsonbot (developer)
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: [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2012-09-10 13:34 gorkaion New Issue
2012-09-10 13:34 gorkaion Assigned To => dmiguelez
2012-09-10 13:34 gorkaion Modules => Core
2012-09-11 12:21 dmiguelez Status new => scheduled
2012-09-11 12:21 dmiguelez fix_in_branch => pi
2012-09-12 18:50 dmiguelez Note Added: 0052037
2012-09-12 19:05 dmiguelez Note Edited: 0052037 View Revisions
2012-09-18 16:41 hgbot Checkin
2012-09-18 16:41 hgbot Note Added: 0052209
2012-09-18 16:42 hgbot Status scheduled => resolved
2012-09-18 16:42 hgbot Resolution open => fixed
2012-09-18 16:42 hgbot Fixed in SCM revision => [^]
2012-09-18 16:43 gorkaion Closed by => gorkaion
2012-09-18 16:43 gorkaion Status resolved => closed
2012-09-18 16:43 gorkaion Fixed in Version => 3.0MP16
2012-09-26 17:19 hudsonbot Checkin
2012-09-26 17:19 hudsonbot Note Added: 0052780

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker