Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029256Openbravo ERP09. Financial managementpublic2015-03-12 13:112015-05-19 01:33
Reporteraferraz 
Assigned Toaferraz 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned Toumartirena
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029256: It's not possible to complete a Simple G/L Journal in Oracle
DescriptionIt's not possible to complete a Simple G/L Journal record in Oracle
Steps To ReproduceCreate a Simple G/L Journal record:
 Organization: F&B España, S.A
 General Ledger: F&B España, S.A. US/A/Euro
 Currency: EUR

Create a line:
 GL Item: Capital social
 Debit: 100

Create another line:
 GL Item: Capital social
 Credit: 100

Complete it. "Process complete succesfully" message is shown but the record still in draft status.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0029222 closed aferraz G/L Journal Accounting amounts are not setted correctly 
depends on backport 00298843.0PR15Q2.1 closed aferraz It's not possible to complete a Simple G/L Journal in Oracle 
depends on backport 00298853.0PR15Q1.4 closed aferraz It's not possible to complete a Simple G/L Journal in Oracle 
related to defect 0029257 closed aferraz It's not possible to post a Simple G/L Journal setted as multi-general ledger 
related to defect 0029315 closed aferraz Accounts are setted wrongly when posting a Simple G/L Journal setted as multi-general ledger 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-03-12 13:11aferrazNew Issue
2015-03-12 13:11aferrazAssigned To => Sandrahuguet
2015-03-12 13:11aferrazModules => Core
2015-03-12 13:11aferrazTriggers an Emergency Pack => No
2015-03-12 13:15aferrazAssigned ToSandrahuguet => aferraz
2015-03-12 13:23aferrazSummaryIs not possible to complete a Simple G/L Journal setted as multi-general ledger in Oracle => It's not possible to complete a Simple G/L Journal setted as multi-general ledger in Oracle
2015-03-12 13:23aferrazDescription Updatedbug_revision_view_page.php?rev_id=7938#r7938
2015-03-12 13:23aferrazSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=7940#r7940
2015-03-12 13:25aferrazRelationship addedrelated to 0029257
2015-03-12 13:47aferrazRelationship addedrelated to 0029222
2015-03-17 13:00aferrazRelationship addedrelated to 0029315
2015-05-14 14:11aferrazSummaryIt's not possible to complete a Simple G/L Journal setted as multi-general ledger in Oracle => It's not possible to complete a Simple G/L Journal in Oracle
2015-05-14 14:11aferrazDescription Updatedbug_revision_view_page.php?rev_id=8548#r8548
2015-05-14 14:11aferrazSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=8549#r8549
2015-05-14 14:18aferrazStatusnew => scheduled
2015-05-18 16:51hgbotCheckin
2015-05-18 16:51hgbotNote Added: 0077533
2015-05-18 16:51hgbotStatusscheduled => resolved
2015-05-18 16:51hgbotResolutionopen => fixed
2015-05-18 16:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ebcfc346fd6c24c713e9d3b0646d5a681b9edc14 [^]
2015-05-18 16:51hgbotCheckin
2015-05-18 16:51hgbotNote Added: 0077534
2015-05-18 17:32umartirenaReview Assigned To => umartirena
2015-05-18 17:32umartirenaNote Added: 0077542
2015-05-18 17:32umartirenaStatusresolved => closed
2015-05-18 17:32umartirenaFixed in Version => pi
2015-05-19 01:33hudsonbotCheckin
2015-05-19 01:33hudsonbotNote Added: 0077548
2015-05-19 01:33hudsonbotCheckin
2015-05-19 01:33hudsonbotNote Added: 0077549

Notes
(0077533)
hgbot   
2015-05-18 16:51   
Repository: erp/devel/pi
Changeset: ebcfc346fd6c24c713e9d3b0646d5a681b9edc14
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Thu May 14 14:20:33 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ebcfc346fd6c24c713e9d3b0646d5a681b9edc14 [^]

Fixes issue 29256: Error while completing a Simple G/L Journal in Oracle

A query in gl_journal_post has been changed to avoid errors in Oracle when retrieving a null id

---
M src-db/database/model/functions/GL_JOURNAL_POST.xml
---
(0077534)
hgbot   
2015-05-18 16:51   
Repository: erp/devel/pi
Changeset: c78dcaae723969a296a44ed296add24885cc822b
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Mon May 18 16:50:47 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c78dcaae723969a296a44ed296add24885cc822b [^]

Related to bug 29256: Code Review

Add coalesce in case there is no batch associated to set GL Journal Org, in order to avoid issues in the if condition done right after the query if null values are compared

---
M src-db/database/model/functions/GL_JOURNAL_POST.xml
---
(0077542)
umartirena   
2015-05-18 17:32   
Code Review + Testing OK
(0077548)
hudsonbot   
2015-05-19 01:33   
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/bdd788358e65 [^]
Maturity status: Test
(0077549)
hudsonbot   
2015-05-19 01:33   
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/bdd788358e65 [^]
Maturity status: Test