Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0029256
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2015-03-12 13:112015-05-19 01:33
ReporteraferrazView Statuspublic 
Assigned Toaferraz 
PrioritynormalResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revisionebcfc346fd6c
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toumartirena
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0029256: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0029222 closedaferraz G/L Journal Accounting amounts are not setted correctly 
depends on backport 00298843.0PR15Q2.1 closedaferraz It's not possible to complete a Simple G/L Journal in Oracle 
depends on backport 00298853.0PR15Q1.4 closedaferraz It's not possible to complete a Simple G/L Journal in Oracle 
related to defect 0029257 closedaferraz It's not possible to post a Simple G/L Journal setted as multi-general ledger 
related to defect 0029315 closedaferraz Accounts are setted wrongly when posting a Simple G/L Journal setted as multi-general ledger 

-  Notes
(0077533)
hgbot (developer)
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 (developer)
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 (reporter)
2015-05-18 17:32

 Code Review + Testing OK
(0077548)
hudsonbot (developer)
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 (developer)
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

- Issue History
Date Modified Username Field Change
2015-03-12 13:11 aferraz New Issue
2015-03-12 13:11 aferraz Assigned To => Sandrahuguet
2015-03-12 13:11 aferraz Modules => Core
2015-03-12 13:11 aferraz Triggers an Emergency Pack => No
2015-03-12 13:15 aferraz Assigned To Sandrahuguet => aferraz
2015-03-12 13:23 aferraz Summary Is 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:23 aferraz Description Updated View Revisions
2015-03-12 13:23 aferraz Steps to Reproduce Updated View Revisions
2015-03-12 13:25 aferraz Relationship added related to 0029257
2015-03-12 13:47 aferraz Relationship added related to 0029222
2015-03-17 13:00 aferraz Relationship added related to 0029315
2015-05-14 14:11 aferraz Summary It'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:11 aferraz Description Updated View Revisions
2015-05-14 14:11 aferraz Steps to Reproduce Updated View Revisions
2015-05-14 14:18 aferraz Status new => scheduled
2015-05-18 16:51 hgbot Checkin
2015-05-18 16:51 hgbot Note Added: 0077533
2015-05-18 16:51 hgbot Status scheduled => resolved
2015-05-18 16:51 hgbot Resolution open => fixed
2015-05-18 16:51 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ebcfc346fd6c24c713e9d3b0646d5a681b9edc14 [^]
2015-05-18 16:51 hgbot Checkin
2015-05-18 16:51 hgbot Note Added: 0077534
2015-05-18 17:32 umartirena Review Assigned To => umartirena
2015-05-18 17:32 umartirena Note Added: 0077542
2015-05-18 17:32 umartirena Status resolved => closed
2015-05-18 17:32 umartirena Fixed in Version => pi
2015-05-19 01:33 hudsonbot Checkin
2015-05-19 01:33 hudsonbot Note Added: 0077548
2015-05-19 01:33 hudsonbot Checkin
2015-05-19 01:33 hudsonbot Note Added: 0077549

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker