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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0033193
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2016-06-08 13:492016-06-21 14:48
ReportermaiteView Statuspublic 
Assigned ToSanjota 
PriorityurgentResolutionfixedFixed in Version3.0PR16Q3
StatusclosedFix in branchFixed in SCM revision3383c34486c2
ProjectionnoneETAnoneTarget Version3.0PR16Q3
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toaferraz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033193: Not possible to run Balance Sheet or P&L defined for Generic organization

DescriptionOrganization combo appears empty when report chosen is defined for Generic organization. Wiki's information states that "If the organization selected is a Generic organization which belongs to a Legal with Accounting one, the financial information provided by the reports will be just the financial information of that organization."
Steps To Reproduce0. Follow configuration guide and create Balance Sheet report for "España norte" organization:
http://wiki.openbravo.com/wiki/Balance_sheet_and_P%26L_structure_Setup#Balance_Sheet_structure_setup_example [^]
1. Access "Balance Sheet and P&L structure" window and select report just created. Realize that organization combo does not show any value
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0087240)
psanjuan (manager)
2016-06-14 11:25
edited on: 2016-06-14 12:10

Issue verified as:

Go to Balance Sheet and P&L Structure setup window.
Create a new one for "F&B España - Region Norte" Organization with below setup:
Name = Balance - Region Norte
Report type = Point in Time
Balanced = No
Go to "Grouping category" tab and "Node" tab and create same set up as the one created for "Balance de Situación".

Go to Balance Sheet and P&L Structure window. Select below values:
General Ledger = F&B España US/A/Euro
Accounting Report = Balance - Region Norte
Organization = check that this field is empty and that should not be the case. It should be possible to select "F&B España - Región Norte", as "Balanced" check is set to = NO.

Note that "Balanced" setup check in combination with a "Point in Time" report, forces that only "legal with accounting" and "business unit" organization type are shown for that type of reports (Balance) in the "Organization" combo of "Balance Sheet and P&L structure" window.

If "Balanced" setup check is not selected for a "Point in Time" report (Balance), other type of organization rather than Legal with accounting can then be shown in the "Organization" combo of "Balance Sheet and P&L structure" window.

Check why this behavior has changed, as it seems to be a regression.

(0087307)
Sanjota (developer)
2016-06-15 15:05
edited on: 2016-06-17 11:01

Test Plan:
Go to Balance Sheet and P&L Structure setup window.
Create a new one for "F&B España - Region Norte" Organization with below setup:
Name = Balance - Region Norte
Report type = Point in Time
Balanced = No
Go to "Grouping category" tab and "Node" tab and create same set up as the one created for "Balance de Situación".

Go to Balance Sheet and P&L Structure window. Select below values:
General Ledger = F&B España US/A/Euro
Accounting Report = Balance - Region Norte
Organization = check that the Organization combo shows F&B España Region Norte and all the parents organizations of that one related to this general ledger: *, F&B International Group and F&B España.


Similarly
Go to Balance Sheet and P&L Structure setup window.
Create a new one for "F&B España - Region Norte" Organization with below setup:
Name = Balance - Region Norte
Report type = Point in Time
Balanced = Yes
Go to "Grouping category" tab and "Node" tab and create same set up as the one created for "Balance de Situación".

Go to Balance Sheet and P&L Structure window. Select below values:
General Ledger = F&B España US/A/Euro
Accounting Report = Balance - Region Norte
Organization = check that no organization is shown as F&B España Region Norte is not a legal entity with accounting either a business unit.


Repeat same test for General Ledger = F&B International Group Dollar. Check that same results are shown.

Note: This confirms,
For any report setup
a) If the balanced='true' then get Business units or Legal Entity in Org combo of the report
b) If the balanced='false' then get all organizations in Org combo of the report.

(0087354)
psanjuan (manager)
2016-06-16 15:44
edited on: 2016-06-17 11:03

Test Plan:

Go to Balance Sheet and P&L Structure setup.
Verify that there are two types of reports setup there.

Balance related ones are setup as:
Point in time
Balanced = Yes

P&L related ones are setup as:
Periodic
Balanced = No.

Go to Balance Sheet and P&L Structure. Select Dollar General ledger and "Balance Sheet" accounting report:
- Verify that only Legal with Accounting org are shown, together with Summary Organization: F&B Inter, F&B US and F&B España

Go to Balance Sheet and P&L Structure. Select Euro General Ledger an "Balance Sheet" accounting report:
- Verify that only Legal with Accounting org are shown, together with Summary Organization: F&B Inter and F&B España

Go to Balance Sheet and P&L Structure. Select Dollar General Ledger an "Profit & Loss" accounting report:
- Verify that all organizations are shown.

Go to Balance Sheet and P&L Structure. Select Euro Ledger an "Perdidas y Ganancias" accounting report:
- Verify that all organization related to that general ledger are shown: F&B International, F&B España, F&B España Norte, F&B España Sur, *.

(0087385)
psanjuan (manager)
2016-06-17 11:07

Test Plan:

Go to Balance Sheet and P&L structure setup.

Create a new one for F&B España Region Norte with below setup:
Name = PYG Norte
General Ledger = F&B España Euro
Report Type = Periodic
Balanced = No.

Go to Balance Sheet and P&L structure window and select PYG Norte report.
Check that Organization combo shows below org: *, F&B Intern, F&B España, F&B España Region Norte.

Go to Balance Sheet and P&L structure setup window and change PYG Norte as Balanced = Yes.

Go to Balance Sheet and P&L structure window and select PYG Norte report.
Check that no Organization is shown in "Organization" combo box.
(0087386)
psanjuan (manager)
2016-06-17 11:08

Test Plan above verified. Issue can be closed.
(0087399)
hgbot (developer)
2016-06-17 14:25

Repository: erp/devel/pi
Changeset: 3383c34486c2acbe060839cc2646ab753796d7aa
Author: Sanjota <sanjota.nelagi <at> promantia.com>
Date: Wed Jun 15 18:26:36 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/3383c34486c2acbe060839cc2646ab753796d7aa [^]

Fixes issue 33193: Failed to run Balance Sheet defined for Generic organization

Changes been done for Balance sheet report. i.e
a) If the balanced='true' then get Business units or Legal Entity in Org combo
b) If the balanced='false' then get all organizations in Org combo.

---
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql
---
(0087400)
aferraz (manager)
2016-06-17 14:26

Code review OK
(0087725)
hudsonbot (developer)
2016-06-21 14:48

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/7f9896fd81e9 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2016-06-08 13:49 maite New Issue
2016-06-08 13:49 maite Assigned To => Triage Finance
2016-06-08 13:49 maite Modules => Core
2016-06-08 13:49 maite Resolution time => 1467064800
2016-06-08 13:49 maite Triggers an Emergency Pack => No
2016-06-08 13:49 maite Issue Monitored: networkb
2016-06-09 13:49 aferraz Assigned To Triage Finance => markmm82
2016-06-13 17:49 Sanjota Assigned To markmm82 => Sanjota
2016-06-13 17:49 Sanjota Status new => scheduled
2016-06-14 11:25 psanjuan Note Added: 0087240
2016-06-14 11:59 psanjuan Note Edited: 0087240 View Revisions
2016-06-14 12:04 psanjuan Note Edited: 0087240 View Revisions
2016-06-14 12:10 psanjuan Note Edited: 0087240 View Revisions
2016-06-15 15:05 Sanjota Note Added: 0087307
2016-06-16 15:44 psanjuan Note Added: 0087354
2016-06-17 10:18 psanjuan Note Edited: 0087354 View Revisions
2016-06-17 10:31 psanjuan Note Edited: 0087354 View Revisions
2016-06-17 10:45 psanjuan Note Edited: 0087354 View Revisions
2016-06-17 10:55 psanjuan Note Edited: 0087307 View Revisions
2016-06-17 10:58 psanjuan Note Edited: 0087307 View Revisions
2016-06-17 11:01 psanjuan Note Edited: 0087307 View Revisions
2016-06-17 11:03 psanjuan Note Edited: 0087354 View Revisions
2016-06-17 11:07 psanjuan Note Added: 0087385
2016-06-17 11:08 psanjuan Note Added: 0087386
2016-06-17 14:25 hgbot Checkin
2016-06-17 14:25 hgbot Note Added: 0087399
2016-06-17 14:25 hgbot Status scheduled => resolved
2016-06-17 14:25 hgbot Resolution open => fixed
2016-06-17 14:25 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3383c34486c2acbe060839cc2646ab753796d7aa [^]
2016-06-17 14:26 aferraz Review Assigned To => aferraz
2016-06-17 14:26 aferraz Note Added: 0087400
2016-06-17 14:26 aferraz Status resolved => closed
2016-06-17 14:26 aferraz Fixed in Version => 3.0PR16Q3
2016-06-21 14:48 hudsonbot Checkin
2016-06-21 14:48 hudsonbot Note Added: 0087725


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker