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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005096
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2008-09-17 23:492009-04-21 11:06
ReportergalderromoView Statuspublic 
Assigned Todalsasua 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision10604
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.5.0_15
OS VersionGentoo 2.6.24Database versionXEAnt version1.7
Product Version2.35MP5SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005096: General Ledger: Accumulated amounts when using more than a range

DescriptionWhen having more than 500 records, the report shows more than a view.
The break between ranges can happend during the same accounting date. On this cases, the new range's amounts are not proparly calculated.
Steps To ReproduceSupposing you have this records on facct_acct:
Date: 11-08-08 fact_acct_id:1000 amount:1000
Date: 11-08-08 fact_acct_id:1001 amount:800
---------------- Range break ----------------
Date: 11:08-08 fact_acct_id:1002 amount:350
Date: 12-08-08 fact_acct_id:1003 amount:100

When the new range is loaded, you previous amount will be 2150 instead of 1800.

Proposed SolutionChange selectPrevious method on ReportGeneralLedger_data.xsql with:
  <SqlMethod name="selectPrevious" type="preparedStatement" return="multiple">
      <SqlMethodComment></SqlMethodComment>
      <Sql><![CDATA[
      SELECT COALESCE(SUM(AMTACCTDR),0) AS TOTALDR, COALESCE(SUM(AMTACCTCR),0) AS TOTALCR,
      COALESCE(SUM(AMTACCTDR-AMTACCTCR),0) AS TOTAL
      FROM FACT_ACCT
      WHERE 1=1
      AND FACT_ACCT.ACCOUNT_ID = ?
      AND (DATEACCT < ? OR (DATEACCT= ? AND FACT_ACCT_ID < ? ))
      AND FACT_ACCT.AD_ORG_ID IN ('1')
      AND 2=2
      ]]></Sql>
      <Parameter name="bpartner" optional="true" after="1=1"><![CDATA[ AND FACT_ACCT.C_BPARTNER_ID = ? ]]></Parameter>
      <Parameter name="project" optional="true" after="1=1"><![CDATA[ AND FACT_ACCT.C_PROJECT_ID = ? ]]></Parameter>
      <Parameter name="acctschema" optional="true" after="1=1"><![CDATA[ and fact_acct.C_ACCTSCHEMA_ID = ? ]]></Parameter>
      <Parameter name="account"/>
      <Parameter name="date"/>
      <Parameter name="date"/>
      <Parameter name="factacct"/>
      <Parameter name="orgs" type="replace" optional="true" after="AND FACT_ACCT.AD_ORG_ID IN (" text="'1'"/>
      <Parameter name="productId" optional="true" type="argument" after="2=2"><![CDATA[ AND FACT_ACCT.M_PRODUCT_ID IN ]]></Parameter>
      <Parameter name="user1" optional="true" after="2=2"><![CDATA[ AND fact_acct.USER1_ID = ? ]]></Parameter>
      <Parameter name="user2" optional="true" after="2=2"><![CDATA[ AND fact_acct.USER2_ID = ? ]]></Parameter>
   </SqlMethod>
TagsGPS-Top20
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0005136 closeddalsasua General Ledger: Accumulated amounts when using more than a range 
depends on backport 0005849 closeddalsasua General Ledger: Accumulated amounts when using more than a range 
related to defect 0004494 closeddalsasua Navigation with the arrows between pages in large HTML reports is not clear 

-  Notes
(0009383)
svnbot (reporter)
2008-10-06 13:09

 Repository: openbravo
Revision: 8266
Author: davidalsasua
Date: 2008-10-06 13:09:49 +0200 (Mon, 06 Oct 2008)

Fixes Bug 0005096: General Ledger: Accumulated amounts when using more than a range

---
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=8266&sc=1 [^]
(0009386)
svnbot (reporter)
2008-10-06 13:19

 Repository: openbravo
Revision: 8268
Author: davidalsasua
Date: 2008-10-06 13:18:56 +0200 (Mon, 06 Oct 2008)

Fixes Bug 0005096: General Ledger: Accumulated amounts when using more than a range

---
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=8268&sc=1 [^]
(0009411)
svnbot (reporter)
2008-10-07 07:49

 Repository: openbravo
Revision: 8304
Author: villind
Date: 2008-10-07 07:49:23 +0200 (Tue, 07 Oct 2008)

Merged change 8266. Fixes Bug 0005096: General Ledger: Accumulated amounts when using more than a range

---
_U branches/bonware/r2.40/
_U branches/bonware/r2.40/eclipse.install.source.launch
_U branches/bonware/r2.40/export.database.launch
U branches/bonware/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
U branches/bonware/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
_U branches/bonware/r2.40/src-core/src/org/openbravo/database/OpenbravoDriverManagerConnectionFactory.java
_U branches/bonware/r2.40/update.database.launch
---

https://dev.openbravo.com/websvn/openbravo/?rev=8304&sc=1 [^]
(0010073)
svnbot (reporter)
2008-11-07 10:56

 Repository: openbravo
Revision: 9776
Author: davidalsasua
Date: 2008-11-07 10:56:24 +0100 (Fri, 07 Nov 2008)

Fixes Bug 0005096: General Ledger: Accumulated amounts when using more than a range

---
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.html
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=9776&sc=1 [^]
(0010686)
svnbot (reporter)
2008-11-26 09:48

 Repository: openbravo
Revision: 10591
Author: davidalsasua
Date: 2008-11-26 09:48:57 +0100 (Wed, 26 Nov 2008)

Fixes Bug 0005096: General Ledger: Accumulated amounts when using more than a range

---
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=10591&sc=1 [^]
(0010709)
svnbot (reporter)
2008-11-26 12:53

 Repository: openbravo
Revision: 10604
Author: davidalsasua
Date: 2008-11-26 12:53:48 +0100 (Wed, 26 Nov 2008)

Fixes Bug 0005096: General Ledger: Accumulated amounts when using more than a range

---
U trunk/config/Format.xml
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.html
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.xml
U trunk/src/org/openbravo/erpCommon/ad_reports/Totals.srpt
U trunk/web/skins/Default/Openbravo_ERP_250.css
---

https://dev.openbravo.com/websvn/openbravo/?rev=10604&sc=1 [^]

- Issue History
Date Modified Username Field Change
2008-09-17 23:49 galderromo New Issue
2008-09-17 23:49 galderromo Assigned To => cromero
2008-09-17 23:49 galderromo sf_bug_id 0 => 2116881
2008-09-22 10:37 cromero Status new => scheduled
2008-09-22 10:37 cromero Assigned To cromero => dalsasua
2008-09-22 10:37 cromero fix_in_branch => trunk
2008-09-22 20:12 galderromo Issue Monitored: galderromo
2008-09-23 12:58 cromero Relationship added related to 0004494
2008-09-30 12:31 pjuvara Tag Attached: GPS-Top20
2008-09-30 12:31 pjuvara Tag Attached: ReleaseCandidate
2008-09-30 12:31 pjuvara Tag Detached: ReleaseCandidate
2008-09-30 12:32 pjuvara Priority normal => high
2008-09-30 12:32 pjuvara fix_in_branch trunk =>
2008-10-06 13:09 svnbot Checkin
2008-10-06 13:09 svnbot Note Added: 0009383
2008-10-06 13:09 svnbot Status scheduled => resolved
2008-10-06 13:09 svnbot Resolution open => fixed
2008-10-06 13:09 svnbot svn_revision => 8266
2008-10-06 13:19 svnbot Checkin
2008-10-06 13:19 svnbot Note Added: 0009386
2008-10-06 13:19 svnbot svn_revision 8266 => 8268
2008-10-07 07:49 svnbot Checkin
2008-10-07 07:49 svnbot Note Added: 0009411
2008-10-07 07:49 svnbot svn_revision 8268 => 8304
2008-11-06 12:15 psarobe Status resolved => new
2008-11-06 12:15 psarobe Resolution fixed => open
2008-11-06 12:15 psarobe Status new => scheduled
2008-11-06 12:15 psarobe fix_in_branch => trunk
2008-11-07 10:54 rafaroda fix_in_branch trunk =>
2008-11-07 10:56 svnbot Checkin
2008-11-07 10:56 svnbot Note Added: 0010073
2008-11-07 10:56 svnbot Status scheduled => resolved
2008-11-07 10:56 svnbot Resolution open => fixed
2008-11-07 10:56 svnbot svn_revision 8304 => 9776
2008-11-26 09:48 svnbot Checkin
2008-11-26 09:48 svnbot Note Added: 0010686
2008-11-26 09:48 svnbot svn_revision 9776 => 10591
2008-11-26 12:53 svnbot Checkin
2008-11-26 12:53 svnbot Note Added: 0010709
2008-11-26 12:53 svnbot svn_revision 10591 => 10604
2009-04-21 11:06 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker