Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0015533Openbravo ERP09. Financial managementpublic2010-12-28 13:412011-02-01 00:00
maite 
dalsasua 
urgentmajoralways
closedno change required 
5
pi 
2.50MP26 
Core
No
0015533: accounting generated in cancellation settlement of a bank statement, with currency distinct to schema currency, is not correct
if you create a debt payment from bank statement line (with currency distinct to schema currency) and then create invoice (with currency distinct to schema currency) which match with cancellation settlement associated to bank statement,
when you post the settlement C generated to match both payments the accounting is wrong
1. create conversion rates:
General Setup || Application || Conversion Rates || Conversion Rate
 new record:
   from currency EUR
   to currency USD
   valid from 01/01/2010
   valid to 30/08/2010
   multiply rate 3
   divide rate 0.333333
 new record:
   from currency USD
   to currency EUR
   valid from 01/01/2010
   valid to 30/08/2010
   multiply rate 0.333333
   divide rate 3
 new record:
   from currency EUR
   to currency USD
   valid from 01/09/2010
   valid to 31/12/2010
   multiply rate 2
   divide rate 0.5
 new record:
   from currency USD
   to currency EUR
   valid from 01/09/2010
   valid to 31/12/2010
   multiply rate 0.5
   divide rate 2

2. create bank statement
Financial Management || Receivables & Payables || Transactions || Bank Statement || Header
 Transaction Date 30/08/2010

3. create payment: Financial Management || Receivables & Payables || Transactions || Bank Statement || Header >> Lines
 run create payment process
  business partner: mcGiver
  amount 100
  currency USD
  Form of payment: bank deposit
  receipt=YES
4. process and post bank statement.
5. Master Data Management || Pricing || Price List || Price List : create pricelist in USD and set price for Hat product
6. Sales Management || Transactions || Sales Invoice || Header : create sales invoice for USD pricelist and Mcgiver for date=27-12-2010
Add line for hat for 100euro. Process invoice.

7. Go to Sales Management || Transactions || Sales Invoice || Header >> Payment and realize that SettlementCancelled *C* has been created using system's date. Navigate to it and Post it. Realize that entry generated is:
66800 Diferencias negativas de cambio
43000 Clientes (euros)
43000 Clientes (euros)
the date of settlement *C* generated should not be system (today) date
No tags attached.
related to defect 00147172.50MP23 closed vmromanos the accounting generated in a bank statement, with currency distinct to schema currency, is not correct 
blocks backport 0015793 closed dalsasua accounting generated in cancellation settlement of a bank statement, with currency distinct to schema currency, is not correct 
Issue History
2010-12-28 13:41maiteNew Issue
2010-12-28 13:41maiteAssigned To => dalsasua
2010-12-28 13:41maiteModules => Core
2010-12-28 13:42maiteRelationship addedrelated to 0014717
2011-01-27 13:17adrianromeroIssue cloned0015793
2011-01-27 13:17adrianromeroRelationship addedblocks 0015793
2011-01-27 13:18adrianromeroStatusnew => scheduled
2011-01-27 13:18adrianromeroversion2.50MP24 => pi
2011-01-31 11:22dalsasuaNote Added: 0033961
2011-01-31 11:22dalsasuaStatusscheduled => closed
2011-01-31 11:22dalsasuaResolutionopen => no change required
2011-02-01 00:00anonymoussf_bug_id0 => 3169048

Notes
(0033961)
dalsasua   
2011-01-31 11:22   
In 3.0, there do not exist bank statements.