Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0032539Openbravo ERP09. Financial managementpublic2016-03-23 11:582016-06-17 19:36
maite 
Sanjota 
immediatemajoralways
closedfixed 
5
 
3.0PR16Q3 
aferraz
Core
No
0032539: Accounts with operands not properly calculated in Balance Sheet when tree is defined for * and role has "organization" access
"selectOperands" query in AccountTree.java is using "#User_Org", so in case role used in defined as "Organization" then * organization is not included in "#User_Org" so elements with operands are not properly calculated
1. Ensure that role is defined as "Manual" and user level= Organization
2. Ensure that Account Tree is defined for * organization
3. Access Balance Sheet and PL Structure window to run "Balance Sheet" or "PL Reports and realize that calculated accounts (totals) are not properly calculated

NOTE: I can provide environment properly configured where problem is directly reproducible
"selectOperands" method should use "Utility.getContext(conn, vars, "#AccessibleOrgTree", "AccountTree")" instead of "Utility.getContext(conn, vars, "#User_Org", "AccountTree")"
No tags attached.
Issue History
2016-03-23 11:58maiteNew Issue
2016-03-23 11:58maiteAssigned To => Triage Finance
2016-03-23 11:58maiteModules => Core
2016-03-23 11:58maiteTriggers an Emergency Pack => No
2016-03-23 12:11maiteResolution time => 1459288800
2016-03-23 12:11maiteIssue Monitored: networkb
2016-04-04 10:14aferrazTarget Version3.0PR16Q2 =>
2016-04-04 14:31SanjotaAssigned ToTriage Finance => Sanjota
2016-04-05 15:36SanjotaNote Added: 0085446
2016-04-05 15:36SanjotaStatusnew => scheduled
2016-04-05 15:43SanjotaNote Edited: 0085446bug_revision_view_page.php?bugnote_id=0085446#r11671
2016-04-05 18:34hgbotCheckin
2016-04-05 18:34hgbotNote Added: 0085453
2016-04-05 18:34hgbotStatusscheduled => resolved
2016-04-05 18:34hgbotResolutionopen => fixed
2016-04-05 18:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5254bc036cf40136e05e63b3b59015b3c06aaab9 [^]
2016-04-05 18:34hgbotCheckin
2016-04-05 18:34hgbotNote Added: 0085454
2016-04-05 19:00aferrazReview Assigned To => aferraz
2016-04-05 19:00aferrazNote Added: 0085455
2016-04-05 19:00aferrazStatusresolved => closed
2016-04-05 19:00aferrazFixed in Version => 3.0PR16Q3
2016-06-17 19:36hudsonbotCheckin
2016-06-17 19:36hudsonbotNote Added: 0087427
2016-06-17 19:36hudsonbotCheckin
2016-06-17 19:36hudsonbotNote Added: 0087428

Notes
(0085446)
Sanjota   
2016-04-05 15:36   
(edited on: 2016-04-05 15:43)
Test Plan:
1. Created new role with manual=true and user level to O(Organization).
2. Assign any 1 organization in org access
3. Assign any user under User assignment tab.
4. Assign Balance sheet and P&L structure Setup window
5. Assign Balance sheet and P&L structure report
6. Make sure that account tree is defined for * organization.
7. Login with above newly created role and user
8. Create Balance sheet or PL structure report
9. Verify that calculated accounts(totals) are properly calculated

(0085453)
hgbot   
2016-04-05 18:34   
Repository: erp/devel/pi
Changeset: 5254bc036cf40136e05e63b3b59015b3c06aaab9
Author: Sanjota <sanjota.nelagi <at> promantia.com>
Date: Tue Apr 05 18:49:43 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/5254bc036cf40136e05e63b3b59015b3c06aaab9 [^]

Fixes issue 32539: Fixed wrong calculation in acct with operands

Use #AccessibleOrgTree instead of #User_Org.

---
M src/org/openbravo/erpCommon/businessUtility/AccountTree.java
---
(0085454)
hgbot   
2016-04-05 18:34   
Repository: erp/devel/pi
Changeset: 9f3e39f45db1a02bbdaca6f3f93328bbfcdd9a51
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Apr 05 18:08:46 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9f3e39f45db1a02bbdaca6f3f93328bbfcdd9a51 [^]

Related to issue 32539: Update copyright

---
M src/org/openbravo/erpCommon/businessUtility/AccountTree.java
---
(0085455)
aferraz   
2016-04-05 19:00   
Code review OK
(0087427)
hudsonbot   
2016-06-17 19:36   
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/0dc7be081b1c [^]
Maturity status: Test
(0087428)
hudsonbot   
2016-06-17 19:36   
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/0dc7be081b1c [^]
Maturity status: Test