Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0020887Openbravo ERP09. Financial managementpublic2012-06-28 12:052012-07-26 10:33
VictorVillar 
ioritzCia 
urgentmajoralways
closedfixed 
5
 
3.0MP14 
Core
No
0020887: With a multicurrency use the line Journal Entry generated is wrong
With a multicurrency use the line Journal Entry generated is wrong, the account
"Cuenta de compensación de asientos" should not be appear.

The scenario is: Invoice in USD, Payment in USD, deposit into a Financial Account in EUR, Accounting Schema in EUR. Use the Format.xml attached.

The problem is in the postLogic method of the AcctServer.java, when calculates the balance, it finds difference of 1*10E8 cents when the user works with multicurrency. The converted amount of the Invoice should be round in some point of the process in order no to have a lot of decimals digits .
Use the Format.xml attached.
As system role,
Go to Currency window,
  select EUR and assign standard precision:2, cost: 4 and price: 5
  select USD and assign standard precision:2, cost: 4 and price: 5

As group admin role,
Go to Price List: tarifa de ventas
  change it to USD
Go to Financial Account:
   select Cuenta de Banco and allow the Multicurrency in Payment Method "Transferencia". In order to use this payment Method in the following transactions.
Go to Sales invoice
  create a new register for F&B España Organization
     BP : Alimentos y Supermercados
     date: 01/01/2012
     Lines tab:
         Cerveza Ale -> Qty: 4000, taxes: ventas exentas, net unit price: 1
Realize that the Invoice is in USD

Go to Payment In window:
   create a new registger for F&B España Organization
       date: Today
       Received from: Alimentos y Supermercados
       Desposit to Cuenta de banco
       Currency: USD
       Received (Financial Account): 3147.70
       Exchange rate: 0.79
  Add details and select the invoice created before
Process it and deposit to the Financial Account.

Go to financial Account window:
   select the Cuenta de Banco account
  Go to transactions tab:
    select the last transaction created by the process of the payment.
    post it.

We realize in the General Ledger Journal that Cuneta de Compensación de asientos appears without information.

          
No tags attached.
xml Format.xml (3,260) 2012-06-28 12:05
https://issues.openbravo.com/file_download.php?file_id=5335&type=bug
Issue History
2012-06-28 12:05VictorVillarNew Issue
2012-06-28 12:05VictorVillarAssigned To => mirurita
2012-06-28 12:05VictorVillarFile Added: Format.xml
2012-06-28 12:05VictorVillarModules => Core
2012-06-28 12:05VictorVillarResolution time => 1342821600
2012-06-28 12:06VictorVillarIssue Monitored: networkb
2012-06-28 12:12VictorVillarSummaryGeneral Ledger Journal shows a line Journal Entry without information => With a multicurrency use the line Journal Entry generated is wrong
2012-06-28 12:12VictorVillarDescription Updatedbug_revision_view_page.php?rev_id=3584#r3584
2012-06-28 13:40miruritaAssigned Tomirurita => jonalegriaesarte
2012-07-16 13:50jonalegriaesarteAssigned Tojonalegriaesarte => ioritzCia
2012-07-24 09:20hgbotCheckin
2012-07-24 09:20hgbotNote Added: 0050799
2012-07-24 09:20hgbotStatusnew => resolved
2012-07-24 09:20hgbotResolutionopen => fixed
2012-07-24 09:20hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e868859060b84d409739ba518dea3301c9ec45b4 [^]
2012-07-26 02:42hudsonbotCheckin
2012-07-26 02:42hudsonbotNote Added: 0050871
2012-07-26 10:33VictorVillarNote Added: 0050890
2012-07-26 10:33VictorVillarStatusresolved => closed

Notes
(0050799)
hgbot   
2012-07-24 09:20   
Repository: erp/devel/pi
Changeset: e868859060b84d409739ba518dea3301c9ec45b4
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Wed Jul 18 11:04:05 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e868859060b84d409739ba518dea3301c9ec45b4 [^]

Fixes issue 20887: With a multicurrency use the line Journal Entry generated is wrong.

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal_data.xsql
---
(0050871)
hudsonbot   
2012-07-26 02:42   
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/5edf203d5780 [^]

Maturity status: Test
(0050890)
VictorVillar   
2012-07-26 10:33   
Verified