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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005865
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminoralways2008-11-06 19:052008-12-11 12:04
ReporterrafarodaView Statuspublic 
Assigned Tovmromanos 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision10555
ProjectionnoneETAnoneTarget Version2.50
OSLinux 32 bitDatabasePostgreSQLJava version1.5
OS VersionUbuntu 7.10Database version8.3Ant version1.7
Product VersionpiSCM revision9731 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005865: Cash Flow Statement report: wrong Period combo

DescriptionPeriod combo-box in Cash Flow Statement report is wrong.
Steps To Reproduce1) Create a new accounting report inside 'Financial Management || Accounting || Analysis Tools || User Defined Accounting Report Setup'
2) Go to 'Financial Management || Accounting || Analysis Tools || Cash Flow Statement'
3) Select mandatory fields.

Period can not be selected.
Proposed SolutionReview the select that forms Period combo-box: Inside /ad_reports/ReportCashFlow_data.xsql
 <SqlMethod name="selectCombo" type="preparedStatement" return="multiple">
    <SqlMethodComment></SqlMethodComment>
    <Sql>
      <![CDATA[
      SELECT 'M' AS VALUE, TO_CHAR(VALUE) AS ID, TO_CHAR(NAME) AS NAME
      FROM AD_MONTH
      WHERE AD_CLIENT_ID IN ('1')
      AND AD_ORG_ID IN ('1')
      UNION SELECT 'Q' AS VALUE, TO_CHAR(A.VALUE) AS ID, TO_CHAR(A.NAME) AS NAME
      FROM AD_MONTH, AD_REF_LIST_V A
      WHERE AD_CLIENT_ID IN ('2')
      AND AD_ORG_ID IN ('2')
      AND AD_MONTH.QUARTER = A.VALUE
      AND AD_REFERENCE_ID = '800027'
      AND AD_LANGUAGE = ?
      UNION SELECT 'A' AS VALUE, TO_CHAR(YEAR) AS ID, TO_CHAR(YEAR) AS NAME
      FROM C_YEAR
      ]]>
    </Sql>
    <Parameter name="adOrgClient" type="replace" optional="true" after="WHERE AD_CLIENT_ID IN (" text="'1'"/>
    <Parameter name="adUserClient" type="replace" optional="true" after="AND AD_ORG_ID IN (" text="'1'"/>
    <Parameter name="adOrgClient" type="replace" optional="true" after="WHERE AD_CLIENT_ID IN (" text="'2'"/>
    <Parameter name="adUserClient" type="replace" optional="true" after="AND AD_ORG_ID IN (" text="'2'"/>
    <Parameter name="adLanguage"/>
  </SqlMethod>
Tagsmulti-org
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0010103)
psarobe (manager)
2008-11-09 20:07

Reminder to engineers: Please write the steps and the issues to verify when the bug is fixed so QA team can check if the fixed is correct
(0010628)
vmromanos (manager)
2008-11-25 12:31
edited on: 2008-11-25 15:45

The problem seems to be that, when you configure the report inside "User Defined Accounting Report Setup", the "Reporting Interval" field should be declared as mandatory.

When the user selects something inside the "Reporting Interval" field, the "Period" field of the "Cash Flow Statement" window is properly filled.

So the solution to this bug will be to declare the "Reporting Interval" field as mandatory.

(0010650)
svnbot (reporter)
2008-11-25 15:52

Repository: openbravo
Revision: 10555
Author: vmromanos
Date: 2008-11-25 15:52:04 +0100 (Tue, 25 Nov 2008)

Fixed bug 0005865: Cash Flow Statement report: wrong Period combobox

---
U trunk/src-db/database/sourcedata/AD_COLUMN.xml
---

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

- Issue History
Date Modified Username Field Change
2008-11-06 19:05 rafaroda New Issue
2008-11-06 19:05 rafaroda Assigned To => vmromanos
2008-11-06 19:05 rafaroda sf_bug_id 0 => 2230497
2008-11-06 19:05 rafaroda Regression testing => No
2008-11-06 19:05 rafaroda Tag Attached: multi-org
2008-11-09 20:07 psarobe Status new => scheduled
2008-11-09 20:07 psarobe Note Added: 0010103
2008-11-09 20:07 psarobe fix_in_branch => trunk
2008-11-25 12:31 vmromanos Note Added: 0010628
2008-11-25 15:45 vmromanos Note Edited: 0010628
2008-11-25 15:52 svnbot Checkin
2008-11-25 15:52 svnbot Note Added: 0010650
2008-11-25 15:52 svnbot Status scheduled => resolved
2008-11-25 15:52 svnbot Resolution open => fixed
2008-11-25 15:52 svnbot svn_revision => 10555
2008-12-11 12:04 krishna Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker