Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021820Openbravo ERP09. Financial managementpublic2012-10-01 18:212012-12-04 17:10
ReporterVictorVillar 
Assigned ToioritzCia 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP18Fixed in Version 
Merge Request Status
Review Assigned ToVictorVillar
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021820: Wrong calculation of a journal entry under some circumstancies
DescriptionWrong calculation of a journal entry under some circumstancies
Steps To ReproduceAs group admin role,

Go to financial account:
  Create a new financial account:
      Org: España
      Name: Cuenta en dolares para España
  Go to Payment Method:
    Create a new register:
       Payment method: Transferencia
       Allow payment out and payment in and Receive/make payments in multiple Currencies flag = Yes
      Upon receipt Use= In transit payment Account
      Upon payment Use= In transit payment Account
  Go to Accounting Configuration:
      Payment In section:
    In Transit Payment IN Account: whatever
      Payment Out section:
      In Transit Payment OUT Account: whatever
Go to business Partner window,
   Select Bebidas Alegres
      Go to Vendor/Creditor tab
          Purchase Pricelist: Tarifa bebidas alegres
          PO Payment Method: Transferencia
          PO Payment Terms: 30 days
          PO Financial Account: Cuenta en dolares para España
Go to Price list window:
   select Tarifa de bebidas alegres
          currency: USD
Go to purchase order window
   create a new window:
       Org: España
       BP: Bebidas alegres
       Price list: Tarifa bebidas alegres
 go to lines tab:
    create new line:
        product: Cerveza Ale 0.5l
        net unit price: 199
        tax: compras exentas
realise that the Order is in USD
Book it

Go to Purchase invoice:
  Create two registers:
       1.- Org: España
           BP: Business partner
    Create lines from order created before
    Create a new line:
         Product: Vino blanco, net unit price: 18, tax: compras exentas
   Go to exchange rate tab:
      Create a new register:
         currency: USD to Currency: EUR
         rate: 1.2502
         foreign amount: 271.29
   Complete it

2.- Org: España
    BP: Bebidas alegres
   Lines tab:
      Create a new line
           Product: Cerveza Ale 0.5L
           net unit Price: 107.70
           tax: compras exentas
   Exchange rate:
      Create a new register:
            currency: USD to currency: EUR
            rate: 1.2472
            Foreign Amount: 134.32
   complete it.

Go to Payment Out,
   create a new register
       Org: España
       paying to: Bebidas alegres
       paying from: Cuenta de dolares para España
    add details
       select orders and invoices
          select 3 lines:
                1- amount: 18
                2.- amount: 107.70
                3.- amount: 199
Process it.
Reactivate it and do NOT remove the lines.
Go to exchange rate tab:
   create a new line:
      currency: Usd to currency: EUR rate: 1.274869, foreign amount: 413.95
Process it and post it.
realise that in the journal entry line of Diferencia negativas de cambio account is missing a cent. see the attached screenshot




 
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng issue.png (132,524) 2012-10-01 18:21
https://issues.openbravo.com/file_download.php?file_id=5618&type=bug
png

diff 21820.diff (3,357) 2012-10-24 12:56
https://issues.openbravo.com/file_download.php?file_id=5675&type=bug
Issue History
Date ModifiedUsernameFieldChange
2012-10-01 18:21VictorVillarNew Issue
2012-10-01 18:21VictorVillarAssigned To => dmiguelez
2012-10-01 18:21VictorVillarFile Added: issue.png
2012-10-01 18:21VictorVillarModules => Core
2012-10-01 18:21VictorVillarResolution time => 1350943200
2012-10-01 18:21VictorVillarIssue Monitored: networkb
2012-10-01 18:26VictorVillarTarget Version => 3.0MP17
2012-10-01 18:47dmiguelezAssigned Todmiguelez => jonalegriaesarte
2012-10-04 16:08jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2012-10-09 20:22jonalegriaesartePriorityurgent => immediate
2012-10-16 12:28jecharriAssigned Tojecharri => ioritzCia
2012-10-24 12:55ioritzCiaNote Added: 0053617
2012-10-24 12:55ioritzCiaPriorityimmediate => high
2012-10-24 12:55ioritzCiaSeveritymajor => minor
2012-10-24 12:55ioritzCiaStatusnew => scheduled
2012-10-24 12:55ioritzCiaTarget Version3.0MP17 => 3.0MP18
2012-10-24 12:56ioritzCiaFile Added: 21820.diff
2012-11-12 12:52hgbotCheckin
2012-11-12 12:52hgbotNote Added: 0054161
2012-11-12 12:52hgbotStatusscheduled => resolved
2012-11-12 12:52hgbotResolutionopen => fixed
2012-11-12 12:52hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/acd485beec84efe63309662d92120a03ffa96c82 [^]
2012-11-21 06:06hudsonbotCheckin
2012-11-21 06:06hudsonbotNote Added: 0054361
2012-11-27 12:03ioritzCiaStatusresolved => new
2012-11-27 12:03ioritzCiaResolutionfixed => open
2012-11-27 12:03ioritzCiaReview Assigned To => VictorVillar
2012-11-27 12:03ioritzCiaStatusnew => scheduled
2012-11-27 12:03ioritzCiaStatusscheduled => resolved
2012-11-27 12:03ioritzCiaResolutionopen => fixed
2012-12-04 17:10VictorVillarNote Added: 0054711
2012-12-04 17:10VictorVillarStatusresolved => closed

Notes
(0053617)
ioritzCia   
2012-10-24 12:55   
The patch was delivered to the partner. The fix is going throug some tests and it will be included in MP18.
(0054161)
hgbot   
2012-11-12 12:52   
Repository: erp/devel/pi
Changeset: acd485beec84efe63309662d92120a03ffa96c82
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Fri Oct 26 13:01:57 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/acd485beec84efe63309662d92120a03ffa96c82 [^]

Fixes issue 21820: Wrong calculation of a journal entry under some circumstancies

---
M src/org/openbravo/erpCommon/ad_forms/Fact.java
M src/org/openbravo/erpCommon/ad_forms/FactLine.java
---
(0054361)
hudsonbot   
2012-11-21 06:06   
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/c3c5e61b0164 [^]

Maturity status: Test
(0054711)
VictorVillar   
2012-12-04 17:10   
Verified for the case reported