Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0005600Openbravo ERP09. Financial managementpublic2008-10-20 17:582009-04-21 12:36
lakshmi 
Hennadzi 
highmajoralways
closedfixed 
20RHEL 5
pi 
 
Core
No
0005600: QA-MAS - Error in General Accounting Report
While trying to view the General Accounting Report in PDF Format, it shows error. View the Attached screenshot
1. Go to Financial management->Accounting->Analysis tools->General Accounting Report.
2. Fill all the mandatory fields and select the Accounting schema, the related drop down list must be filled.
3. Select the Account level and click the PDF Format button.


Note:

For some account levels, shows empty response screen.
No tags attached.
jpg General Accounting Report.JPG (81,145) 2008-10-20 17:58
https://issues.openbravo.com/file_download.php?file_id=344&type=bug
jpg
Issue History
2008-10-20 17:58lakshmiNew Issue
2008-10-20 17:58lakshmiAssigned To => cromero
2008-10-20 17:58lakshmisf_bug_id0 => 2182640
2008-10-20 17:58lakshmiFile Added: General Accounting Report.JPG
2008-10-27 10:26psarobeStatusnew => scheduled
2008-10-27 10:26psarobeAssigned Tocromero => dalsasua
2008-10-27 10:26psarobefix_in_branch => trunk
2008-11-07 18:37dalsasuaNote Added: 0010084
2008-11-07 18:37dalsasuaStatusscheduled => feedback
2008-11-09 19:44psarobeNote Added: 0010097
2008-11-20 09:57rafarodaNote Added: 0010421
2008-12-03 19:03pjuvaraPrioritynormal => high
2008-12-10 09:47rafarodaNote Added: 0011111
2008-12-10 10:22lakshmiNote Added: 0011114
2009-01-09 14:09rafarodaStatusfeedback => scheduled
2009-01-09 14:09rafarodaNote Added: 0012028
2009-01-09 14:09rafarodaAssigned Todalsasua => Hennadzi
2009-01-19 13:26PavelPonomarevRelationship addedrelated to 0006993
2009-01-19 13:31PavelPonomarevRelationship deletedrelated to 0006993
2009-01-20 13:11svnbotCheckin
2009-01-20 13:11svnbotNote Added: 0012390
2009-01-20 13:11svnbotStatusscheduled => resolved
2009-01-20 13:11svnbotResolutionopen => fixed
2009-01-20 13:11svnbotsvn_revision => 12058
2009-04-21 12:36psarobeStatusresolved => closed

Notes
(0010084)
dalsasua   
2008-11-07 18:37   
This bug do not occur in the standard ERP with sampledata of trunk. Please give more information about the defect (chart of accounts of the client, structure of the report, etc)

Thanks
(0010097)
psarobe   
2008-11-09 19:44   
DAL,

Although it works for you, it's clear that a bug is present seeing the attach and that it has to do with the UUID project. Lakshmi, please give more information of how to reproduce the bug
(0010421)
rafaroda   
2008-11-20 09:57   
Reminder sent to: lakshmi

Feedback required for this issue.
(0011111)
rafaroda   
2008-12-10 09:47   
Reminder sent to: lakshmi

Hi Lakshmi. Please provide the detailed steps to reproduce this issue. Thank you.
(0011114)
lakshmi   
2008-12-10 10:22   
Tested in 2.50 - Multi Accounting Schema - Linux/Postgres

1. Login as Openbravo with role access to financial management
2. Go to Financial management->Accounting->Analysis tools->General Accounting Report
3. Fill the Years, the dates and the rest of the mandatory fields
    * Issues to verify:
          o There must be a new drop down list: Accounting schema
          o When selecting an accounting schema, the Accounting Report combo must be filled with the corresponding values related to that accounting schema
4. Select the account level and click the PDF Format button and shows the error
(0012028)
rafaroda   
2009-01-09 14:09   
Sees to be the typical PostgreSQL issue (missing TO_NUMBER) since the bug does not reproduce in Oracle.

Remember to first setup a new Balance sheet and P&L structure in Financial Management || Accounting || Analysis Tools || Balance sheet and P&L structure Setup
Ten execute the report in Financial Management || Accounting || Analysis Tools || Balance sheet and P&L structure
(0012390)
svnbot   
2009-01-20 13:11   
Repository: openbravo
Revision: 12058
Author: hennadzi
Date: 2009-01-20 13:11:51 +0100 (Tue, 20 Jan 2009)

Fixed bug 0005600: QA-MAS - Error in General Accounting Report

---
U trunk/src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=12058&sc=1 [^]