Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010195Openbravo ERP09. Financial managementpublic2009-08-05 13:462009-08-07 00:00
Reporternetworkb 
Assigned Todalsasua 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOS30OS Version
Product Version2.40MP7 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010195: 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. 
depends on backport 0010200 closed dalsasua The settlement are not posted correctly posted 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-08-05 13:46networkbNew Issue
2009-08-05 13:46networkbAssigned To => rafaroda
2009-08-05 13:46networkbOBNetwork customer => Yes
2009-08-05 13:46networkbRelationship addedrelated to 0009544
2009-08-05 13:46networkbProposed Solution updated
2009-08-05 13:46networkbSteps to Reproduce Updated
2009-08-05 15:07networkbNote Added: 0018840
2009-08-05 15:28rafarodaNote Added: 0018842
2009-08-05 15:28rafarodaAssigned Torafaroda => dalsasua
2009-08-05 15:28rafarodaPriorityimmediate => urgent
2009-08-05 15:50williams-tegikIssue Monitored: williams-tegik
2009-08-05 17:20networkbPriorityurgent => immediate
2009-08-06 00:13williams-tegikNote Added: 0018846
2009-08-06 08:07rafarodaRelationship deletedrelated to 0009544
2009-08-06 08:07rafarodaRelationship addedrelated to 0009532
2009-08-06 09:42dalsasuaStatusnew => scheduled
2009-08-06 09:42dalsasuaNote Added: 0018848
2009-08-06 09:42dalsasuafix_in_branch => pi
2009-08-06 09:43dalsasuaStatusscheduled => closed
2009-08-06 09:43dalsasuaResolutionopen => unable to reproduce
2009-08-06 16:49williams-tegikNote Added: 0018866
2009-08-07 00:00anonymoussf_bug_id0 => 2833395

Notes
(0018840)
networkb   
2009-08-05 15:07   
The problem is regarding the decimals, because are not correctly managed so the difference so the total is not balanced
(0018842)
rafaroda   
2009-08-05 15:28   
David,

Can you please take action on this issue?

Thanks.
(0018846)
williams-tegik   
2009-08-06 00:13   
We have reported this issue since almost two months ago (9532) at the end we have not been able to process a debt in a foreign currency (USD) in a bank of the same currency (USD). Please help us here, we have a lot of pressure from the customer.
They are network customers.
(0018848)
dalsasua   
2009-08-06 09:42   
In PI works fine. Checking now 2.40 branch.
Closing defect, and creating backport.

Anyway, 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.
(0018866)
williams-tegik   
2009-08-06 16:49   
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?
-- It should be the same.


>> Please define what "correctly" means. Does through an error? Is the entry assigned to wrong accounts? Are the amounts of the entry incorrect?
-- Before te fix 9532 , it didnt calculate the currency gain or loss, after we applied the 9532 fix, posted a big portionf of the amount to the balancing account and didnt use the customer´s account.

Im going to add some screenshots of this later.