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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0017276
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2011-05-19 16:542011-05-30 19:39
ReporterpsanjuanView Statuspublic 
Assigned Toeintelau 
PriorityurgentResolutionfixedFixed in Version3.0MP0
StatusclosedFix in branchFixed in SCM revisione0f03813e97d
ProjectionnoneETAnoneTarget Version3.0MP0
OSLinux 32 bitDatabaseOracleJava version1.6
OS VersionUbuntu 8.04.1Database version11.1.0.6.0Ant version1.7.0
Product VersionSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
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
Summary

0017276: 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)
TagsNo tags attached.
Attached Filespng file icon 17276_c.png [^] (59,059 bytes) 2011-05-24 19:32


png file icon 17276_D.png [^] (135,207 bytes) 2011-05-24 19:32


? file icon Multicurrency QA.ods [^] (26,813 bytes) 2011-05-24 19:40

- Relationships [ Relation Graph ] [ Dependency Graph ]
has duplicate defect 00172183.0MP0 closedeintelau Multicurrency - Wrong exchange rate calculated on the fly 

-  Notes
(0037259)
hgbot (developer)
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 (viewer)
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 (viewer)
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 (viewer)
2011-05-30 19:39

 Based on the Patricia feedback.

- Issue History
Date Modified Username Field Change
2011-05-19 16:54 psanjuan New Issue
2011-05-19 16:54 psanjuan Assigned To => eintelau
2011-05-19 16:54 psanjuan Modules => Advanced Payables and Receivables Mngmt
2011-05-19 16:54 psanjuan OBNetwork customer => No
2011-05-19 17:00 psanjuan Steps to Reproduce Updated View Revisions
2011-05-19 17:10 psanjuan Steps to Reproduce Updated View Revisions
2011-05-19 17:12 psanjuan Steps to Reproduce Updated View Revisions
2011-05-19 17:12 psanjuan Proposed Solution updated
2011-05-19 17:14 psanjuan Steps to Reproduce Updated View Revisions
2011-05-19 17:15 psanjuan Steps to Reproduce Updated View Revisions
2011-05-19 18:34 eintelau Relationship added has duplicate 0017218
2011-05-19 18:36 eintelau Status new => acknowledged
2011-05-20 07:14 hgbot Checkin
2011-05-20 07:14 hgbot Note Added: 0037259
2011-05-20 07:14 hgbot Status acknowledged => resolved
2011-05-20 07:14 hgbot Resolution open => fixed
2011-05-20 07:14 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e0f03813e97d6cbd629c082c80fa1b7d7a25bc2f [^]
2011-05-24 18:16 psanjuan Note Added: 0037403
2011-05-24 18:16 psanjuan Status resolved => new
2011-05-24 18:17 psanjuan File Added: 17276_B.png
2011-05-24 18:17 psanjuan Note Edited: 0037403 View Revisions
2011-05-24 18:32 psanjuan Note Edited: 0037403 View Revisions
2011-05-24 18:33 psanjuan Note Edited: 0037403 View Revisions
2011-05-24 19:28 psanjuan File Deleted: 17276_B.png
2011-05-24 19:29 psanjuan Note Edited: 0037403 View Revisions
2011-05-24 19:32 psanjuan File Added: 17276_c.png
2011-05-24 19:32 psanjuan File Added: 17276_D.png
2011-05-24 19:40 psanjuan Note Edited: 0037403 View Revisions
2011-05-24 19:40 psanjuan File Added: Multicurrency QA.ods
2011-05-25 15:31 psanjuan Proposed Solution updated
2011-05-26 07:45 hudsonbot Checkin
2011-05-26 07:45 hudsonbot Note Added: 0037523
2011-05-30 19:37 dmitry_mezentsev Status new => acknowledged
2011-05-30 19:38 dmitry_mezentsev Status acknowledged => scheduled
2011-05-30 19:39 dmitry_mezentsev Status scheduled => resolved
2011-05-30 19:39 dmitry_mezentsev Fixed in Version => 3.0MP0
2011-05-30 19:39 dmitry_mezentsev Note Added: 0037757
2011-05-30 19:39 dmitry_mezentsev Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker