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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0021808
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2012-10-01 12:332012-10-10 16:36
ReportermalsasuaView Statuspublic 
Assigned Todmiguelez 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisione376b0a5e6e5
ProjectionnoneETAnoneTarget Version3.0MP16
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Review Assigned To
Web browserGoogle Chrome
ModulesCore
Regression levelProduction - QA Approved
Regression date
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/7374dac17caf [^]
Triggers an Emergency Packyes
Summary

0021808: with reconciliations with same date, error in financial account

Descriptionif you have got two reconciliations with same date, error is returned when you access to financial account window
Steps To Reproduce. in F&B
. go to financial account: Bank -Account 1
. create new Imported bnak statement:
  . import date & transaction date = 01/10/2012
  . new line: transaction date= 01/10/2012
              business partner: happy drinks
              amount out: 100
  . new line: transaction date= 01/10/2012
              business partner: healthy food supermarkets
              amount out: 200
 . process


 . go to transaction tab:
  . new transaction:
   . transaction date= 01/10/2012
              business partner: happy drinks
              amount out: 100
 . match statement:
  . match the previous transaction
  . reconcile


 . go to transaction tab:
  . new transaction:
   . transaction date= 01/10/2012
              business partner: healthy food supermarkets
              amount out: 200
 . match statement:
  . match the previous transaction
  . reconcile

go to financial account window
error is returned
   
Proposed Solution. in table FIN_Financial_Account
 . column: lastreconbalance
  . the sqllogic field should be:

(select rec.endingbalance
from fin_financial_account fa , fin_reconciliation rec
where fa.fin_financial_account_id=rec.fin_financial_account_id
and fa.fin_financial_account_id=fin_financial_account_id
and exists (select 1
            from fin_financial_account ff , fin_reconciliation fr
            where ff.fin_financial_account_id=fr.fin_financial_account_id
            and fr.processed='Y'
                  and ff.fin_financial_account_id=fin_financial_account_id
                  having rec.created = max(fr.created)))
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0052982)
dmiguelez (developer)
2012-10-02 13:04

 Test Plan:

 in F&B
. go to financial account: Bank -Account 1
. create new Imported bnak statement:
  . import date & transaction date = 01/10/2012
  . new line: transaction date= 01/10/2012
              business partner: happy drinks
              amount out: 100
  . new line: transaction date= 01/10/2012
              business partner: healthy food supermarkets
              amount out: 200
 . process


 . go to transaction tab:
  . new transaction:
   . transaction date= 01/10/2012
              business partner: happy drinks
              amount out: 100
 . match statement:
  . match the previous transaction
  . reconcile


 . go to transaction tab:
  . new transaction:
   . transaction date= 01/10/2012
              business partner: healthy food supermarkets
              amount out: 200
 . match statement:
  . match the previous transaction
  . reconcile

go to financial account window. No errors are shown.
(0052992)
hgbot (developer)
2012-10-02 16:27

 Repository: erp/devel/pi
Changeset: 6e548a022f3df72ff73fa6c5b675ed941be282bd
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Oct 02 12:28:51 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6e548a022f3df72ff73fa6c5b675ed941be282bd [^]

Fixes issue 21808: Selects the last reconciliation making sure it
returns only one record.

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0052997)
malsasua (developer)
2012-10-02 17:30

 version: 3.0.18066
test plan:
 steps to reproduce: OK
 code review: Ok
(0052998)
hgbot (developer)
2012-10-02 20:55

 Repository: erp/devel/pi
Changeset: c31dbf8b059564bd79b15999ed50a109b122cdd5
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Oct 02 20:54:51 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c31dbf8b059564bd79b15999ed50a109b122cdd5 [^]

Issue 21808: Backout cset 6e548a022f3d before it breaks on oracle

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0052999)
shuehner (administrator)
2012-10-02 21:07

 Re-opened as we need a new fix, as the older fixed does not work with oracle. Still targeting mp16
(0053012)
hgbot (developer)
2012-10-03 12:52

 Repository: erp/devel/pi
Changeset: e376b0a5e6e5740c0ad7780747b5d0f98ce15f7d
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Wed Oct 03 11:40:52 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e376b0a5e6e5740c0ad7780747b5d0f98ce15f7d [^]

Fixes issue 21808: Selects the last reconciliation making sure it
returns only one record.

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0053017)
malsasua (developer)
2012-10-03 14:30

 test plan:
 . steps to reproduce: OK
 . code review: OK
(0053051)
hudsonbot (developer)
2012-10-04 18:18

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c067ea513614 [^]

Maturity status: Test
(0053054)
hudsonbot (developer)
2012-10-04 18:18

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c067ea513614 [^]

Maturity status: Test
(0053055)
hudsonbot (developer)
2012-10-04 18:18

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c067ea513614 [^]

Maturity status: Test
(0053224)
hudsonbot (developer)
2012-10-10 16:36

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b088fe9dfe19 [^]

Maturity status: Test
(0053227)
hudsonbot (developer)
2012-10-10 16:36

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b088fe9dfe19 [^]

Maturity status: Test
(0053228)
hudsonbot (developer)
2012-10-10 16:36

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b088fe9dfe19 [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2012-10-01 12:33 malsasua New Issue
2012-10-01 12:33 malsasua Assigned To => dmiguelez
2012-10-01 12:33 malsasua Web browser => Google Chrome
2012-10-01 12:33 malsasua Modules => Core
2012-10-01 12:58 malsasua Web browser Google Chrome => Google Chrome
2012-10-01 12:58 malsasua Regression level => Production - QA Approved
2012-10-01 12:58 malsasua Regression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/7374dac17caf [^]
2012-10-02 13:04 dmiguelez Note Added: 0052982
2012-10-02 16:27 hgbot Checkin
2012-10-02 16:27 hgbot Note Added: 0052992
2012-10-02 16:27 hgbot Status new => resolved
2012-10-02 16:27 hgbot Resolution open => fixed
2012-10-02 16:27 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6e548a022f3df72ff73fa6c5b675ed941be282bd [^]
2012-10-02 17:30 malsasua Note Added: 0052997
2012-10-02 17:30 malsasua Status resolved => closed
2012-10-02 20:55 hgbot Checkin
2012-10-02 20:55 hgbot Note Added: 0052998
2012-10-02 21:07 shuehner Note Added: 0052999
2012-10-02 21:07 shuehner Status closed => new
2012-10-02 21:07 shuehner Resolution fixed => open
2012-10-02 21:07 shuehner Web browser Google Chrome => Google Chrome
2012-10-02 21:07 shuehner Target Version => 3.0MP16
2012-10-03 12:52 hgbot Checkin
2012-10-03 12:52 hgbot Note Added: 0053012
2012-10-03 12:52 hgbot Status new => resolved
2012-10-03 12:52 hgbot Resolution open => fixed
2012-10-03 12:52 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/6e548a022f3df72ff73fa6c5b675ed941be282bd [^] => http://code.openbravo.com/erp/devel/pi/rev/e376b0a5e6e5740c0ad7780747b5d0f98ce15f7d [^]
2012-10-03 14:30 malsasua Note Added: 0053017
2012-10-03 14:30 malsasua Status resolved => closed
2012-10-04 18:18 hudsonbot Checkin
2012-10-04 18:18 hudsonbot Note Added: 0053051
2012-10-04 18:18 hudsonbot Checkin
2012-10-04 18:18 hudsonbot Note Added: 0053054
2012-10-04 18:18 hudsonbot Checkin
2012-10-04 18:18 hudsonbot Note Added: 0053055
2012-10-10 16:36 hudsonbot Checkin
2012-10-10 16:36 hudsonbot Note Added: 0053224
2012-10-10 16:36 hudsonbot Checkin
2012-10-10 16:36 hudsonbot Note Added: 0053227
2012-10-10 16:36 hudsonbot Checkin
2012-10-10 16:36 hudsonbot Note Added: 0053228

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker