Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029885Openbravo ERP09. Financial managementpublic2015-03-12 13:112015-05-18 17:24
Reporteraferraz 
Assigned Toaferraz 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version 
Target Version3.0PR15Q1.4Fixed in Version3.0PR15Q1.4 
Merge Request Status
Review Assigned Toumartirena
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029885: 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
TagsApproved
Relationships
blocks defect 0029256 closed aferraz It's not possible to complete a Simple G/L Journal in Oracle 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-05-14 14:18aferrazTypedefect => backport
2015-05-14 14:18aferrazTarget Version => 3.0PR15Q1.4
2015-05-15 13:21dmitry_mezentsevTag Attached: Approved
2015-05-18 17:23hgbotCheckin
2015-05-18 17:23hgbotNote Added: 0077536
2015-05-18 17:23hgbotStatusscheduled => resolved
2015-05-18 17:23hgbotResolutionopen => fixed
2015-05-18 17:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q1.4/rev/5932bc301a292db0b9f1aaba7b7f7d3433e562cb [^]
2015-05-18 17:23hgbotCheckin
2015-05-18 17:23hgbotNote Added: 0077537
2015-05-18 17:24umartirenaReview Assigned To => umartirena
2015-05-18 17:24umartirenaNote Added: 0077538
2015-05-18 17:24umartirenaStatusresolved => closed
2015-05-18 17:24umartirenaFixed in Version => 3.0PR15Q1.4

Notes
(0077536)
hgbot   
2015-05-18 17:23   
Repository: erp/backports/3.0PR15Q1.4
Changeset: 5932bc301a292db0b9f1aaba7b7f7d3433e562cb
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Thu May 14 16:20:05 2015 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR15Q1.4/rev/5932bc301a292db0b9f1aaba7b7f7d3433e562cb [^]

Fixes issue 29885: 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
---
(0077537)
hgbot   
2015-05-18 17:23   
Repository: erp/backports/3.0PR15Q1.4
Changeset: b5f3756c34b0f555dfa33c9a3e2dee3af2a960db
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Mon May 18 17:22:42 2015 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR15Q1.4/rev/b5f3756c34b0f555dfa33c9a3e2dee3af2a960db [^]

Related to bug 29885: 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
---
(0077538)
umartirena   
2015-05-18 17:24   
Code Review + Testing OK