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

Notes
(0117662) AtulOpenbravo (viewer) 2020-02-12 06:44 edited on: 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.

(0117703) hgbot (developer) 2020-02-12 17:15	Repository: erp/backports/3.0PR19Q3.4 Changeset: 28a55c5831e238e0999d34659a747cba674431d1 Author: Atul Gaware <atul.gaware <at> openbravo.com> Date: Wed Feb 12 11:16:49 2020 +0530 URL: http://code.openbravo.com/erp/backports/3.0PR19Q3.4/rev/28a55c5831e238e0999d34659a747cba674431d1 [^] Fixes BUG-43193:[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 ---

(0117705) dmiguelez (viewer) 2020-02-12 17:19	Code Review + Testing Ok

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.0PR19Q3.4
2020-02-12 06:44	AtulOpenbravo	Note Added: 0117662
2020-02-12 06:45	AtulOpenbravo	Note Edited: 0117662	View Revisions
2020-02-12 17:15	hgbot	Checkin
2020-02-12 17:15	hgbot	Note Added: 0117703
2020-02-12 17:15	hgbot	Status	scheduled => resolved
2020-02-12 17:15	hgbot	Resolution	open => fixed
2020-02-12 17:15	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/backports/3.0PR19Q3.4/rev/28a55c5831e238e0999d34659a747cba674431d1 [^]
2020-02-12 17:19	dmiguelez	Review Assigned To	=> dmiguelez
2020-02-12 17:19	dmiguelez	Note Added: 0117705
2020-02-12 17:19	dmiguelez	Status	resolved => closed
2020-02-12 17:19	dmiguelez	Fixed in Version	=> 3.0PR19Q3.4