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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0029885
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2015-03-12 13:112015-05-18 17:24
ReporteraferrazView Statuspublic 
Assigned Toaferraz 
PrioritynormalResolutionfixedFixed in Version3.0PR15Q1.4
StatusclosedFix in branchFixed in SCM revision5932bc301a29
ProjectionnoneETAnoneTarget Version3.0PR15Q1.4
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

0029885: 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.
TagsApproved
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0029256 closedaferraz It's not possible to complete a Simple G/L Journal in Oracle 

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

 Code Review + Testing OK

- Issue History
Date Modified Username Field Change
2015-05-14 14:18 aferraz Type defect => backport
2015-05-14 14:18 aferraz Target Version => 3.0PR15Q1.4
2015-05-15 13:21 dmitry_mezentsev Tag Attached: Approved
2015-05-18 17:23 hgbot Checkin
2015-05-18 17:23 hgbot Note Added: 0077536
2015-05-18 17:23 hgbot Status scheduled => resolved
2015-05-18 17:23 hgbot Resolution open => fixed
2015-05-18 17:23 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q1.4/rev/5932bc301a292db0b9f1aaba7b7f7d3433e562cb [^]
2015-05-18 17:23 hgbot Checkin
2015-05-18 17:23 hgbot Note Added: 0077537
2015-05-18 17:24 umartirena Review Assigned To => umartirena
2015-05-18 17:24 umartirena Note Added: 0077538
2015-05-18 17:24 umartirena Status resolved => closed
2015-05-18 17:24 umartirena Fixed in Version => 3.0PR15Q1.4

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker