0015533: accounting generated in cancellation settlement of a bank statement, with currency distinct to schema currency, is not correct

Description

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

Steps To Reproduce

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)

Proposed Solution

the date of settlement *C* generated should not be system (today) date

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0014717	2.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

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

Issue History
Date Modified	Username	Field	Change
2010-12-28 13:41	maite	New Issue
2010-12-28 13:41	maite	Assigned To	=> dalsasua
2010-12-28 13:41	maite	Modules	=> Core
2010-12-28 13:41	maite	OBNetwork customer	=> Yes
2010-12-28 13:42	maite	Relationship added	related to 0014717
2011-01-27 13:17	adrianromero	Issue cloned	0015793
2011-01-27 13:17	adrianromero	Relationship added	blocks 0015793
2011-01-27 13:18	adrianromero	Status	new => scheduled
2011-01-27 13:18	adrianromero	version	2.50MP24 => pi
2011-01-31 11:22	dalsasua	Note Added: 0033961
2011-01-31 11:22	dalsasua	Status	scheduled => closed
2011-01-31 11:22	dalsasua	Resolution	open => no change required
2011-02-01 00:00	anonymous	sf_bug_id	0 => 3169048