Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017276Openbravo ERP09. Financial managementpublic2011-05-19 16:542011-05-30 19:39
Reporterpsanjuan 
Assigned Toeintelau 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.04.1
Product Version 
Target Version3.0MP0Fixed in Version3.0MP0 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017276: Multicurrency - gain/loss recognition in case of a system exchange rate differente that the exchange rate entered by end-user
DescriptionMulticurrency - gain/loss recognition in case of a system exchange rate differente that the exchange rate entered by end-user is not required
Steps To ReproduceOrganization: F&B US Inc
Accounting schema : USD
Vendor : Happy Drinks
Bank : EUR

Purchase Invoice = 2310 USD
Exchange rates = (system):
February 2012 = 0.8 usd/eur (1.25 eur/usd)
March 2012 = 0.714286 usd/eur (1.4 eur/usd)
April 2012 = 0.7 usd/eur (1.428571 eur/usd)

Payment 1 in February 2012 for 770 USD
Payment posting:
770 usd (acccount payable) DEBIT
770 usd (bank in transit) CREDIT - calculation = 770$*0.8$/EUR = 616 EUR and 616 EUR * 1.25 EUR/$ = 770 USD - which implies a
Financial Account transaction = 616 EUR (770 USD)

Payment 2 in March 2012 for 770 USD
Payment posting:
770 usd (acccount payable) DEBIT
770 usd (bank in transit) CREDIT - calculation = 770$*0.714286 $/EUR = 550 EUR and 616 EUR * 1.4 EUR/$ = 770 USD - which implies a
Financial Account transaction = 550 EUR (770 USD)

Pament 3 in April 2012 for 770 USD
In this case the end-user manually changes the exchange rate to 1.4 usd/eur instead of 0.7 usd/eur (which implies an opposite exchange rate = 0.714286 to be used instead of the one that the system has for that period of time and which is = 1.428571)

Payment posting should be:
770 usd (acccount payable) DEBIT
770 usd (bank in transit) CREDIT - calculation = 770 $*1.4 $/EUR = 1078 EUR and 1078 EUR * 0,714286 EUR/$ = 770 USD - which implies a
Financial Account transaction = 1078 EUR (770 USD)
and that's it.

The fact that the system does has a diferent exchange rate that the one entered by the end-user does not mean eithe a gain/loss. that is a systemic error.


What the system does now is:
770 usd (acccount payable) DEBIT
1540 usd (bank in transit) CREDIT - calculation = 770 $*1.4 $/EUR = 1078 EUR and 1078 EUR * 1.428571EUR/$ = 1540 USD
770 usd (currency gain ) DEBIT
Which implies a
Financial Account transaction = 1078 EUR (770 USD) - this part is ok


Proposed SolutionPayment posting should be:
770 usd (acccount payable) DEBIT
770 usd (bank in transit) CREDIT - calculation = 770 $*1.4 $/EUR = 1078 EUR and 1078 EUR * 0,714286 EUR/$ = 770 USD - which implies a
Financial Account transaction = 1078 EUR (770 USD)
and that's it.

The fact that the system does has a diferent exchange rate that the one entered by the end-user does not mean eithe a gain/loss. that is a systemic error.

same behaviour in case of:
accounting Schema (USD)
Bank (USD)
Invoice (EUR)
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 00172183.0MP0 closed eintelau Multicurrency - Wrong exchange rate calculated on the fly 
Attached Filespng 17276_c.png (59,059) 2011-05-24 19:32
https://issues.openbravo.com/file_download.php?file_id=4095&type=bug
png

png 17276_D.png (135,207) 2011-05-24 19:32
https://issues.openbravo.com/file_download.php?file_id=4096&type=bug
png

? Multicurrency QA.ods (26,813) 2011-05-24 19:40
https://issues.openbravo.com/file_download.php?file_id=4097&type=bug
Issue History
Date ModifiedUsernameFieldChange
2011-05-19 16:54psanjuanNew Issue
2011-05-19 16:54psanjuanAssigned To => eintelau
2011-05-19 16:54psanjuanModules => Advanced Payables and Receivables Mngmt
2011-05-19 17:00psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=2061#r2061
2011-05-19 17:10psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=2062#r2062
2011-05-19 17:12psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=2063#r2063
2011-05-19 17:12psanjuanProposed Solution updated
2011-05-19 17:14psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=2064#r2064
2011-05-19 17:15psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=2065#r2065
2011-05-19 18:34eintelauRelationship addedhas duplicate 0017218
2011-05-19 18:36eintelauStatusnew => acknowledged
2011-05-20 07:14hgbotCheckin
2011-05-20 07:14hgbotNote Added: 0037259
2011-05-20 07:14hgbotStatusacknowledged => resolved
2011-05-20 07:14hgbotResolutionopen => fixed
2011-05-20 07:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e0f03813e97d6cbd629c082c80fa1b7d7a25bc2f [^]
2011-05-24 18:16psanjuanNote Added: 0037403
2011-05-24 18:16psanjuanStatusresolved => new
2011-05-24 18:17psanjuanFile Added: 17276_B.png
2011-05-24 18:17psanjuanNote Edited: 0037403bug_revision_view_page.php?bugnote_id=0037403#r2103
2011-05-24 18:32psanjuanNote Edited: 0037403bug_revision_view_page.php?bugnote_id=0037403#r2104
2011-05-24 18:33psanjuanNote Edited: 0037403bug_revision_view_page.php?bugnote_id=0037403#r2105
2011-05-24 19:28psanjuanFile Deleted: 17276_B.png
2011-05-24 19:29psanjuanNote Edited: 0037403bug_revision_view_page.php?bugnote_id=0037403#r2106
2011-05-24 19:32psanjuanFile Added: 17276_c.png
2011-05-24 19:32psanjuanFile Added: 17276_D.png
2011-05-24 19:40psanjuanNote Edited: 0037403bug_revision_view_page.php?bugnote_id=0037403#r2107
2011-05-24 19:40psanjuanFile Added: Multicurrency QA.ods
2011-05-25 15:31psanjuanProposed Solution updated
2011-05-26 07:45hudsonbotCheckin
2011-05-26 07:45hudsonbotNote Added: 0037523
2011-05-30 19:37dmitry_mezentsevStatusnew => acknowledged
2011-05-30 19:38dmitry_mezentsevStatusacknowledged => scheduled
2011-05-30 19:39dmitry_mezentsevStatusscheduled => resolved
2011-05-30 19:39dmitry_mezentsevFixed in Version => 3.0MP0
2011-05-30 19:39dmitry_mezentsevNote Added: 0037757
2011-05-30 19:39dmitry_mezentsevStatusresolved => closed

Notes
(0037259)
hgbot   
2011-05-20 07:14   
Repository: erp/devel/pi
Changeset: e0f03813e97d6cbd629c082c80fa1b7d7a25bc2f
Author: Ben Sommerville <ben.sommerville <at> eintel.com.au>
Date: Fri May 20 02:36:03 2011 +1000
URL: http://code.openbravo.com/erp/devel/pi/rev/e0f03813e97d6cbd629c082c80fa1b7d7a25bc2f [^]

[aprm multi] fixes issue 17276, 17218 - When schema currency matches payment currency use exchange rate defined in payment to create g/l entries

---
M src/org/openbravo/erpCommon/ad_forms/DocFINPayment.java
---
(0037403)
psanjuan   
2011-05-24 18:16   
(edited on: 2011-05-24 19:40)
Financial account posting still shows 1540 USD. please see screens attached.
See also test cases 7 and 8 attached
(0037523)
hudsonbot   
2011-05-26 07:45   
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/728387046be6 [^]

Maturity status: Test
(0037757)
dmitry_mezentsev   
2011-05-30 19:39   
Based on the Patricia feedback.