Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040908Openbravo ERP09. Financial managementpublic2019-05-20 10:072019-05-30 18:24
Reportersanti_lozano 
Assigned Tononofrancisco 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR19Q3 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040908: Unexpected Bank Revaluation Loss and posting error with Multi Currency in a payment out
DescriptionGiven a purchase invoice with a concrete total gross amount (150) in some currency and with a concrete exchange rate (14200), when paying for it (payment out) with other concrete exchange rate (14050) and then posting, the debit line is wrong and it also appears an unexpected bank loss of 0.01 (debit lines are that and 2129999.99, which should all be 2130000), credit accounts postings are correct as expected
Steps To Reproduce* change role to F&B International Group Admin
* in Payment Method window, select Wire Transfer. Make Payments in Multiple Currencies = selected, Upon Payment Use = In Transit Payment Account
* in Financial Account window, select Bank – Account 1. In its Payment Method tab, select Wire Transfer. Make Payments in Multiple Currencies = selected, Upon Payment Use = In Transit Payment Account
* in Price List window, create a new one. Organization = *, Name = Int Euro Price List, Currency = EUR. In its Price List Version tab, create a new one. Name = Int Euro Sales Price List, Price List Schema = Price list schema. In its Product Price subtab, create a new one. Product = Plain Water, Unit Price = 1.00, List Price = 1.00
* in Business Partner window, create a new one. Organization = *, Search Key = IWC, Commercial Name = Int Water Company, Business Partner Category = Supplier. In its Vendor/Creditor subtab set: Purchase Price List = Int Euro Price List, PO Payment Method = Wire Transfer. In its Location Address, create one. Location/Address set with: 1st Line = Via Agua 3, City = Madrid, Country = Spain, Region = Madrid
* in Purchase Invoice, create a new one. Organization = F&B US, Inc., Business Partner = Int Water Company, Payment Method = Wire Transfer. In its Lines tab, create a new one. Product = Plain Water, Operative Quantity = 150, Tax = Exempt. In its Exchange Rates tab, create a new one. Currency = EUR, To Currency = USD, Rate = 14200
* in the created Purchase Invoice, click the Complete button. Then click the Add Payment button. Create a payment for it with Conversion Rate = 14050. Click the Done button. Remember the Document No. of the payment created shown in green now.
* in Payment Out window, search that payment created, click the Post button and ok. Look in its Accounting tab how the lines with Debit amounts are not correct (image attached)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng Image Issue for ticket 9820.png (288,820) 2019-05-20 10:07
https://issues.openbravo.com/file_download.php?file_id=12963&type=bug
Issue History
Date ModifiedUsernameFieldChange
2019-05-20 10:07santi_lozanoNew Issue
2019-05-20 10:07santi_lozanoAssigned To => platform
2019-05-20 10:07santi_lozanoFile Added: Image Issue for ticket 9820.png
2019-05-20 10:07santi_lozanoWeb browser => Google Chrome
2019-05-20 10:07santi_lozanoModules => Core
2019-05-20 10:07santi_lozanoResolution time => 1557439200
2019-05-20 10:07santi_lozanoTriggers an Emergency Pack => No
2019-05-20 10:11santi_lozanoWeb browserGoogle Chrome => Google Chrome
2019-05-20 10:11santi_lozanoTarget Version3.0PR19Q1 =>
2019-05-20 12:50alostaleAssigned Toplatform => Triage Finance
2019-05-20 13:44SandrahuguetWeb browserGoogle Chrome => Google Chrome
2019-05-20 13:44SandrahuguetResolution time1557439200 => 1560117600
2019-05-20 13:44SandrahuguetCategoryA. Platform => 09. Financial management
2019-05-20 13:46SandrahuguetAssigned ToTriage Finance => nonofrancisco
2019-05-22 12:04santi_lozanoWeb browserGoogle Chrome => Google Chrome
2019-05-22 12:04santi_lozanoSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=18807#r18807
2019-05-29 16:26nonofranciscoStatusnew => scheduled
2019-05-29 21:09nonofranciscoNote Added: 0112246
2019-05-30 10:32hgbotCheckin
2019-05-30 10:32hgbotNote Added: 0112260
2019-05-30 10:32hgbotStatusscheduled => resolved
2019-05-30 10:32hgbotResolutionopen => fixed
2019-05-30 10:32hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/51cc50c5f11a38249b367cb7aa618f8a3ee877b7 [^]
2019-05-30 10:33SandrahuguetReview Assigned To => Sandrahuguet
2019-05-30 10:33SandrahuguetNote Added: 0112261
2019-05-30 10:33SandrahuguetStatusresolved => closed
2019-05-30 10:33SandrahuguetFixed in Version => 3.0PR19Q3
2019-05-30 18:24hudsonbotCheckin
2019-05-30 18:24hudsonbotNote Added: 0112285

Notes
(0112246)
nonofrancisco   
2019-05-29 21:09   
As Openbravo/F&B International Group Admin

Open Payment Method window
Select Wire Transfer.
  Make Payments in Multiple Currencies = selected
  Upon Payment Use = In Transit Payment Account
Open Financial Account window
Select Bank – Account 1.
Go to Payment Method tab
Select Wire Transfer
  Make Payments in Multiple Currencies = selected
  Upon Payment Use = In Transit Payment Account
Open Price List window
Create a new one.
  Organization = *
  Name = Int Euro Price List
  Currency = EUR
Go to Price List Version tab
Create a new one
  Name = Int Euro Sales Price List
  Price List Schema = Price list schema
Go to Product Price subtab
Create a new one
  Product = Plain Water
  Unit Price = 1.00
  List Price = 1.00
Go to Business Partner window
  Create a new one. Organization = *
  Search Key = IWC
  Commercial Name = Int Water Company
  Business Partner Category = Supplier
Go to Vendor/Creditor subtab set:
  Purchase Price List = Int Euro Price List
  PO Payment Method = Wire Transfer
Go to Location Address
Create one
  Location/Address : 1st Line = Via Agua 3, City = Madrid, Country = Spain, Region = Madrid
Go to Purchase Invoice window
Create a new one
  Organization = F&B US, Inc.
  Business Partner = Int Water Company
  Payment Method = Wire Transfer
Go to Lines tab
Create a new one
  Product = Plain Water
  Operative Quantity = 150
  Tax = Exempt.
Go to Exchange Rates tab
Create a new one
  Currency = EUR
  To Currency = USD
  Rate = 14200
Click the Complete button.
Click the Add Payment button.
Create a payment for it with Conversion Rate = 14050
Click the Done button
Remember the Document No. of the payment created shown in green now.
Go to Payment Out window
Search that payment created
Click the Post button and ok.
Go to Accounting tab
Verify there are three lines, one credit line with value 2130000.00 and two debit lines with values 2107500.00 and 22500.00
(0112260)
hgbot   
2019-05-30 10:32   
Repository: erp/devel/pi
Changeset: 51cc50c5f11a38249b367cb7aa618f8a3ee877b7
Author: Nono Carballo <nonofce <at> gmail.com>
Date: Thu May 30 10:25:37 2019 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/51cc50c5f11a38249b367cb7aa618f8a3ee877b7 [^]

Fixes issue 40908. Increase presicion to avoid diferences.

The presicion was increased to avoid unnecessary diferences when converting
between currencies.

---
M src/org/openbravo/erpCommon/ad_forms/AcctServer.java
---
(0112261)
Sandrahuguet   
2019-05-30 10:33   
code review + testing ok
(0112285)
hudsonbot   
2019-05-30 18:24   
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/b12569076050 [^]
Maturity status: Test