Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010200Openbravo ERP09. Financial managementpublic2009-08-05 13:462009-08-06 11:38
Reporternetworkb 
Assigned Todalsasua 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOS30OS Version
Product Version2.40MP7 
Target VersionFixed 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
Summary0010200: The settlement are not posted correctly posted
DescriptionThe settlement are not posted correctly posted when it have been created
from a bankstatement with a bank with foreing currency and when that bankstamente comes from c_debp_payments generated using a foreign currency.
Steps To Reproduce-Create a sales invoice using a foreing currency with a line
-complete and post it
-Create a bankstatement selecting a bank defined with a foreign currency
-Execute the create lines and select the debt_payment created in the previous ivnoice
-Process the banstament, (a settlment is created)
-Go to the created settlment and post it.
-It is not correctly posted and the log says a message with:
09:37:13 [http-8180-4] WARN org.openbravo.erpCommon.ad_forms.Fact - isSourceBalanced NO - Balance=52394.8700
09:37:13 [http-8180-4] WARN org.openbravo.erpCommon.ad_forms.Fact - isSegmentBalanced (OO) NO - org.openbravo.erpCommon.ad_forms.Fact@84e723, Balance=52394.8700
09:37:13 [http-8180-4] WARN org.openbravo.erpCommon.ad_forms.Fact - isAcctBalanced NO - Balance=1012131.11
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0009532 closed eduardo_Argal A settlement generated from a Bank statement is not posted correctly when the currency of the bank is a foreing currency. 
blocks defect 0010195 closed dalsasua The settlement are not posted correctly posted 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-08-06 09:42dalsasuaTypedefect => backport
2009-08-06 09:42dalsasuafix_in_branch => 2.40
2009-08-06 09:42dalsasuaRelationship addedrelated to 0009532
2009-08-06 09:56dalsasuaNote Added: 0018849
2009-08-06 09:59networkbNote Added: 0018850
2009-08-06 10:17networkbNote Added: 0018851
2009-08-06 10:18dalsasuaNote Added: 0018852
2009-08-06 10:18dalsasuaNote Added: 0018853
2009-08-06 10:27dalsasuaNote Added: 0018854
2009-08-06 10:29dalsasuaStatusscheduled => feedback
2009-08-06 11:10networkbNote Added: 0018858
2009-08-06 11:11networkbNote Edited: 0018858
2009-08-06 11:12networkbNote Edited: 0018858
2009-08-06 11:20dalsasuaStatusfeedback => scheduled
2009-08-06 11:20dalsasuafix_in_branch2.40 => pi
2009-08-06 11:21dalsasuafix_in_branchpi => 2.40
2009-08-06 11:38dalsasuaStatusscheduled => closed
2009-08-06 11:38dalsasuaNote Added: 0018859
2009-08-06 11:38dalsasuaResolutionopen => unable to reproduce

Notes
(0018849)
dalsasua   
2009-08-06 09:56   
Hi

I need to know:
-Create a sales invoice using a foreing currency with a line
-complete and post it
-Create a bankstatement selecting a bank defined with a foreign currency
>> We are talking here about "a foreign currency" for the bank and for the sales invoice. Should this foreign currency be the same or different in both cases?
-Execute the create lines and select the debt_payment created in the previous ivnoice
-Process the banstament, (a settlment is created)
-Go to the created settlment and post it.
-It is not correctly posted and the log says a message with:
>> Please define what "correctly" means. Does through an error? Is the entry assigned to wrong accounts? Are the amounts of the entry incorrect?

Thanks. Regards.
(0018850)
networkb   
2009-08-06 09:59   
Hi,
The foreign currency of the bank selected on the bankstatement is the same that used on the invoice

The settlment is posted but an amount is introduced in an account used when the accounting is not balanced.
The log shows the following warning:

09:37:13 [http-8180-4] WARN org.openbravo.erpCommon.ad_forms.Fact - isSourceBalanced NO - Balance=52394.8700
09:37:13 [http-8180-4] WARN org.openbravo.erpCommon.ad_forms.Fact - isSegmentBalanced (OO) NO - org.openbravo.erpCommon.ad_forms.Fact@84e723, Balance=52394.8700
09:37:13 [http-8180-4] WARN org.openbravo.erpCommon.ad_forms.Fact - isAcctBalanced NO - Balance=1012131.11
(0018851)
networkb   
2009-08-06 10:17   
Sorry, there is some data missing:

The invoice is on a date with a currency conversion
and the bank statement is in another date, with other conversion
the settlement is automcatically generated with processing the bankstatement
so it has the same date of the bankstatement
(0018852)
dalsasua   
2009-08-06 10:18   
Nothing estrange found in the 2.40 branch:

Accounting schema BigBazaar US/A/Euro Date 06-08-2009 Detail
Account No. NAME DEBIT CREDIT
43000 Clientes (euros) 116.00
55500 Partidas pendientes de aplicación 116.00
(0018853)
dalsasua   
2009-08-06 10:18   
Ok, taking into account note 0018851.
(0018854)
dalsasua   
2009-08-06 10:27   
I cannot reproduce. Has been this bug reproduced in a 2.40 standard branch? Need help to reproduce it:

Accounting schema BigBazaar US/A/Euro Date 06-09-2009 Detail
Account No..NAME.................................DEBIT......CREDIT
66800.......Diferencias negativas de cambio......38.67
43000.......Clientes (euros)................................116.00
55500.......Partidas pendientes de aplicación....77.33
(0018858)
networkb   
2009-08-06 11:10   
(edited on: 2009-08-06 11:12)
The conversions used are the following:

USD EUR Y Spot 01-07-2009 31-07-2009 1.50 0.67
EUR USD Y Spot 01-07-2009 31-07-2009 0.67 1.50
USD EUR Y Spot 01-08-2009 31-08-2009 1.80 0.56
EUR USD Y Spot 01-08-2009 31-08-2009 0.56 1.80


The invoice has a product with quantity 1 and price 37.80 and tax 16%

The posted settlment:

90010-Cuenta de compensación de asientos......0.53
76800-Diferencias positivas de cambio .............................13.15
43000-Clientes (euros)................................................. 66.31
55500-Partidas pendientes de aplicación......78.93
(0018859)
dalsasua   
2009-08-06 11:38   
Same result following all the steps. Please update to the last version of the 2.40 branch.