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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0010200
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2009-08-05 13:462009-08-06 11:38
ReporternetworkbView Statuspublic 
Assigned Todalsasua 
PriorityimmediateResolutionunable to reproduceFixed in Version
StatusclosedFix in branch2.40Fixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.40MP7SCM revision 
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
Summary

0010200: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0009532 closededuardo_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 closeddalsasua The settlement are not posted correctly posted 

-  Notes
(0018849)
dalsasua (viewer)
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 (viewer)
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 (viewer)
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 (viewer)
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 (viewer)
2009-08-06 10:18

 Ok, taking into account note 0018851.
(0018854)
dalsasua (viewer)
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 (viewer)
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 (viewer)
2009-08-06 11:38

 Same result following all the steps. Please update to the last version of the 2.40 branch.

- Issue History
Date Modified Username Field Change
2009-08-06 09:42 dalsasua Type defect => backport
2009-08-06 09:42 dalsasua fix_in_branch => 2.40
2009-08-06 09:42 dalsasua Relationship added related to 0009532
2009-08-06 09:56 dalsasua Note Added: 0018849
2009-08-06 09:59 networkb Note Added: 0018850
2009-08-06 10:17 networkb Note Added: 0018851
2009-08-06 10:18 dalsasua Note Added: 0018852
2009-08-06 10:18 dalsasua Note Added: 0018853
2009-08-06 10:27 dalsasua Note Added: 0018854
2009-08-06 10:29 dalsasua Status scheduled => feedback
2009-08-06 11:10 networkb Note Added: 0018858
2009-08-06 11:11 networkb Note Edited: 0018858
2009-08-06 11:12 networkb Note Edited: 0018858
2009-08-06 11:20 dalsasua Status feedback => scheduled
2009-08-06 11:20 dalsasua fix_in_branch 2.40 => pi
2009-08-06 11:21 dalsasua fix_in_branch pi => 2.40
2009-08-06 11:38 dalsasua Status scheduled => closed
2009-08-06 11:38 dalsasua Note Added: 0018859
2009-08-06 11:38 dalsasua Resolution open => unable to reproduce

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker