Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015793
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2011-01-27 13:172011-03-01 12:36
ReporteradrianromeroView Statuspublic 
Assigned Todalsasua 
PriorityurgentResolutionfixedFixed in Version2.50MP27
StatusclosedFix in branch2.50Fixed in SCM revision581935359120
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP24SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015793: accounting generated in cancellation settlement of 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) 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 Reproduce1. 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 22/12/2222
   multiply rate 2
   divide rate 0.5
 new record:
   from currency USD
   to currency EUR
   valid from 01/09/2010
   valid to 22/12/2222
   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 Solutionthe date of settlement *C* generated should not be system (today) date
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on defect 00155332.50MP26 closeddalsasua accounting generated in cancellation settlement of a bank statement, with currency distinct to schema currency, is not correct 

-  Notes
(0033964)
dalsasua (reporter)
2011-01-31 12:46

 In order to fix this issue, processing of the invoice will be changed: when creating the new settlement, it will use invoice dates, and not system date. Please notice that this will not avoid the appearance of the currency balancing account for all cases. In the reported scenario, for example, we have:
1- One payment created on 30/08/2010 (conversion rate 1:3)
2- One invoice created on January 2011 (conversion rate 1:2)
The total flow of the transaction related is:
On 30/08/2010-> Settlement that creates the payment
43000..Clientes.............33,33..............
43000..Clientes............-33,33..............
On January 2011-> Invoice
70000..Ventas...........................50,00..
43000..Clientes.............50,00..............
On January 2011-> Settlement that cancels the payment
43000..Clientes.........................50,00.. <- To cancel the amount posted by the invoice
43000..Clientes........................-33,33.. <- To cancel the amount posted by the creation settlement
66800..Diferencias cambio...16,67.............. <- Difference between conversion rate when payment creation was posted, and rate when payment cancellation is posted.
(0033984)
hgbot (developer)
2011-02-01 12:13

 Repository: erp/stable/2.50
Changeset: 581935359120ec90b9d12afec0e698d6badd5f56
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Mon Jan 31 13:03:53 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/581935359120ec90b9d12afec0e698d6badd5f56 [^]

Fixes issue 15793. Settlement uses invoice dates when created

---
M src-db/database/model/functions/C_INVOICE_POST.xml
---
(0034468)
maite (developer)
2011-03-01 12:36

 verified

- Issue History
Date Modified Username Field Change
2011-01-27 13:17 adrianromero New Issue
2011-01-27 13:17 adrianromero Assigned To => dalsasua
2011-01-27 13:17 adrianromero Modules => Core
2011-01-27 13:17 adrianromero Issue generated from 0015533
2011-01-27 13:17 adrianromero Relationship added depends on 0015533
2011-01-27 13:18 adrianromero Status new => scheduled
2011-01-31 11:20 dalsasua fix_in_branch => 2.50
2011-01-31 12:32 dalsasua Steps to Reproduce Updated View Revisions
2011-01-31 12:46 dalsasua Note Added: 0033964
2011-02-01 12:13 hgbot Checkin
2011-02-01 12:13 hgbot Note Added: 0033984
2011-02-01 12:13 hgbot Status scheduled => resolved
2011-02-01 12:13 hgbot Resolution open => fixed
2011-02-01 12:13 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/581935359120ec90b9d12afec0e698d6badd5f56 [^]
2011-03-01 12:36 maite Note Added: 0034468
2011-03-01 12:36 maite Status resolved => closed
2011-03-01 12:36 maite Fixed in Version => 2.50MP27

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker