Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005865Openbravo ERP09. Financial managementpublic2008-11-06 19:052008-12-11 12:04
Reporterrafaroda 
Assigned Tovmromanos 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target Version2.50Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005865: 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>
Additional Information
Tagsmulti-org
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-11-06 19:05rafarodaNew Issue
2008-11-06 19:05rafarodaAssigned To => vmromanos
2008-11-06 19:05rafarodasf_bug_id0 => 2230497
2008-11-06 19:05rafarodaRegression testing => No
2008-11-06 19:05rafarodaTag Attached: multi-org
2008-11-09 20:07psarobeStatusnew => scheduled
2008-11-09 20:07psarobeNote Added: 0010103
2008-11-09 20:07psarobefix_in_branch => trunk
2008-11-25 12:31vmromanosNote Added: 0010628
2008-11-25 15:45vmromanosNote Edited: 0010628
2008-11-25 15:52svnbotCheckin
2008-11-25 15:52svnbotNote Added: 0010650
2008-11-25 15:52svnbotStatusscheduled => resolved
2008-11-25 15:52svnbotResolutionopen => fixed
2008-11-25 15:52svnbotsvn_revision => 10555
2008-12-11 12:04krishnaStatusresolved => closed

Notes
(0010103)
psarobe   
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   
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   
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 [^]