Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029884Openbravo ERP09. Financial managementpublic2015-03-12 13:112015-05-18 17:31
Reporteraferraz 
Assigned Toaferraz 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version 
Target Version3.0PR15Q2.1Fixed in Version3.0PR15Q2.1 
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
Summary0029884: 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.0PR15Q2.1
2015-05-15 13:20dmitry_mezentsevTag Attached: Approved
2015-05-18 17:31hgbotCheckin
2015-05-18 17:31hgbotNote Added: 0077539
2015-05-18 17:31hgbotStatusscheduled => resolved
2015-05-18 17:31hgbotResolutionopen => fixed
2015-05-18 17:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q2.1/rev/cca5b0c34a3258be34c99d4f7c9362b8504d5faf [^]
2015-05-18 17:31hgbotCheckin
2015-05-18 17:31hgbotNote Added: 0077540
2015-05-18 17:31umartirenaReview Assigned To => umartirena
2015-05-18 17:31umartirenaNote Added: 0077541
2015-05-18 17:31umartirenaStatusresolved => closed
2015-05-18 17:31umartirenaFixed in Version => 3.0PR15Q2.1

Notes
(0077539)
hgbot   
2015-05-18 17:31   
Repository: erp/backports/3.0PR15Q2.1
Changeset: cca5b0c34a3258be34c99d4f7c9362b8504d5faf
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Thu May 14 14:20:33 2015 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR15Q2.1/rev/cca5b0c34a3258be34c99d4f7c9362b8504d5faf [^]

Fixes issue 29884: 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
---
(0077540)
hgbot   
2015-05-18 17:31   
Repository: erp/backports/3.0PR15Q2.1
Changeset: c279b54114560e9fe08fe3aadbc2cd4488619a7d
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Mon May 18 17:30:26 2015 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR15Q2.1/rev/c279b54114560e9fe08fe3aadbc2cd4488619a7d [^]

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