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

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #27286		[ All Revisions ] [ Back to Issue ]
Summary	0027286: A.% field of Sales Invoice Dimensional Report comparative doesn't always work

Revision	2014-08-07 11:44 by rafaroda
Steps To Reproduce	Consistently 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 [^]

Revision	2014-08-06 17:30 by rafaroda
Steps To Reproduce	Consistently 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) See screenshots at https://drive.google.com/folderview?id=0B649lz4ZYJcHMzlsWk80d3lDY2c&usp=sharing [^]