Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0005865

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 09. Financial management

minor

always

2008-11-06 19:05

2008-12-11 12:04

Reporter

rafaroda

View Status

public

Assigned To

vmromanos

Priority

high

Resolution

fixed

Fixed in Version

Status

closed

Fix in branch

pi

Fixed in SCM revision

Projection

none

ETA

none

Target Version

2.50

OS

Linux 32 bit

Database

PostgreSQL

Java version

1.5

OS Version

Ubuntu 7.10

Database version

8.3

Ant version

1.7

Product Version

pi

SCM revision

9731

Merge Request Status

Review Assigned To

OBNetwork customer

No

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0005865: Cash Flow Statement report: wrong Period combo

Description

Period combo-box in Cash Flow Statement report is wrong.

Steps To Reproduce

1) 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 Solution

Review 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>

Tags

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0010103) psarobe (viewer) 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 (viewer) 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 (viewer) 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	OBNetwork customer	=> No
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