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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0043191
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementminoralways2020-01-29 09:552020-04-06 15:45
ReporterngarciaView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityimmediateResolutionfixedFixed in Version3.0PR20Q1
StatusclosedFix in branchFixed in SCM revision33b9c4bd63e2
ProjectionnoneETAnoneTarget Version3.0PR20Q1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression levelProduction - Confirmed Stable
Regression date2019-05-07
Regression introduced in release3.0PR19Q3
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/3c5c9d991b1e6e6c6aeedad4a6cbf35dbbdcabe1 [^]
Triggers an Emergency PackNo
Summary

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

Description[Balance Sheet and P&L Structure: User can select General Ledger of organizations for its natural tree but not Accounting Report
Steps To ReproduceAs 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
Proposed SolutionThe filter of the Accounting Report field should be the same as the filter for the General Ledger. It is using #AccessibleOrgTree

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0043042 closedAtulOpenbravo [Balance Sheet and P&L Structure: User can select General Ledger of organizations for its natural tree but not Accounting Report 

-  Notes
(0117664)
AtulOpenbravo (developer)
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.
(0117700)
hgbot (developer)
2020-02-12 17:11

Repository: erp/backports/3.0PR20Q1
Changeset: 9408edee194a0eac3143f8a18b4a2f8796cc2e3a
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Feb 12 11:20:39 2020 +0530
URL: http://code.openbravo.com/erp/backports/3.0PR20Q1/rev/9408edee194a0eac3143f8a18b4a2f8796cc2e3a [^]

Fixes BUG-43191:[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
---
(0117707)
dmiguelez (developer)
2020-02-12 17:19

Code Review + Testing Ok
(0118961)
hgbot (developer)
2020-04-06 11:53

Repository: erp/devel/pi
Changeset: 33b9c4bd63e2fa0231530ffc45ca6e39132a2414
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Feb 12 11:20:39 2020 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/33b9c4bd63e2fa0231530ffc45ca6e39132a2414 [^]

Fixes BUG-43191:[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
---
(0118988)
jarmendariz (developer)
2020-04-06 15:45

closed: wrongly reopened

- Issue History
Date Modified Username Field Change
2020-02-12 06:44 AtulOpenbravo Type defect => backport
2020-02-12 06:44 AtulOpenbravo Target Version => 3.0PR20Q1
2020-02-12 06:45 AtulOpenbravo Note Added: 0117664
2020-02-12 17:11 hgbot Checkin
2020-02-12 17:11 hgbot Note Added: 0117700
2020-02-12 17:11 hgbot Status scheduled => resolved
2020-02-12 17:11 hgbot Resolution open => fixed
2020-02-12 17:11 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR20Q1/rev/9408edee194a0eac3143f8a18b4a2f8796cc2e3a [^]
2020-02-12 17:19 dmiguelez Review Assigned To => dmiguelez
2020-02-12 17:19 dmiguelez Note Added: 0117707
2020-02-12 17:19 dmiguelez Status resolved => closed
2020-02-12 17:19 dmiguelez Fixed in Version => 3.0PR20Q1
2020-04-06 11:53 hgbot Checkin
2020-04-06 11:53 hgbot Note Added: 0118961
2020-04-06 11:53 hgbot Status closed => resolved
2020-04-06 11:53 hgbot Fixed in SCM revision http://code.openbravo.com/erp/backports/3.0PR20Q1/rev/9408edee194a0eac3143f8a18b4a2f8796cc2e3a [^] => http://code.openbravo.com/erp/devel/pi/rev/33b9c4bd63e2fa0231530ffc45ca6e39132a2414 [^]
2020-04-06 15:45 jarmendariz Note Added: 0118988
2020-04-06 15:45 jarmendariz Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker