Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012098Openbravo ERP09. Financial managementpublic2010-02-02 11:462010-04-14 00:00
Reporternetworkb 
Assigned Torajagopal 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP11 
Target Version2.50MP14Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012098: Balance sheet shows subaccounts when Breakdown is selected
DescriptionIf Balance Sheet is executed, and as Account Level, Breakdown is selected, report shows as well subaccounts. And it should not.
Steps To ReproduceGo to Financial Management > Accounting > Analysis tools > Balance sheet and P&L structure Setup.
Create a new register (select * organization). Call it, "Balance sheet". Check "Balanced" and select "Periodic" as Report type.
Go to Grouping category. Create a new register. Call it Asset.
Go to Node tab. Create a new register. Call it Asset. As Account Element, select "A-Activo" (if Spanish COA is used).
Go back to Grouping category. Create a new register. Call it Liability.
Go to Node tab. Create a new register. Call it Liability. As Account Element, select "P-Pasivo" (if Spanish COA is used).
Go to Financial Management > Analysis tools >Balance sheet and P&L structure. Select an Accounting Schema, the Accounting report created previously. as Organization, select "Main"; and as Account Element, "Breakdown".
Select as Year and Reference Year, "2006".
Press "PDF Format"
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesgz General Accounting Reports.tar.gz (82,466) 2010-03-01 10:36
https://issues.openbravo.com/file_download.php?file_id=2283&type=bug
zip GeneralAccountingReports_3rd_March_2010.zip (31,071) 2010-03-03 07:41
https://issues.openbravo.com/file_download.php?file_id=2296&type=bug
jpg Subaccounts.jpg (279,666) 2010-03-03 11:06
https://issues.openbravo.com/file_download.php?file_id=2297&type=bug
Issue History
Date ModifiedUsernameFieldChange
2010-02-02 11:46networkbNew Issue
2010-02-02 11:46networkbAssigned To => rafaroda
2010-02-08 12:43rafarodaNote Added: 0024009
2010-02-08 12:43rafarodaAssigned Torafaroda => dalsasua
2010-02-23 10:27dalsasuaPrioritynormal => urgent
2010-02-26 07:12rajagopalAssigned Todalsasua => rajagopal
2010-02-26 08:23dalsasuaStatusnew => scheduled
2010-02-26 08:23dalsasuafix_in_branch => pi
2010-02-26 08:36dalsasuaAssigned Torajagopal => balamurugan
2010-03-01 10:36balamuruganFile Added: General Accounting Reports.tar.gz
2010-03-01 10:38balamuruganNote Added: 0024894
2010-03-01 10:38balamuruganAssigned Tobalamurugan => networkb
2010-03-01 13:46balamuruganNote Added: 0024905
2010-03-01 13:46balamuruganStatusscheduled => feedback
2010-03-01 13:47balamuruganNote Deleted: 0024894
2010-03-01 17:48networkbNote Added: 0024918
2010-03-01 17:48networkbStatusfeedback => new
2010-03-01 17:48networkbfix_in_branchpi =>
2010-03-01 18:02networkbAssigned Tonetworkb => balamurugan
2010-03-03 07:12balamuruganAssigned Tobalamurugan => rajagopal
2010-03-03 07:40rajagopalNote Added: 0024978
2010-03-03 07:41rajagopalFile Added: GeneralAccountingReports_3rd_March_2010.zip
2010-03-03 07:42rajagopalAssigned Torajagopal => balamurugan
2010-03-03 07:42rajagopalStatusnew => feedback
2010-03-03 11:06networkbNote Added: 0024986
2010-03-03 11:06networkbFile Added: Subaccounts.jpg
2010-03-03 11:06networkbStatusfeedback => new
2010-03-03 13:48rajagopalAssigned Tobalamurugan => rajagopal
2010-03-08 12:21hgbotCheckin
2010-03-08 12:21hgbotNote Added: 0025118
2010-03-08 12:21hgbotStatusnew => resolved
2010-03-08 12:21hgbotResolutionopen => fixed
2010-03-08 12:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0a7b0c4f0ef22402fa4d3a263c5816ed5148c656 [^]
2010-03-08 16:05jpabloaeTarget Version2.50MP13 => 2.50MP14
2010-03-12 22:41hudsonbotCheckin
2010-03-12 22:41hudsonbotNote Added: 0025403
2010-04-13 12:31psarobeNote Added: 0026132
2010-04-13 12:31psarobeStatusresolved => closed
2010-04-14 00:00anonymoussf_bug_id0 => 2986790

Notes
(0024009)
rafaroda   
2010-02-08 12:43   
David,

Can you please take action on this issue?

Thanks.
(0024905)
balamurugan   
2010-03-01 13:46   
I generated Balance Sheet and PL reports at various levels. And herewith i have attached those reports in a tar.gz file.

I could see there are some differences between those reports generated at various levels.

Please find the highlighted differences between the reports generated at Breakdown and Subaccount levels.

Subaccount Level:

B) Inmovilizado
                                                                     0,00 0,00
I. Gastos de establecimiento
    Gastos de constitución 0,00 0,00
     Gastos de constitución 0,00 0,00
    Gastos de primer establecimiento 0,00 0,00
     Gastos de primer establecimiento 0,00 0,00
    Gastos de ampliación de capital 0,00 0,00
     Gastos de ampliación de capital 0,00 0,00
                                                                     0,00 0,00
II. Inmovilizaciones inmateriales
    1. Gastos de investigación y desarrollo 0,00 0,00
     Gastos de investigación y desarrollo 0,00 0,00
       Gastos de investigación y desarrollo en proyectos no termina 0,00 0,00
        Gastos de investigación y desarrollo en proyectos no termina 0,00 0,00
       Gastos de investigación y desarrollo en proyectos terminados 0,00 0,00
        Gastos de investigación y desarrollo en proyectos terminados 0,00 0,00
    2. Concesiones, patentes, licencias, marcas y similares 0,00 0,00

Breakdown Level:

B) Inmovilizado
                                                                    0,00 0,00
I. Gastos de establecimiento
    Gastos de constitución 0,00 0,00
     Gastos de constitución 0,00 0,00
    Gastos de primer establecimiento 0,00 0,00
     Gastos de primer establecimiento 0,00 0,00
    Gastos de ampliación de capital 0,00 0,00
     Gastos de ampliación de capital 0,00 0,00
                                                                    0,00 0,00
II. Inmovilizaciones inmateriales
    1. Gastos de investigación y desarrollo 0,00 0,00
     Gastos de investigación y desarrollo 0,00 0,00
       Gastos de investigación y desarrollo en proyectos no termina 0,00 0,00
       Gastos de investigación y desarrollo en proyectos terminados 0,00 0,00
    2. Concesiones, patentes, licencias, marcas y similares 0,00 0,00
     Concesiones administrativas 0,00 0,00
       Concesiones administrativas 0,00 0,00
     Propiedad industrial 0,00 0,00
       Propiedad industrial
(0024918)
networkb   
2010-03-01 17:48   
Hi,

There are diferences between all reports. However, GeneralAccountingReports_Breakdown_level.pdf still shows subaccounts.
To check it, select "Show Account codes" when executing the report.
IE, 41090 will be shown.
If you go to Account Tree, and search this account, you will check that it is a subaccount.
(0024978)
rajagopal   
2010-03-03 07:40   
Hello,

I have attached one PDF Report named "GeneralAccountingReports_3rd_March_2010.zip" which contains the PDF report with Account Level as "Breakdown".

Could you please tell me where you are seeing the sub-account details in the pdf report document. Which will help us to fix this issue. Kindly provide us the detailed information like on which page of the pdf document(the new attachment) you are seeing the sub account details when you execute the report with Breakdown level.

Thanks,
Rajagopal Baskaran.
(0024986)
networkb   
2010-03-03 11:06   
Hi,

Please, see attached image.

In general, all account with 5 digits
(0025118)
hgbot   
2010-03-08 12:21   
Repository: erp/devel/pi
Changeset: 0a7b0c4f0ef22402fa4d3a263c5816ed5148c656
Author: Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
Date: Mon Mar 08 16:56:23 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/0a7b0c4f0ef22402fa4d3a263c5816ed5148c656 [^]

Fixes Issue 12098: Balance sheet shows subaccounts when Breakdown is selected

---
M src/org/openbravo/erpCommon/businessUtility/AccountTree.java
---
(0025403)
hudsonbot   
2010-03-12 22:41   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/0a7b0c4f0ef2 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]
(0026132)
psarobe   
2010-04-13 12:31   
Tested, working fine