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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0018669
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2011-10-03 10:092011-11-10 09:43
ReportermalsasuaView Statuspublic 
Assigned ToioritzCia 
PriorityhighResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version3.0MP6
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Review Assigned To
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018669: in report trial balance, the XLS and HTML report does not display the same information

DescriptionThe report trial balance, the XLS format displays distinct information than HTML format
Steps To Reproduce. create a gl journal:
 . organization F&B España, S.A.
 . accounting date: 03-10-2011
 . document date: 03-10-2011

. new header:
 . accounting schema: F&B International Group US/A/Euro
 . opening: selected

. new line:
 . accounting combination: 0-43800--
 . Debit 10
 . business partner: "Hoteles Buenas Noches, S.A."

. new line:
 . accounting combination: 0-43800--
 . Credit 20
 . business partner: void

process and post

Run report trial balance:
 . from date - to date: 03/10/2011
 . accounting schema: F&B International Group US/A/Euro
 . Account Level: subaccount
 . Organization: *
 . Account from: 43800
 . Account to: 43800
 . opening entries: checked

 in HTML format:
Warning:
No data has been found. Please ensure that the selected filter options are correct.

 in XLS format:
Acct. No. Account Name Initial Balance Debit Credit Final Balance Business Partner
43800 Anticipos de clientes -10 0 0 -10
43800 Anticipos de clientes 10 0 0 10 Hoteles Buenas Noches, S.A.
Proposed SolutionIn xsql file, in selectXLS method, in internal unions, the next code [1] should be replaced by this [2], similar to method selectAccountLines

[1] c_bpartner.c_bpartner_id as bpid, m_product.m_product_id as pdid, c_project.c_project_id as pjid, c_bpartner.name as bpname, m_product.name as pdname

[2] CASE ?
                       WHEN 'BPartner' THEN c_bpartner.c_bpartner_id
                       WHEN 'Product' THEN m_product.m_product_id
                       WHEN 'Project' THEN c_project.c_project_id
                       ELSE '' END AS groupbyid,
                     CASE ?
                       WHEN 'BPartner' THEN to_char(c_bpartner.name)
                       WHEN 'Product' THEN to_char(m_product.name)
                       WHEN 'Project' THEN to_char(c_project.name)
                       ELSE '' END AS groupbyname
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to feature request 0019014 newjonalegriaesarte in the report trial balance, in XLS format, all dimensions are displayed. the dimension should be able to select in filter scree 
depends on backport 00186702.50MP36 closedioritzCia in report trial balance, the XLS and HTML report does not display the same information 

-  Notes
(0042714)
malsasua (developer)
2011-11-10 09:43

 this behavour has been documented and a new Feature Request (19014) has been created

- Issue History
Date Modified Username Field Change
2011-10-03 10:09 malsasua New Issue
2011-10-03 10:09 malsasua Assigned To => jonalegriaesarte
2011-10-03 10:09 malsasua Web browser => Google Chrome
2011-10-03 10:09 malsasua Modules => Core
2011-10-03 10:09 malsasua Resolution time => 1320102000
2011-10-03 10:09 malsasua Issue Monitored: networkb
2011-10-03 10:10 malsasua Status new => scheduled
2011-10-03 10:10 malsasua fix_in_branch => pi
2011-10-03 10:47 malsasua Web browser Google Chrome => Google Chrome
2011-10-03 10:47 malsasua fix_in_branch pi =>
2011-10-03 10:47 malsasua Proposed Solution updated
2011-10-17 19:27 jonalegriaesarte Assigned To jonalegriaesarte => ioritzCia
2011-10-27 13:32 jonalegriaesarte Web browser Google Chrome => Google Chrome
2011-10-27 13:32 jonalegriaesarte Steps to Reproduce Updated View Revisions
2011-10-31 17:18 jonalegriaesarte Web browser Google Chrome => Google Chrome
2011-10-31 17:18 jonalegriaesarte Target Version 3.0MP5 => 3.0MP6
2011-11-10 09:38 malsasua Relationship added related to 0019014
2011-11-10 09:43 malsasua Note Added: 0042714
2011-11-10 09:43 malsasua Status scheduled => closed
2011-11-10 09:43 malsasua Resolution open => no change required

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker