Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033020ModulesMulti-Dimensional Profit And Losspublic2016-05-23 10:162016-06-01 10:55
ReporterJONHM 
Assigned ToSanjota 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toaferraz
Support ticket41946
OBNetwork customerOBPS
Regression introduced in release
Summary0033020: Process "Generate Profit and Loss Fact Act" fails in a cube with more than 1000 accounts
DescriptionIn cubes having more than 1000 accounts the process fails.
Steps To Reproduce** First of all we need to install the module "Multi-Dimensional Profit And Loss Report"

1) We need to generate the cube. As System Administrator go to "Cube Definition" and generate a cube for "DPL - P&L Template" for user "F&B International Group"
2) Change role to "F&B International Group Admin". Go to "Cube Definition" and select the new cube "DPL - P&L - F&B España, S.A. US_A_Euro". Navigate to tab Cube Reports/Cube Report Dimension/Cube Report Dimension Element and configure the cube like in the attached image.
3) Go to "Process Request" and create a new process "Generate Profit and Loss Fact Act" and schedule that process.

*** The process ends with an error
Proposed SolutionOn file GuenrateProfitAndLossFactAcctTable.java, at line 81 the last iteration fails because maxLength become a negative value. We need to override that line with this one:

- } else {
- maxLenght = pAndLAccounts.size() - (i * 1000);
- }

+ } else {
+ maxLenght = pAndLAccounts.size();
+ }
Additional Information
TagsNo tags attached.
Relationships
related to defect 0032840 closed AtulOpenbravo Generate Profit and Loss Fact Acct process creates records in obdpl_fact_acct_pl although there are no accounts defined in cube 
Attached Filespng DefinicionCuentas.png (103,706) 2016-05-23 10:16
https://issues.openbravo.com/file_download.php?file_id=9432&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2016-05-23 10:16JONHMNew Issue
2016-05-23 10:16JONHMAssigned To => Triage Finance
2016-05-23 10:16JONHMFile Added: DefinicionCuentas.png
2016-05-23 10:16JONHMRegression date => 2016-06-20
2016-05-23 10:16JONHMSupport ticket => 41946
2016-05-23 10:16JONHMOBNetwork customer => Yes
2016-05-23 10:57JONHMRegression date2016-06-20 =>
2016-05-23 10:57JONHMResolution time => 1466373600
2016-05-23 11:27aferrazRelationship addedrelated to 0032840
2016-05-23 11:27aferrazAssigned ToTriage Finance => Sanjota
2016-05-25 09:46SanjotaStatusnew => scheduled
2016-05-25 11:09SanjotaNote Added: 0086732
2016-06-01 10:46hgbotCheckin
2016-06-01 10:46hgbotNote Added: 0086885
2016-06-01 10:46hgbotStatusscheduled => resolved
2016-06-01 10:46hgbotResolutionopen => fixed
2016-06-01 10:46hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalpandlreport/rev/8b994770861cb0a60e41f78d460ddb1f1f9c39e5 [^]
2016-06-01 10:46hgbotCheckin
2016-06-01 10:46hgbotNote Added: 0086886
2016-06-01 10:55hgbotCheckin
2016-06-01 10:55hgbotNote Added: 0086889
2016-06-01 10:55aferrazReview Assigned To => aferraz
2016-06-01 10:55aferrazNote Added: 0086890
2016-06-01 10:55aferrazStatusresolved => closed

Notes
(0086732)
Sanjota   
2016-05-25 11:09   
1. Install the module "Multi-Dimensional Profit And Loss Report".
2. As System Administrator go to "Cube Definition" and generate a cube for "DPL - P&L Template" for user "F&B International Group"
3. Change role to "F&B International Group Admin" and Organization to "F&B España, S.A".
4. Go to "Cube Definition" and select the new cube "DPL - P&L - F&B España, S.A. US_A_Euro". Navigate to tab Cube Reports/Cube Report Dimension/Cube Report Dimension Element and configure the cube like in the attached image.
5. Go to "Process Request" and create a new process "Generate Profit and Loss Fact Act" (Not required if it already exist) and schedule that process.

***Check that the process completes with success status.
(0086885)
hgbot   
2016-06-01 10:46   
Repository: erp/pmods/org.openbravo.financial.dimensionalpandlreport
Changeset: 8b994770861cb0a60e41f78d460ddb1f1f9c39e5
Author: Sanjota <sanjota.nelagi <at> promantia.com>
Date: Wed May 25 16:03:49 2016 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalpandlreport/rev/8b994770861cb0a60e41f78d460ddb1f1f9c39e5 [^]

Fixes issue 33020: Process "Generate Profit and Loss Fact Act" fails

In cubes having more than 1000 accounts the process fails.

---
M src/org/openbravo/financial/dimensionalpandlreport/GenerateProfitAndLossFactAcctTable.java
---
(0086886)
hgbot   
2016-06-01 10:46   
Repository: erp/pmods/org.openbravo.financial.dimensionalpandlreport
Changeset: 41603e7b2a80b4bcf37d70e087bfb1f560b94809
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Jun 01 10:41:15 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalpandlreport/rev/41603e7b2a80b4bcf37d70e087bfb1f560b94809 [^]

Related to issue 33020: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0086889)
hgbot   
2016-06-01 10:55   
Repository: erp/pmods/org.openbravo.financial.dimensionalpandlreport
Changeset: 0ffd6967024244af95e704d65a8ca2943ba25f45
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Jun 01 10:53:42 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalpandlreport/rev/0ffd6967024244af95e704d65a8ca2943ba25f45 [^]

Related to issue 33020: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0086890)
aferraz   
2016-06-01 10:55   
Code review + Testing OK