Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005136 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 09. Financial management | major | always | 2008-09-22 10:37 | 2008-12-12 20:08 | |||
| Reporter | galderromo | View Status | public | |||||
| Assigned To | dalsasua | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.40MP1 | |||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 10637 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | Oracle | Java version | 1.5.0_15 | |||
| OS Version | Gentoo 2.6.24 | Database version | XE | Ant version | 1.7 | |||
| Product Version | 2.35MP5 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0005136: General Ledger: Accumulated amounts when using more than a range | |||||||
| Description | When 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 Reproduce | Supposing 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 Solution | Change 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> | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0009384) dalsasua (reporter) 2008-10-06 13:11 |
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 [^] |
|
(0009385) svnbot (reporter) 2008-10-06 13:17 |
Repository: openbravo Revision: 8267 Author: davidalsasua Date: 2008-10-06 13:17:38 +0200 (Mon, 06 Oct 2008) Fixes Bug 0005136: General Ledger: Accumulated amounts when using more than a range --- U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=8267&sc=1 [^] |
|
(0009412) svnbot (reporter) 2008-10-07 07:51 |
Repository: openbravo Revision: 8305 Author: villind Date: 2008-10-07 07:51:20 +0200 (Tue, 07 Oct 2008) Merged change 8267. Fixes Bug 0005136: 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_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=8305&sc=1 [^] |
|
(0010056) svnbot (reporter) 2008-11-06 18:49 |
Repository: openbravo Revision: 9768 Author: davidalsasua Date: 2008-11-06 18:49:08 +0100 (Thu, 06 Nov 2008) Fixes bug 0005136: General Ledger: Accumulated amounts when using more than a range --- U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.html U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=9768&sc=1 [^] |
|
(0010487) svnbot (reporter) 2008-11-20 23:18 |
Repository: openbravo Revision: 10375 Author: villind Date: 2008-11-20 23:18:11 +0100 (Thu, 20 Nov 2008) Merged r9768. Fixes bug 0005136: General Ledger: Accumulated amounts when using more than a range --- _U branches/bonware/r2.40/ _U branches/bonware/r2.40/config/setup-tool/ _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.html 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.xml _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=10375&sc=1 [^] |
|
(0010576) svnbot (reporter) 2008-11-24 16:59 |
Repository: openbravo Revision: 10478 Author: davidalsasua Date: 2008-11-24 16:59:40 +0100 (Mon, 24 Nov 2008) Fixes Bug 0005136: General Ledger: Accumulated amounts when using more than a range --- U branches/r2.40/config/Format.xml U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.html U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.xml U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/Totals.srpt U branches/r2.40/web/skins/Default/Openbravo_ERP_240.css --- https://dev.openbravo.com/websvn/openbravo/?rev=10478&sc=1 [^] |
|
(0010602) svnbot (reporter) 2008-11-25 10:16 |
Repository: openbravo Revision: 10510 Author: davidalsasua Date: 2008-11-25 10:16:30 +0100 (Tue, 25 Nov 2008) Fixes Bug 0005136: General Ledger: Accumulated amounts when using more than a range --- U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=10510&sc=1 [^] |
|
(0010647) svnbot (reporter) 2008-11-25 15:06 |
Repository: openbravo Revision: 10549 Author: villind Date: 2008-11-25 15:06:19 +0100 (Tue, 25 Nov 2008) Merged r10478. Fixes Bug 0005136: General Ledger: Accumulated amounts when using more than a range --- _U branches/bonware/r2.40/ U branches/bonware/r2.40/config/Format.xml _U branches/bonware/r2.40/config/setup-tool/ _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.html 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.xml U branches/bonware/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql U branches/bonware/r2.40/src/org/openbravo/erpCommon/ad_reports/Totals.srpt _U branches/bonware/r2.40/src-core/src/org/openbravo/database/OpenbravoDriverManagerConnectionFactory.java _U branches/bonware/r2.40/update.database.launch U branches/bonware/r2.40/web/skins/Default/Openbravo_ERP_240.css --- https://dev.openbravo.com/websvn/openbravo/?rev=10549&sc=1 [^] |
|
(0010683) svnbot (reporter) 2008-11-26 08:51 |
Repository: openbravo Revision: 10589 Author: davidalsasua Date: 2008-11-26 08:51:20 +0100 (Wed, 26 Nov 2008) Fixes Bug 0005136: General Ledger: Accumulated amounts when using more than a range --- U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=10589&sc=1 [^] |
|
(0010726) svnbot (reporter) 2008-11-26 17:19 |
Repository: openbravo Revision: 10625 Author: villind Date: 2008-11-26 17:19:36 +0100 (Wed, 26 Nov 2008) Merged r10510. Fixes Bug 0005136: General Ledger: Accumulated amounts when using more than a range --- _U branches/bonware/r2.40/ _U branches/bonware/r2.40/config/setup-tool/ _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_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=10625&sc=1 [^] |
|
(0010741) svnbot (reporter) 2008-11-26 18:30 |
Repository: openbravo Revision: 10637 Author: villind Date: 2008-11-26 18:30:47 +0100 (Wed, 26 Nov 2008) Merged r10589. Fixes Bug 0005136: General Ledger: Accumulated amounts when using more than a range --- _U branches/bonware/r2.40/ _U branches/bonware/r2.40/config/setup-tool/ _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_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=10637&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-09-22 10:37 | cromero | New Issue | |
| 2008-09-22 10:37 | cromero | Assigned To | => dalsasua |
| 2008-09-22 10:37 | cromero | Status | new => scheduled |
| 2008-10-06 13:11 | dalsasua | Status | scheduled => resolved |
| 2008-10-06 13:11 | dalsasua | Fixed in Version | => 2.40 |
| 2008-10-06 13:11 | dalsasua | svn_revision | => 8266 |
| 2008-10-06 13:11 | dalsasua | Resolution | open => fixed |
| 2008-10-06 13:11 | dalsasua | Note Added: 0009384 | |
| 2008-10-06 13:17 | svnbot | Checkin | |
| 2008-10-06 13:17 | svnbot | Note Added: 0009385 | |
| 2008-10-06 13:17 | svnbot | svn_revision | 8266 => 8267 |
| 2008-10-07 07:51 | svnbot | Checkin | |
| 2008-10-07 07:51 | svnbot | Note Added: 0009412 | |
| 2008-10-07 07:51 | svnbot | svn_revision | 8267 => 8305 |
| 2008-11-06 18:49 | svnbot | Checkin | |
| 2008-11-06 18:49 | svnbot | Note Added: 0010056 | |
| 2008-11-06 18:49 | svnbot | svn_revision | 8305 => 9768 |
| 2008-11-20 23:18 | svnbot | Checkin | |
| 2008-11-20 23:18 | svnbot | Note Added: 0010487 | |
| 2008-11-20 23:18 | svnbot | svn_revision | 9768 => 10375 |
| 2008-11-24 16:59 | svnbot | Checkin | |
| 2008-11-24 16:59 | svnbot | Note Added: 0010576 | |
| 2008-11-24 16:59 | svnbot | svn_revision | 10375 => 10478 |
| 2008-11-25 10:16 | svnbot | Checkin | |
| 2008-11-25 10:16 | svnbot | Note Added: 0010602 | |
| 2008-11-25 10:16 | svnbot | svn_revision | 10478 => 10510 |
| 2008-11-25 15:06 | svnbot | Checkin | |
| 2008-11-25 15:06 | svnbot | Note Added: 0010647 | |
| 2008-11-25 15:06 | svnbot | svn_revision | 10510 => 10549 |
| 2008-11-26 08:51 | svnbot | Checkin | |
| 2008-11-26 08:51 | svnbot | Note Added: 0010683 | |
| 2008-11-26 08:51 | svnbot | svn_revision | 10549 => 10589 |
| 2008-11-26 17:19 | svnbot | Checkin | |
| 2008-11-26 17:19 | svnbot | Note Added: 0010726 | |
| 2008-11-26 17:19 | svnbot | svn_revision | 10589 => 10625 |
| 2008-11-26 18:30 | svnbot | Checkin | |
| 2008-11-26 18:30 | svnbot | Note Added: 0010741 | |
| 2008-11-26 18:30 | svnbot | svn_revision | 10625 => 10637 |
| 2008-12-12 20:08 | psarobe | Regression testing | => No |
| 2008-12-12 20:08 | psarobe | Status | resolved => closed |
| 2008-12-12 20:08 | psarobe | Fixed in Version | 2.40 => 2.40MP1 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |