Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014717Openbravo ERP09. Financial managementpublic2010-09-28 12:592010-10-30 11:24
Reporternetworkb 
Assigned Tovmromanos 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target Version2.50MP23Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0014717: the accounting generated in a bank statement, with currency distinct to schema currency, is not correct
Descriptionif you create a debt payment from bank statement line, with currency distinct to schema currency, when you post the settlement generated with bank statement, the accounting is wrong
Steps To Reproduce. 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

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

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
  
. process and post bank statement.

. go to settlement generated to process the bankstatement (*BSP*XXXX)
Financial Management || Receivables & Payables || Transactions || Settlement || Settlement
. post the setlement:
 entry generated is:
76800 Diferencias positivas de cambio 16.67
40000 Proveedores (euros) 50.00
55500 Partidas pendientes de aplicación 33.33
Proposed Solutionthe date of settlement generated to create the debt payment, should be the same date that debt payment date
Additional Information
TagsNo tags attached.
Relationships
related to defect 00155332.50MP26 closed dalsasua accounting generated in cancellation settlement of a bank statement, with currency distinct to schema currency, is not correct 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-09-28 12:59networkbNew Issue
2010-09-28 12:59networkbAssigned To => dalsasua
2010-10-19 17:12vmromanosStatusnew => scheduled
2010-10-19 17:12vmromanosAssigned Todalsasua => vmromanos
2010-10-19 17:12vmromanosfix_in_branch => pi
2010-10-19 17:16hgbotCheckin
2010-10-19 17:16hgbotNote Added: 0031987
2010-10-19 17:16hgbotStatusscheduled => resolved
2010-10-19 17:16hgbotResolutionopen => fixed
2010-10-19 17:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6aa65b673861697bfa8feac999846ea1ff159a94 [^]
2010-10-20 23:44hudsonbotCheckin
2010-10-20 23:44hudsonbotNote Added: 0032030
2010-10-21 08:11sureshbabuNote Added: 0032041
2010-10-21 08:11sureshbabuStatusresolved => closed
2010-10-30 11:24anonymoussf_bug_id0 => 3098737
2010-12-28 13:42maiteRelationship addedrelated to 0015533

Notes
(0031987)
hgbot   
2010-10-19 17:16   
Repository: erp/devel/pi
Changeset: 6aa65b673861697bfa8feac999846ea1ff159a94
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Oct 19 17:18:06 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6aa65b673861697bfa8feac999846ea1ff159a94 [^]

Fixed bug 14717: the accounting generated in a bank statement, with currency
distinct to schema currency, is not correct

The generated payment is created with the same date as the bank line accounting date

---
M src-db/database/model/functions/C_DEBT_PAYMENT_CREATE.xml
---
(0032030)
hudsonbot   
2010-10-20 23:44   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/6aa65b673861 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/580d14a11e98 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18576.obx [^]
(0032041)
sureshbabu   
2010-10-21 08:11   
Right now the date of settlement generated to create the debt payment, is same date to that debt payment date