Openbravo Issue Tracking System - Openbravo ERP | |||||||||||||||||||
| View Issue Details | |||||||||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||||||||||||
| 0018669 | Openbravo ERP | 09. Financial management | public | 2011-10-03 10:09 | 2011-11-10 09:43 | ||||||||||||||
| Reporter | malsasua | ||||||||||||||||||
| Assigned To | ioritzCia | ||||||||||||||||||
| Priority | high | Severity | major | Reproducibility | always | ||||||||||||||
| Status | closed | Resolution | no change required | ||||||||||||||||
| Platform | OS | 20 | OS Version | Community Appliance | |||||||||||||||
| Product Version | |||||||||||||||||||
| Target Version | 3.0MP6 | Fixed in Version | |||||||||||||||||
| Merge Request Status | |||||||||||||||||||
| Review Assigned To | |||||||||||||||||||
| OBNetwork customer | |||||||||||||||||||
| Web browser | Google Chrome | ||||||||||||||||||
| Modules | Core | ||||||||||||||||||
| Support ticket | |||||||||||||||||||
| Regression level | |||||||||||||||||||
| Regression date | |||||||||||||||||||
| Regression introduced in release | |||||||||||||||||||
| Regression introduced by commit | |||||||||||||||||||
| Triggers an Emergency Pack | No | ||||||||||||||||||
| Summary | 0018669: in report trial balance, the XLS and HTML report does not display the same information | ||||||||||||||||||
| Description | The 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 Solution | In 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 | ||||||||||||||||||
| Additional Information | |||||||||||||||||||
| Tags | No tags attached. | ||||||||||||||||||
| Relationships |
| ||||||||||||||||||
| Attached Files | |||||||||||||||||||
| 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 | bug_revision_view_page.php?rev_id=2843#r2843 | ||||||||||||||||
| 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 | ||||||||||||||||
| Notes | |||||
|
|
|||||
|
|
||||