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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015550
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2010-12-30 12:022011-03-18 12:05
ReporterxabiermerinoView Statuspublic 
Assigned Todalsasua 
PriorityurgentResolutionfixedFixed in Version2.50MP27
StatusclosedFix in branchFixed in SCM revision2b30ee10302f
ProjectionnoneETAnoneTarget Version2.50MP26
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

0015550: Bad behaviour when post a bank statement with a G/L Item

DescriptionYou have this accounting configuraion in the G/L Item:

- Glitem debit acct: 60900
- Glitem credit acct: 70900

When post a Bank statement with Ending Balance = -10:
 
        DEBIT CREDIT
57200 10
70900 10

When post a Bank statement with Ending Balance = 10:

        DEBIT CREDIT
57200 10
60900 10

Steps To Reproduce- AS Openbravo Admin go to inancial Management || Accounting || Setup || G/L Item
- Create a new G/L Item and go to ACcounting
    - Glitem debit acct: 60900
    - Glitem credit acct: 70900

- Go to Financial Management || Receivables & Payables || Transactions || Bank Statement
- Create a new record and go to lines:
    -Statement Amount: 10
    - select the G/L Item created
- Process and post.

        DEBIT CREDIT
57200 10
60900 10


- Create a new record and go to lines:
    -Statement Amount: -10
    - select the G/L Item created
- Process and post.
        DEBIT CREDIT
57200 10
70900 10
TagsNo tags attached.
Attached Filesdiff file icon fix15550.diff [^] (708 bytes) 2011-01-28 08:57 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on defect 0015613 closeddalsasua Bad behaviour when post a bank statement with a G/L Item 

-  Notes
(0033942)
dalsasua (reporter)
2011-01-28 08:52
edited on: 2011-01-28 08:53

 The issue has been detected, and will be fixed: it's taking the debit account when posting amounts in credit column, and the other way around.
In order to detect if any bank statement could be wrongly posted, next sql can be executed:
select b.name, b.description, b.statementdate
from c_bankstatement b, c_bankstatementline l, c_glitem g, c_glitem_acct ga,
     c_validcombination vcdebit, c_validcombination vccredit
where b.c_bankstatement_id = l.c_bankstatement_id
  and b.posted = 'Y'
  and l.c_glitem_id is not null
  and g.c_glitem_id = l.c_glitem_id
  and ga.c_glitem_id = g.c_glitem_id
  and ga.glitem_debit_acct = vcdebit.c_validcombination_id
  and ga.glitem_credit_acct = vccredit.c_validcombination_id
  and vcdebit.account_id <> vccredit.account_id
(0033944)
dalsasua (reporter)
2011-01-28 08:59

 Issue fix has been generated, and attached to the issue, just in case it's really urgent. Push to repository will be done as soon as the branch is un-frozen (actually, when MP26 is released)
(0033982)
hgbot (developer)
2011-02-01 12:13

 Repository: erp/stable/2.50
Changeset: 2b30ee10302f9694744e1ea695075192a850720f
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri Jan 28 08:59:07 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/2b30ee10302f9694744e1ea695075192a850720f [^]

Fixes issue 15550: Bad behaviour when post a bank statement
Now it takes correctly debit/credit accounts, depending on the bank statement sign

---
M src/org/openbravo/erpCommon/ad_forms/DocLine_Bank.java
---
(0034222)
jonalegriaesarte (reporter)
2011-02-16 11:52

 Verified
(0034223)
jonalegriaesarte (reporter)
2011-02-16 12:03

 In postgreSQL it does not work fine. Sorry for the inconveniences.
(0034227)
jonalegriaesarte (reporter)
2011-02-16 12:34

 Verfied

- Issue History
Date Modified Username Field Change
2010-12-30 12:02 xabiermerino New Issue
2010-12-30 12:02 xabiermerino Assigned To => dalsasua
2010-12-30 12:02 xabiermerino Modules => Core
2010-12-30 12:02 xabiermerino Issue Monitored: networkb
2011-01-11 13:14 adrianromero Status new => scheduled
2011-01-11 13:14 adrianromero fix_in_branch => pi
2011-01-11 13:14 adrianromero Type defect => backport
2011-01-11 13:14 adrianromero fix_in_branch pi =>
2011-01-11 13:15 adrianromero Issue cloned 0015613
2011-01-11 13:15 adrianromero Relationship added depends on 0015613
2011-01-28 08:52 dalsasua Note Added: 0033942
2011-01-28 08:53 dalsasua Note Edited: 0033942 View Revisions
2011-01-28 08:55 dalsasua fix_in_branch => 2.50
2011-01-28 08:57 dalsasua File Added: fix15550.diff
2011-01-28 08:59 dalsasua Note Added: 0033944
2011-02-01 12:13 hgbot Checkin
2011-02-01 12:13 hgbot Note Added: 0033982
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/2b30ee10302f9694744e1ea695075192a850720f [^]
2011-02-16 11:52 jonalegriaesarte Note Added: 0034222
2011-02-16 11:52 jonalegriaesarte Status resolved => closed
2011-02-16 11:52 jonalegriaesarte Fixed in Version => 2.50MP27
2011-02-16 12:03 jonalegriaesarte Note Added: 0034223
2011-02-16 12:03 jonalegriaesarte Status closed => new
2011-02-16 12:03 jonalegriaesarte Resolution fixed => open
2011-02-16 12:03 jonalegriaesarte Fixed in Version 2.50MP27 =>
2011-02-16 12:33 jonalegriaesarte Status new => scheduled
2011-02-16 12:33 jonalegriaesarte fix_in_branch 2.50 => pi
2011-02-16 12:33 jonalegriaesarte Status scheduled => resolved
2011-02-16 12:33 jonalegriaesarte Resolution open => fixed
2011-02-16 12:34 jonalegriaesarte Note Added: 0034227
2011-02-16 12:34 jonalegriaesarte Status resolved => closed
2011-02-16 12:34 jonalegriaesarte Fixed in Version => 2.50MP27
2011-03-18 12:04 adrianromero fix_in_branch pi =>

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker