Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027286Openbravo ERP07. Sales managementpublic2014-08-06 17:292014-10-01 09:32
Reporterrafaroda 
Assigned ToAtulOpenbravo 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q1Fixed in Version 
Merge Request Status
Review Assigned Torafaroda
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027286: A.% field of Sales Invoice Dimensional Report comparative doesn't always work
DescriptionA.% field of Sales Invoice Dimensional Report comparative doesn't always work, displaying with same data different values depending of the Dimensions selected
Steps To ReproduceConsistently reproduced in https://livebuilds.openbravo.com/erp_pi_pgsql/ [^]

1) Create a Sales Invoice for organization F&B España - Región Norte and business partner Hoteles Buenas Noches, S.A. with invoice date 05-08-2014 and 40 units of product Cola 0,5 L: complete it

2) Create a Sales Invoice for organization F&B España - Región Norte and business partner Alimentos y Supermercados, S.A with invoice date 04-08-2014 and 100 units of product Vino Rosado 0,75 L: complete it

3) Launch Sales Invoice Dimensional Report with comparative check-box:
* From Date: 05-08-2014 - To Date: 05-08-2014
* From Reference Date: 04-08-2014 - To Reference Date: 04-08-2014
* Organization: F&B España, SA
* Dimensions: Product (1), Product Group (2)
* Currency: EUR

Launch HTML Format: A% is correctly calculated as -94.00 %, as % (Amount Total - Amount Ref Total) / Amount Ref Total (when Amount Total = 33.20 and Amount Ref Total = 563.00)

Repeat step 3 swapping Dimensions: Product Group (1), Product (2): A% is now wrongly calculated as -194.00%

See screenshots at https://drive.google.com/folderview?id=0B649lz4ZYJcHMzlsWk80d3lDY2c&usp=sharing [^]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-08-06 17:29rafarodaNew Issue
2014-08-06 17:29rafarodaAssigned To => dmiguelez
2014-08-06 17:29rafarodaModules => Core
2014-08-06 17:29rafarodaTriggers an Emergency Pack => No
2014-08-06 17:30rafarodaIssue Monitored: rafaroda
2014-08-07 11:44rafarodaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=6248#r6248
2014-08-08 08:52jonalegriaesarteResolution time => 1414101600
2014-08-08 08:52jonalegriaesarteTarget Version => 3.0PR14Q4
2014-08-08 09:06jonalegriaesarteResolution time1414101600 => 1410645600
2014-08-08 09:06jonalegriaesarteSeverityminor => major
2014-09-29 16:12jonalegriaesarteTarget Version3.0PR14Q4 => 3.0PR15Q1
2014-09-30 09:16AtulOpenbravoStatusnew => scheduled
2014-09-30 09:16AtulOpenbravoAssigned Todmiguelez => AtulOpenbravo
2014-09-30 09:16AtulOpenbravofix_in_branch => pi
2014-09-30 19:22AtulOpenbravoNote Added: 0070577
2014-10-01 09:18AtulOpenbravoReview Assigned To => rafaroda
2014-10-01 09:18AtulOpenbravofix_in_branchpi =>
2014-10-01 09:19hgbotCheckin
2014-10-01 09:19hgbotNote Added: 0070599
2014-10-01 09:19hgbotStatusscheduled => resolved
2014-10-01 09:19hgbotResolutionopen => fixed
2014-10-01 09:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/23958a53eacd7e40a5ca56fa79b672f79c95af3b [^]
2014-10-01 09:32rafarodaNote Added: 0070601
2014-10-01 09:32rafarodaStatusresolved => closed

Notes
(0070577)
AtulOpenbravo   
2014-09-30 19:22   
Test Plan

- Create a Sales Invoice for organization F&B España - Región Norte and business partner Hoteles Buenas Noches, S.A. with invoice date 05-08-2014 and 40 units of product Cola 0,5 L: complete it

- Create a Sales Invoice for organization F&B España - Región Norte and business partner Alimentos y Supermercados, S.A with invoice date 04-08-2014 and 100 units of product Vino Rosado 0,75 L: complete it

- Launch Sales Invoice Dimensional Report with comparative check-box:
  * From Date: 05-08-2014 - To Date: 05-08-2014
  * From Reference Date: 04-08-2014 - To Reference Date: 04-08-2014
  * Organization: F&B España, SA
  * Dimensions: Product (1), Product Group (2)
  * Currency: EUR

- Launch HTML Format: A% is correctly calculated as -94.00 %,
 as % (Amount Total - Amount Ref Total) / Amount Ref Total
 (where Amount Total = 33.20 and Amount Ref Total = 563.00)

- Repeat step 3 swapping Dimensions: Product Group (1), Product (2):
A% is now again correctly calculated as -94.00%
(0070599)
hgbot   
2014-10-01 09:19   
Repository: erp/devel/pi
Changeset: 23958a53eacd7e40a5ca56fa79b672f79c95af3b
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Sep 30 15:03:38 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/23958a53eacd7e40a5ca56fa79b672f79c95af3b [^]

Fixes Issue 27286: A.% field of Sales Invoice Dimensional Report comparative
doesn't always work.

For variable percentage total calculation type is set to 'Sum' which should be
set to 'Nothing'.

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml
---
(0070601)
rafaroda   
2014-10-01 09:32   
Reviewed different dimensions ordering and A% is properly calculated: see screenshoots at https://drive.google.com/folderview?id=0B649lz4ZYJcHSFlJSEFHQ1ZSMUE&usp=sharing [^]