0009034: Invoice dimensional reports: field "percentage"

Description

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

Steps To Reproduce

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

Proposed Solution

- 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

Tags

No tags attached.

Attached Files

Report.png [^] (81,953 bytes) 2009-06-01 11:09

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0008998

closed

gmauleon

Invoice dimensional reports: field "percentage"

Notes
(0016868) hgbot (developer) 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 (viewer) 2009-06-03 12:00	Tested, the field percentage appears in the report if we select BP as Dimension.

Issue History
Date Modified	Username	Field	Change
2009-05-14 17:57	psarobe	Type	defect => backport
2009-05-14 17:57	psarobe	fix_in_branch	=> 2.40
2009-06-01 11:09	gmauleon	File Added: informe.png
2009-06-01 11:09	gmauleon	File Deleted: informe.png
2009-06-01 11:09	gmauleon	File Added: Report.png
2009-06-01 17:12	gmauleon	Steps to Reproduce Updated
2009-06-01 17:12	gmauleon	Steps to Reproduce Updated
2009-06-01 17:13	gmauleon	Assigned To	rafaroda => gmauleon
2009-06-02 14:10	hgbot	Checkin
2009-06-02 14:10	hgbot	Note Added: 0016868
2009-06-02 14:10	hgbot	Status	scheduled => resolved
2009-06-02 14:10	hgbot	Resolution	open => fixed
2009-06-02 14:10	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.40/rev/8b046cb9047bcf60332e4e942d19ad25e8e7752d [^]
2009-06-03 12:00	sureshbabu	Status	resolved => closed
2009-06-03 12:00	sureshbabu	Note Added: 0016912
2009-06-03 12:00	sureshbabu	Fixed in Version	=> 2.40MP5