Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021808Openbravo ERP09. Financial managementpublic2012-10-01 12:332012-10-10 16:36
Reportermalsasua 
Assigned Todmiguelez 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target Version3.0MP16Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
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
Summary0021808: 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)))
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-10-01 12:33malsasuaNew Issue
2012-10-01 12:33malsasuaAssigned To => dmiguelez
2012-10-01 12:33malsasuaWeb browser => Google Chrome
2012-10-01 12:33malsasuaModules => Core
2012-10-01 12:58malsasuaWeb browserGoogle Chrome => Google Chrome
2012-10-01 12:58malsasuaRegression level => Production - QA Approved
2012-10-01 12:58malsasuaRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/7374dac17caf [^]
2012-10-02 13:04dmiguelezNote Added: 0052982
2012-10-02 16:27hgbotCheckin
2012-10-02 16:27hgbotNote Added: 0052992
2012-10-02 16:27hgbotStatusnew => resolved
2012-10-02 16:27hgbotResolutionopen => fixed
2012-10-02 16:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6e548a022f3df72ff73fa6c5b675ed941be282bd [^]
2012-10-02 17:30malsasuaNote Added: 0052997
2012-10-02 17:30malsasuaStatusresolved => closed
2012-10-02 20:55hgbotCheckin
2012-10-02 20:55hgbotNote Added: 0052998
2012-10-02 21:07shuehnerNote Added: 0052999
2012-10-02 21:07shuehnerStatusclosed => new
2012-10-02 21:07shuehnerResolutionfixed => open
2012-10-02 21:07shuehnerWeb browserGoogle Chrome => Google Chrome
2012-10-02 21:07shuehnerTarget Version => 3.0MP16
2012-10-03 12:52hgbotCheckin
2012-10-03 12:52hgbotNote Added: 0053012
2012-10-03 12:52hgbotStatusnew => resolved
2012-10-03 12:52hgbotResolutionopen => fixed
2012-10-03 12:52hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/6e548a022f3df72ff73fa6c5b675ed941be282bd [^] => http://code.openbravo.com/erp/devel/pi/rev/e376b0a5e6e5740c0ad7780747b5d0f98ce15f7d [^]
2012-10-03 14:30malsasuaNote Added: 0053017
2012-10-03 14:30malsasuaStatusresolved => closed
2012-10-04 18:18hudsonbotCheckin
2012-10-04 18:18hudsonbotNote Added: 0053051
2012-10-04 18:18hudsonbotCheckin
2012-10-04 18:18hudsonbotNote Added: 0053054
2012-10-04 18:18hudsonbotCheckin
2012-10-04 18:18hudsonbotNote Added: 0053055
2012-10-10 16:36hudsonbotCheckin
2012-10-10 16:36hudsonbotNote Added: 0053224
2012-10-10 16:36hudsonbotCheckin
2012-10-10 16:36hudsonbotNote Added: 0053227
2012-10-10 16:36hudsonbotCheckin
2012-10-10 16:36hudsonbotNote Added: 0053228

Notes
(0052982)
dmiguelez   
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   
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   
2012-10-02 17:30   
version: 3.0.18066
test plan:
 steps to reproduce: OK
 code review: Ok
(0052998)
hgbot   
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   
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   
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   
2012-10-03 14:30   
test plan:
 . steps to reproduce: OK
 . code review: OK
(0053051)
hudsonbot   
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   
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   
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   
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   
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   
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