Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0005865 | Openbravo ERP | 09. Financial management | public | 2008-11-06 19:05 | 2008-12-11 12:04 |
| Reporter | rafaroda | ||||
| Assigned To | vmromanos | ||||
| Priority | high | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 20 | OS Version | Ubuntu 7.10 | |
| Product Version | pi | ||||
| Target Version | 2.50 | Fixed in Version | |||
| 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> | ||||
| Additional Information | |||||
| Tags | multi-org | ||||
| Relationships | |||||
| Attached Files | |||||
| 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 | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||