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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010334
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2009-08-19 13:122009-08-27 00:00
ReporternetworkbView Statuspublic 
Assigned Todalsasua 
PriorityimmediateResolutionfixedFixed in Versionmain
StatusclosedFix in branchFixed in SCM revisioncd26cb28278a
ProjectionnoneETAnoneTarget Version2.50MP4
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010334: Date range build in Cash Flow Statement Report not working for mm/dd/yyyy date formats

DescriptionCash Flow Statement Report doesn't work for date formats different from dd/mm/yyyy.
Steps To ReproduceGo To: Financial Management || Accounting || Analysis Tools || User Defined Accounting Report Setup || User Defined Accounting Report Setup
Create one report on a monthly basis.
  Structure proposed for a report with just two nodes:
    Root - Check Active, Shown, Report, Reporting Interval Monthly, Summary
      |-> Node - Check just Active, Shown. Choose expenses account (60000 in SmallBazaar)
Go To: Financial Management || Accounting || Analysis Tools || Generate Cash Flow Statement > Generate Cash Flow Statement and run the process
Go to: Financial Management || Accounting || Analysis Tools || Cash Flow Statement > Cash Flow Statement
Obtain the report for a concrete month.
Realize that no data is obtained.
Change report to annually
Repeat process
Obtain the report.
Check that data is obtained.
Proposed SolutionGo To org.openbravo.erpCommon.ad_reports.ReportCashFlow
Change lines 200-215 in order to obtain the ranges for non-annual reports in a generic way. Currently, the code is like:

    if (strAccountingType.equals("Q")) {
      String strAux = ReportCashFlowData.selectMax(this, strPeriod);
      strPeriodFrom = "01/" + ReportCashFlowData.selectMin(this, strPeriod) + "/" + strYear;
      strPeriodTo = ReportCashFlowData.lastDay(this, "01/" + strAux + "/" + strYear, vars
          .getSqlDateFormat());
      strPeriodTo = DateTimeData.nDaysAfter(this, strPeriodTo, "1");
    } else if (strAccountingType.equals("M")) {
      strPeriodFrom = "01/" + strPeriod + "/" + strYear;
      strPeriodTo = ReportCashFlowData.lastDay(this, strPeriodFrom, vars.getSqlDateFormat());
      strPeriodTo = DateTimeData.nDaysAfter(this, strPeriodTo, "1");
    } else {
      strPeriodFrom = "01/01/" + strPeriod;
      strPeriodTo = DateTimeData.nDaysAfter(this, "31/12/" + strPeriod, "1");
    }
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0019158)
hgbot (developer)
2009-08-21 00:29

Repository: erp/devel/pi
Changeset: cd26cb28278ae937c9c74aabf2984cc021d86fe9
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri Aug 21 00:29:38 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/cd26cb28278ae937c9c74aabf2984cc021d86fe9 [^]

Fixes issue 10334: Date range build in Cash Flow Statement Report not working for mm/dd/yyyy date formats

---
M src/org/openbravo/erpCommon/ad_reports/ReportCashFlow.java
M src/org/openbravo/erpCommon/ad_reports/ReportCashFlow_data.xsql
---
(0019229)
sureshbabu (reporter)
2009-08-26 11:23

Tested working fine

- Issue History
Date Modified Username Field Change
2009-08-19 13:12 networkb New Issue
2009-08-19 13:12 networkb Assigned To => rafaroda
2009-08-19 13:14 rafaroda Assigned To rafaroda => dalsasua
2009-08-19 13:14 rafaroda Status new => scheduled
2009-08-19 14:03 networkb Priority urgent => immediate
2009-08-20 09:25 networkb Target Version pi => 2.50MP4
2009-08-21 00:29 hgbot Checkin
2009-08-21 00:29 hgbot Note Added: 0019158
2009-08-21 00:29 hgbot Status scheduled => resolved
2009-08-21 00:29 hgbot Resolution open => fixed
2009-08-21 00:29 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cd26cb28278ae937c9c74aabf2984cc021d86fe9 [^]
2009-08-26 11:23 sureshbabu Status resolved => closed
2009-08-26 11:23 sureshbabu Note Added: 0019229
2009-08-26 11:23 sureshbabu Fixed in Version => main
2009-08-27 00:00 anonymous sf_bug_id 0 => 2845205


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker