Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008998Openbravo ERP07. Sales managementpublic2009-05-12 08:502009-06-06 00:00
Reporternetworkb 
Assigned Togmauleon 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Version2.40MP3 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0008998: Invoice dimensional reports: field "percentage"
DescriptionInvoice 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 Reproduceselect 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
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0009034 closed gmauleon Invoice dimensional reports: field "percentage" 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-05-12 08:50networkbNew Issue
2009-05-12 08:50networkbAssigned To => rafaroda
2009-05-12 08:50networkbRegression testing => No
2009-05-14 17:57psarobeStatusnew => scheduled
2009-05-14 17:57psarobefix_in_branch => pi
2009-05-25 08:53rafarodaNote Added: 0016597
2009-06-01 17:13gmauleonAssigned Torafaroda => gmauleon
2009-06-01 17:14gmauleonfix_in_branchpi =>
2009-06-01 17:14gmauleonSteps to Reproduce Updated
2009-06-02 14:21hgbotCheckin
2009-06-02 14:21hgbotNote Added: 0016870
2009-06-02 14:21hgbotStatusscheduled => resolved
2009-06-02 14:21hgbotResolutionopen => fixed
2009-06-02 14:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c5903be3452542d852d6387eed79608ace042811 [^]
2009-06-05 07:52sureshbabuStatusresolved => closed
2009-06-05 07:52sureshbabuNote Added: 0016980
2009-06-05 07:52sureshbabuFixed in Version => pi
2009-06-06 00:00anonymoussf_bug_id0 => 2802034

Notes
(0016597)
rafaroda   
2009-05-25 08:53   
We are trying to find out why did this field disappeared. Sorry for the delay.
(0016870)
hgbot   
2009-06-02 14:21   
Repository: erp/devel/pi
Changeset: c5903be3452542d852d6387eed79608ace042811
Author: Gorka Mauleon <gorka.mauleon <at> openbravo.com>
Date: Tue Jun 02 14:20:50 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c5903be3452542d852d6387eed79608ace042811 [^]

Fixes issue 0008998: Invoice dimensional reports: field percentage

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml
---
(0016980)
sureshbabu   
2009-06-05 07:52   
Tested working fine