Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0043042Openbravo ERP09. Financial managementpublic2020-01-29 09:552020-02-12 17:20
ngarcia 
AtulOpenbravo 
immediateminoralways
closedfixed 
5
 
3.0PR20Q2 
dmiguelez
Core
Production - Confirmed Stable
2019-05-07
3.0PR19Q3
https://code.openbravo.com/erp/devel/pi/rev/3c5c9d991b1e6e6c6aeedad4a6cbf35dbbdcabe1 [^]
No
0043042: [Balance Sheet and P&L Structure: User can select General Ledger of organizations for its natural tree but not Accounting Report
[Balance Sheet and P&L Structure: User can select General Ledger of organizations for its natural tree but not Accounting Report
As group admin role:
   Define a General Ledger in * organization
   Define a Balance sheet and P&L structure setup in * organization

Log out and log in:
   Check you can select the General Ledger and the Accounting report in the Balance sheet and P&L structure

Log in with a role that do not have access to organization:
    Check you can select the General Ledger but you cannot select the Accounting report in the Balance sheet and P&L structure
The filter of the Accounting Report field should be the same as the filter for the General Ledger. It is using #AccessibleOrgTree

No tags attached.
depends on backport 00431913.0PR20Q1 closed AtulOpenbravo [Balance Sheet and P&L Structure: User can select General Ledger of organizations for its natural tree but not Accounting Report 
depends on backport 00431923.0PR19Q4.2 closed AtulOpenbravo [Balance Sheet and P&L Structure: User can select General Ledger of organizations for its natural tree but not Accounting Report 
depends on backport 00431933.0PR19Q3.4 closed AtulOpenbravo [Balance Sheet and P&L Structure: User can select General Ledger of organizations for its natural tree but not Accounting Report 
caused by defect 0040698 closed nonofrancisco Accounting Report field of Balance Sheet and P&L structure is showing definitions made in non-accessible organizations 
Issue History
2020-01-29 09:55ngarciaNew Issue
2020-01-29 09:55ngarciaAssigned To => Triage Finance
2020-01-29 09:55ngarciaModules => Core
2020-01-29 09:55ngarciaTriggers an Emergency Pack => No
2020-01-29 09:55ngarciaRelationship addedcaused by 0040698
2020-01-29 09:56ngarciaResolution time => 1582066800
2020-01-29 09:58ngarciaProposed Solution updated
2020-01-29 09:59ngarciaIssue Monitored: networkb
2020-01-30 15:40dmiguelezAssigned ToTriage Finance => AtulOpenbravo
2020-01-31 14:57AtulOpenbravoStatusnew => scheduled
2020-02-06 11:42dmiguelezNote Added: 0117509
2020-02-06 11:42dmiguelezSeveritymajor => minor
2020-02-11 05:49AtulOpenbravoNote Added: 0117619
2020-02-12 05:39AtulOpenbravoNote Edited: 0117619bug_revision_view_page.php?bugnote_id=0117619#r20347
2020-02-12 06:40AtulOpenbravoNote Edited: 0117619bug_revision_view_page.php?bugnote_id=0117619#r20348
2020-02-12 06:41AtulOpenbravoStatusscheduled => acknowledged
2020-02-12 06:43AtulOpenbravoRegression level => Production - Confirmed Stable
2020-02-12 06:43AtulOpenbravoRegression date => 2019-05-07
2020-02-12 06:43AtulOpenbravoRegression introduced in release => 3.0PR19Q3
2020-02-12 06:43AtulOpenbravoRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/3c5c9d991b1e6e6c6aeedad4a6cbf35dbbdcabe1 [^]
2020-02-12 06:44AtulOpenbravoStatusacknowledged => scheduled
2020-02-12 17:17hgbotCheckin
2020-02-12 17:17hgbotNote Added: 0117704
2020-02-12 17:17hgbotStatusscheduled => resolved
2020-02-12 17:17hgbotResolutionopen => fixed
2020-02-12 17:17hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b85ca0db386b650f4584d9cc43dcae3227f82efb [^]
2020-02-12 17:20dmiguelezReview Assigned To => dmiguelez
2020-02-12 17:20dmiguelezNote Added: 0117708
2020-02-12 17:20dmiguelezStatusresolved => closed
2020-02-12 17:20dmiguelezFixed in Version => 3.0PR20Q2

Notes
(0117509)
dmiguelez   
2020-02-06 11:42   
The severity of the issue has been updated to minor following the Openbravo reporting guidelines:
http://wiki.openbravo.com/wiki/Bug_Reporting_Guidelines [^]
(0117619)
AtulOpenbravo   
2020-02-11 05:49   
(edited on: 2020-02-12 06:40)
- Create a General Ledger (Star GL) and Balance Sheet and P&L Structure Setup (RPT Star) record in Star Organization.
- Create a new Organization (US 1) under F&B US Inc as Generic, Assign new General Ledger (Star GL) in new organization i.e US 1, set this as Ready.
- Create a General Ledger (GL US) and Balance Sheet and P&L Structure Setup (RPT US) record in F&B US Inc Organization. Assign new General Ledger in respective organization i.e F&B US Inc.
- Create a General Ledger (GL EC) and Balance Sheet and P&L Structure Setup (RPT EC) record in F&B US East Coast Organization. Assign new General Ledger in respective organization i.e F&B US East Coast.
- Create a Role (US Role) with access to F&B US Inc Organization and Balance Sheet and P&L Structure Report & Process access.
- Create a Role (EC Role) with access to F&B US East Coast Organization and Balance Sheet and P&L Structure Report & Process access..
- Create a Role (Group + EC Role) with access to F&B International Group & F&B US East Coast Organization and Balance Sheet and P&L Structure Report & Process access..
- Create a Role (US1 Role) with access to US1 Organization and Balance Sheet and P&L Structure Report & Process access.

Test A:

- Login with US1 Role
- Navigate to Balance Sheet and P/L Structure
- Realize that General Ledger shows Star GL, F&B International Group US/A/US Dollar and US GL in the list.
- When selecting Star GL, Accounting Report shown is Star RPT, select Star RPT, Organization shown is US1 in the list.
- When selecting F&B International Group US/A/US Dollar GL, Accounting Report shown are Balance Sheet, Profit & Loss.
- Select Balance Sheet RPT, Organization list is empty. This is correct has US1 organization is of Generic Type.
- Select Profit and Loss or US RPT, Organization US1 is shown in the list.
- Select US GL, US RPT is shown in Accounting Report, select it, US1 organization is in the list.


Test B:

- Login with US Role
- Navigate to Balance Sheet and P/L Structure
- Realize that General Ledger shows Star GL, US GL, EC GL, F&B International Group US/A/US Dollar
- When selecting EC GL, Accounting Report show EC RPT, select it, only organization F&B US Inc is available in the list.
- When selecting US GL, Accounting Report show US RPT, select it, only organization F&B US Inc is available in the list.
- When selecting Star GL, Accounting Report shows Star RPT, select it, only organization F&B US Inc is available in the list.
- When selecting F&B International Group US/A/US Dollar Ledger, Accounting Report displayed are Balance Sheet, Profit & Loss.
- When selecting any one of the RPT i.e Balance Sheet or Profit & Loss, Organization F&B US Inc is only available in the list.


Test C
- Login with EC Role
- Navigate to Balance Sheet and P/L Structure
- Realize that General Ledger available in the list are Star GL, US GL, EC GL, F&B International Group US/A/US Dollar.
- Select Star GL, Accounting Report shown is Star RPT, when selecting it, Organization list is empty.
- Select EC GL , Realize that Accounting Report list shows only EC RPT, select it, Organization shows only F&B US East Coast in the list.
- Select US GL , Realize that Accounting Report list shows only US RPT, select it, Organization shows only F&B US East Coast in the list.
- When selecting F&B International Group US/A/US Dollar Ledger, Accounting Report displayed are Balance Sheet, Profit & Loss.
- When selecting any one of the RPT i.e Profit & Loss, Organization F&B US East Coast is only available in the list. This is
correct.
- Select Balance Sheet RPT, Organization list is empty. This is correct has F&B US East Coast organization is of Generic Type.

Test D

- Login with Group + EC Role
- Navigate to Balance Sheet and P/L Structure
- Realize that General Ledger available in the list are
a. F&B Espana S.A US/A/Euro
b. F&B International Group US/A/US Dollar
c. GL US
d. GL EC
e. Star GL

D1.
- Select F&B Espana S.A US/A/Euro General Ledger, realize that Accounting Report shows
a. Balance de Situacion
b. Perdidas y Ganancias
appears in the list.
- Select a or b, realize only F&B International Group is available in Organization list. F&B East Coast is not shown here as it is not in the natural tree, though it is in the Role Organization Access list.

D2.
- Select F&B International Group US/A/US Dollar General Ledger, realize that Accounting Report shows
a. Balance Sheet
b. Profit and Loss
appears in the list.
- Select Balance Sheet in the Accounting Report
- Realize only F&B International Group is available in Organization list.
- Select Profit and Loss in the Accounting Report
- Realize F&B International Group & F&B US East Coast both are available in Organization list.

D3.
- Select GL US General Ledger
- Realize RPT US is only available in the Accounting Report, select it.
- Realize F&B International Group & F&B US East Coast both are available in Organization list.

D4.
- Select GL EC General Ledger
- Realize RPT EC is only available in the Accounting Report, select it.
- Realize F&B International Group & F&B US East Coast both are available in Organization list.

D5.
- Select Star GL General Ledger
- Realize RPT EC is only available in the Accounting Report, select it.
- Realize only F&B International Group is available in Organization list.

(0117704)
hgbot   
2020-02-12 17:17   
Repository: erp/devel/pi
Changeset: b85ca0db386b650f4584d9cc43dcae3227f82efb
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Fri Feb 07 14:55:33 2020 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/b85ca0db386b650f4584d9cc43dcae3227f82efb [^]

Fixes BUG-43042:[Balance Sheet and P&L Structure: User can
select General Ledger of organizations for its natural tree
but not Accounting Report

**While loading Accounting Reports in Balance Sheet and P&L
strcture, consider the natural tree of the accessible orgs,
instead of just checking the accessible organizations from
Role - Organization Access

---
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports.java
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql
---
(0117708)
dmiguelez   
2020-02-12 17:20   
Code Review + Testing Ok