Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0016173 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 09. Financial management | minor | always | 2011-03-08 18:18 | 2011-03-23 00:00 | |||
Reporter | adrianromero | View Status | public | |||||
Assigned To | jonalegriaesarte | |||||||
Priority | high | Resolution | fixed | Fixed in Version | 3.0RC6 | |||
Status | closed | Fix in branch | pi | Fixed in SCM revision | 61f174927bf2 | |||
Projection | none | ETA | none | Target Version | ||||
OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
Product Version | pi | SCM revision | ||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | OBPS | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0016173: the XLS generated in report trial balance is not correct | |||||||
Description | in html, the amounts are distinct that xls format | |||||||
Steps To Reproduce | in smallbazar, to run the report with the filters: from date:01/01/2007 to date: 31/12/2007 org: main account level: subaccount run html: account 40000 : initial balance -701.30 run XLS: account 40000 : initial balance 4201.30 | |||||||
Proposed Solution | . to calculate the initial balance in sql, the label union should be replace by union all | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
||||||||
|
![]() |
|
(0034682) hgbot (developer) 2011-03-09 11:15 |
Repository: erp/devel/pi Changeset: 61f174927bf2357331b93bcc6b1f827a5ac29d71 Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com> Date: Wed Mar 09 11:14:44 2011 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/61f174927bf2357331b93bcc6b1f827a5ac29d71 [^] Fixes issue 0016173: the XLS generated in report trial balance is not correct Added an union all in the sql that shows the results in XLS. --- M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql --- |
(0035159) malsasua (viewer) 2011-03-22 17:00 |
it works fine |
![]() |
|||
Date Modified | Username | Field | Change |
2011-03-08 18:18 | adrianromero | New Issue | |
2011-03-08 18:18 | adrianromero | Assigned To | => jonalegriaesarte |
2011-03-08 18:18 | adrianromero | Modules | => Core |
2011-03-08 18:18 | adrianromero | OBNetwork customer | => Yes |
2011-03-08 18:18 | adrianromero | Issue generated from | 0015850 |
2011-03-08 18:18 | adrianromero | Relationship added | blocks 0015850 |
2011-03-08 18:18 | adrianromero | Status | new => scheduled |
2011-03-08 18:18 | adrianromero | fix_in_branch | => pi |
2011-03-09 11:15 | hgbot | Checkin | |
2011-03-09 11:15 | hgbot | Note Added: 0034682 | |
2011-03-09 11:15 | hgbot | Status | scheduled => resolved |
2011-03-09 11:15 | hgbot | Resolution | open => fixed |
2011-03-09 11:15 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/61f174927bf2357331b93bcc6b1f827a5ac29d71 [^] |
2011-03-22 17:00 | malsasua | Note Added: 0035159 | |
2011-03-22 17:00 | malsasua | Status | resolved => closed |
2011-03-22 17:00 | malsasua | Fixed in Version | => 3.0RC6 |
2011-03-23 00:00 | anonymous | sf_bug_id | 0 => 3235753 |
Copyright © 2000 - 2009 MantisBT Group |