Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0043192Openbravo ERP09. Financial managementpublic2020-01-29 09:552020-02-12 17:19
ngarcia 
AtulOpenbravo 
immediateminoralways
closedfixed 
5
 
3.0PR19Q4.23.0PR19Q4.2 
dmiguelez
Core
Production - Confirmed Stable
2019-05-07
3.0PR19Q3
https://code.openbravo.com/erp/devel/pi/rev/3c5c9d991b1e6e6c6aeedad4a6cbf35dbbdcabe1 [^]
No
0043192: [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.
blocks defect 0043042 closed AtulOpenbravo [Balance Sheet and P&L Structure: User can select General Ledger of organizations for its natural tree but not Accounting Report 
Issue History
2020-02-12 06:44AtulOpenbravoTypedefect => backport
2020-02-12 06:44AtulOpenbravoTarget Version => 3.0PR19Q4.2
2020-02-12 06:45AtulOpenbravoNote Added: 0117663
2020-02-12 17:15hgbotCheckin
2020-02-12 17:15hgbotNote Added: 0117701
2020-02-12 17:15hgbotStatusscheduled => resolved
2020-02-12 17:15hgbotResolutionopen => fixed
2020-02-12 17:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR19Q4.2/rev/3c25539344cf953d0bc05eee590b2ef45efb3d52 [^]
2020-02-12 17:19dmiguelezReview Assigned To => dmiguelez
2020-02-12 17:19dmiguelezNote Added: 0117706
2020-02-12 17:19dmiguelezStatusresolved => closed
2020-02-12 17:19dmiguelezFixed in Version => 3.0PR19Q4.2

Notes
(0117663)
AtulOpenbravo   
2020-02-12 06:45   
Test Plan

- 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.
(0117701)
hgbot   
2020-02-12 17:15   
Repository: erp/backports/3.0PR19Q4.2
Changeset: 3c25539344cf953d0bc05eee590b2ef45efb3d52
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Feb 12 11:17:57 2020 +0530
URL: http://code.openbravo.com/erp/backports/3.0PR19Q4.2/rev/3c25539344cf953d0bc05eee590b2ef45efb3d52 [^]

Fixes BUG-43192:[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
---
(0117706)
dmiguelez   
2020-02-12 17:19   
Code Review + Testing Ok