Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025414Openbravo ERP09. Financial managementpublic2013-12-31 14:032014-01-02 17:14
Reporterngarcia 
Assigned Tojecharri 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP31 
Merge Request Status
Review Assigned Tongarcia
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025414: Wrong currency rate is applied when posting a GL Journal line
DescriptionWrong currency rate is applied when posting a GL Journal line. Currently the G/L Journal Header Rate field is used, which is filled with the conversion rate between the Header and batch currencies while it should be filled with the conversion rate between the header currency and the General Ledger currency. Moreover, it is not shown when the currency of the batch and the header are the same although the general ledger has a different currency
Steps To ReproduceAs group admin role:
   Create a G/L Journal batch and header
      Organization: F&B España - Región Norte
      Currency: USD
   Select the F&B España, S.A. US/A/Euro general ledger in the header
   Add two lines to it
   Complete and post it
   Check that the amount is not converted from USD to EUR (general ledger currency)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0025415 closed jecharri G/L Journal lines accounting amounts are not updated when changing the header rate 
causes defect 0029110 closed AtulOpenbravo It is not possible to change currency in header tab in G/L Journal 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-12-31 14:03ngarciaNew Issue
2013-12-31 14:03ngarciaAssigned To => jecharri
2013-12-31 14:03ngarciaModules => Core
2013-12-31 14:03ngarciaTriggers an Emergency Pack => No
2013-12-31 14:12ngarciaRelationship addedrelated to 0025415
2013-12-31 14:12ngarciaIssue Monitored: networkb
2013-12-31 17:06hgbotCheckin
2013-12-31 17:06hgbotNote Added: 0063153
2013-12-31 17:06hgbotStatusnew => resolved
2013-12-31 17:06hgbotResolutionopen => fixed
2013-12-31 17:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fcb87e990fcddc17be8b6b1f94fd54eb20fab819 [^]
2013-12-31 18:18ngarciaReview Assigned To => ngarcia
2013-12-31 18:18ngarciaNote Added: 0063157
2013-12-31 18:18ngarciaStatusresolved => closed
2013-12-31 18:18ngarciaFixed in Version => 3.0MP31
2014-01-02 17:14hudsonbotCheckin
2014-01-02 17:14hudsonbotNote Added: 0063209
2015-03-13 19:49dmitry_mezentsevRelationship addedcauses 0029110

Notes
(0063153)
hgbot   
2013-12-31 17:06   
Repository: erp/devel/pi
Changeset: fcb87e990fcddc17be8b6b1f94fd54eb20fab819
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Dec 31 17:08:12 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/fcb87e990fcddc17be8b6b1f94fd54eb20fab819 [^]

Fixes issue 25414, fixes issue 25415:
Wrong currency rate is applied when posting a GL Journal line
G/L Journal lines accounting amounts are not updated when changing the header rate

---
M src-db/database/model/triggers/GL_JOURNALLINE2_TRG.xml
M src-db/database/model/triggers/GL_JOURNALLINE_TRG.xml
M src-db/database/model/triggers/GL_JOURNAL_CHK_RESTRICT_TRG.xml
M src-db/database/model/triggers/GL_JOURNAL_TRG.xml
M src-db/database/sourcedata/AD_AUXILIARINPUT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0063157)
ngarcia   
2013-12-31 18:18   
verified
(0063209)
hudsonbot   
2014-01-02 17:14   
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/d2a6126e04e6 [^]

Maturity status: Test