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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0015533

Openbravo ERP

09. Financial management

public

2010-12-28 13:41

2011-02-01 00:00

Reporter

maite

Assigned To

dalsasua

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

no change required

Platform

OS Version

Product Version

Target Version

2.50MP26

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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

Additional Information

Tags

No tags attached.

Relationships

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