Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028450Openbravo ERP04. Warehouse managementpublic2014-12-18 13:252014-12-30 23:28
Reporterumartirena 
Assigned Toumartirena 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR15Q1 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0028450: [Costing] Costing Migration Process fails
Description"Costing Migration Process" fails if it is executed in 3.0PR14Q4(pi).
This is due to the dateacct column is now mandatory in m_transaction_cost table and when Costing Migration Process inserts records in this table it doesn't put any value on this column.
Steps To ReproduceOn an environment in 3.0PR14Q4(pi), without having cost migrated, execute "Costing Migration Process".

Realize that the following error is displayed:
"Error:
ERROR: null value in column "dateacct" violates not-null constraint"
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
causes defect 0031972 closed aferraz Costing Migration Process:Cost of products in closing inventory is calculated by taking into account only shipments and receipts 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-12-18 13:25umartirenaNew Issue
2014-12-18 13:25umartirenaAssigned To => dmiguelez
2014-12-18 13:25umartirenaModules => Core
2014-12-18 13:25umartirenaTriggers an Emergency Pack => No
2014-12-18 13:30hgbotCheckin
2014-12-18 13:30hgbotNote Added: 0072696
2014-12-18 13:30hgbotStatusnew => resolved
2014-12-18 13:30hgbotResolutionopen => fixed
2014-12-18 13:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8dd8af8a26e56abe37438cc058bc6f45cdfc6ba8 [^]
2014-12-18 17:56SandrahuguetReview Assigned To => Sandrahuguet
2014-12-18 17:56SandrahuguetAssigned Todmiguelez => umartirena
2014-12-18 18:46SandrahuguetNote Added: 0072712
2014-12-18 18:46SandrahuguetStatusresolved => closed
2014-12-18 18:46SandrahuguetFixed in Version => 3.0PR15Q1
2014-12-30 23:28hudsonbotCheckin
2014-12-30 23:28hudsonbotNote Added: 0073243
2016-01-21 10:40ngarciaRelationship addedcauses 0031972

Notes
(0072696)
hgbot   
2014-12-18 13:30   
Repository: erp/devel/pi
Changeset: 8dd8af8a26e56abe37438cc058bc6f45cdfc6ba8
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Thu Dec 18 13:29:41 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/8dd8af8a26e56abe37438cc058bc6f45cdfc6ba8 [^]

Fixes Issue 28450: Costing Migration Process does not fail any more.

In the function insertTrxCosts() in CostingMigrationProcess.java while inserting m_transaction_cost records the column dateacct is filled in the following way:
* If the transaction is a goods shipment line, with the accounting date of the Shipment.
* If the transaction is not a goods shipment line, with the movement date of the transaction.

---
M src/org/openbravo/costing/CostingMigrationProcess.java
---
(0072712)
Sandrahuguet   
2014-12-18 18:46   
Code review + testing OK
(0073243)
hudsonbot   
2014-12-30 23:28   
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/6525fe229e06 [^]
Maturity status: Test