Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0009034Openbravo ERP07. Sales managementpublic2009-05-12 08:502009-06-03 12:00
networkb 
gmauleon 
immediateminoralways
closedfixed 
20rPath Linux
2.40MP3 
2.40MP5 
Core
No
0009034: Invoice dimensional reports: field "percentage"
Invoice dimensional report, in versions with old interface (before to 2.3x), had a field "percentage" next to first dimension, with percentage of qty invoiced of this element respect to total, in period selected.

This field is not in current interface
select the first dimension business partner
next to each business partner, there is a percentage of qty invoiced to this business partner, respect to total in selected period
- The Jasper jrxml file should be updated to add this field.
- As seen in the 2.20 version (see attched file) the percentage field appears only in the 1st level.
- me mean objective of this field is to know which percentage of the total amount represents the amount at level one.
- So, a new variable should be added just beside the description of the 1 st level with this formula

  level_one_amount / Total_amount * 100

- There are two JRXML files involved in this
   1.- ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml
   2.- ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml

- And the variable related with the formula
   1.- $V{AMOUNT_SUM1}: Total amount at the first level
   2.- $V{AMOUNT_TOTAL}: Total amount of the report

- Possible impediments. The set up of the evaluation time would create incorrect data
No tags attached.
blocks defect 0008998 closed gmauleon Invoice dimensional reports: field "percentage" 
png Report.png (81,953) 2009-06-01 11:09
https://issues.openbravo.com/file_download.php?file_id=1362&type=bug
png
Issue History
2009-05-14 17:57psarobeTypedefect => backport
2009-05-14 17:57psarobefix_in_branch => 2.40
2009-06-01 11:09gmauleonFile Added: informe.png
2009-06-01 11:09gmauleonFile Deleted: informe.png
2009-06-01 11:09gmauleonFile Added: Report.png
2009-06-01 17:12gmauleonSteps to Reproduce Updated
2009-06-01 17:12gmauleonSteps to Reproduce Updated
2009-06-01 17:13gmauleonAssigned Torafaroda => gmauleon
2009-06-02 14:10hgbotCheckin
2009-06-02 14:10hgbotNote Added: 0016868
2009-06-02 14:10hgbotStatusscheduled => resolved
2009-06-02 14:10hgbotResolutionopen => fixed
2009-06-02 14:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/8b046cb9047bcf60332e4e942d19ad25e8e7752d [^]
2009-06-03 12:00sureshbabuStatusresolved => closed
2009-06-03 12:00sureshbabuNote Added: 0016912
2009-06-03 12:00sureshbabuFixed in Version => 2.40MP5

Notes
(0016868)
hgbot   
2009-06-02 14:10   
Repository: erp/stable/2.40
Changeset: 8b046cb9047bcf60332e4e942d19ad25e8e7752d
Author: Gorka Mauleon <gorka.mauleon <at> openbravo.com>
Date: Tue Jun 02 14:09:13 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/8b046cb9047bcf60332e4e942d19ad25e8e7752d [^]

fixes issue 9034 Invoice dimensional reports: field percentage

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml
---
(0016912)
sureshbabu   
2009-06-03 12:00   
Tested, the field percentage appears in the report if we select BP as Dimension.