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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0027286
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2014-08-06 17:292014-10-01 09:32
ReporterrafarodaView Statuspublic 
Assigned ToAtulOpenbravo 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision23958a53eacd
ProjectionnoneETAnoneTarget Version3.0PR15Q1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Torafaroda
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0027286: 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 [^]
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0070577)
AtulOpenbravo (developer)
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 (developer)
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 (developer)
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 [^]

- Issue History
Date Modified Username Field Change
2014-08-06 17:29 rafaroda New Issue
2014-08-06 17:29 rafaroda Assigned To => dmiguelez
2014-08-06 17:29 rafaroda Modules => Core
2014-08-06 17:29 rafaroda Triggers an Emergency Pack => No
2014-08-06 17:30 rafaroda Issue Monitored: rafaroda
2014-08-07 11:44 rafaroda Steps to Reproduce Updated View Revisions
2014-08-08 08:52 jonalegriaesarte Resolution time => 1414101600
2014-08-08 08:52 jonalegriaesarte Target Version => 3.0PR14Q4
2014-08-08 09:06 jonalegriaesarte Resolution time 1414101600 => 1410645600
2014-08-08 09:06 jonalegriaesarte Severity minor => major
2014-09-29 16:12 jonalegriaesarte Target Version 3.0PR14Q4 => 3.0PR15Q1
2014-09-30 09:16 AtulOpenbravo Status new => scheduled
2014-09-30 09:16 AtulOpenbravo Assigned To dmiguelez => AtulOpenbravo
2014-09-30 09:16 AtulOpenbravo fix_in_branch => pi
2014-09-30 19:22 AtulOpenbravo Note Added: 0070577
2014-10-01 09:18 AtulOpenbravo Review Assigned To => rafaroda
2014-10-01 09:18 AtulOpenbravo fix_in_branch pi =>
2014-10-01 09:19 hgbot Checkin
2014-10-01 09:19 hgbot Note Added: 0070599
2014-10-01 09:19 hgbot Status scheduled => resolved
2014-10-01 09:19 hgbot Resolution open => fixed
2014-10-01 09:19 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/23958a53eacd7e40a5ca56fa79b672f79c95af3b [^]
2014-10-01 09:32 rafaroda Note Added: 0070601
2014-10-01 09:32 rafaroda Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker