0036714: Aging schedule export to excel does not generate report when invoice number is alphanumeric

Description

Receivable and Payable aging schedule report when exported to excel shows a error when invoice included in the report has alphanumeric document number. Integer class is assigned to field INVOICE_NUMBER.

Steps To Reproduce

- Login as QA Testing client
- Make sure that sales invoice has a alphanumeric document number.
- Navigate to Receivables Aging Schedule.
- Mark show details = yes and click on Export to Excel.
- Realize that error is shown in logs and report is not generated.

- Login as QA Testing client.
- Make sure that sales invoice has a alphanumeric document number.
- Navigate to Receivables Aging Schedule.
- Click on view with selected parameters.
- Click on Customer A
- Click XLS
- Realize that error is shown in logs and report is not generated.

Similar error is generated when report includes invoices with doubtful debts.

Proposed Solution

Change class of INVOICE_NUMBER from Integer to String in both AgingScheduleDetailXLSDoubtfulDebt.jrxml and AgingScheduleDetailXLS.jrxml

Tags

No tags attached.

Attached Files

36714.diff [^] (1,558 bytes) 2017-08-24 21:14 [Show Content] [Hide Content]

diff -r 696d3ba21993 src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLS.jrxml
--- a/src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLS.jrxml	Thu Aug 24 23:46:28 2017 +0530
+++ b/src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLS.jrxml	Fri Aug 25 00:41:07 2017 +0530
@@ -61,7 +61,7 @@
        'hello' AS CURRENCY, 1234 AS BASE_AMOUNT, 'hello' AS BASE_CURRENCY, 'hello' AS PAYMENT_METHOD, 'hello' AS FINANCIAL_ACCOUNT
 FROM DUAL]]>
 	</queryString>
-	<field name="INVOICE_NUMBER" class="java.lang.Integer"/>
+	<field name="INVOICE_NUMBER" class="java.lang.String"/>
 	<field name="INVOICE_ID" class="java.lang.String"/>
 	<field name="AMOUNT0" class="java.math.BigDecimal"/>
 	<field name="AMOUNT1" class="java.math.BigDecimal"/>
diff -r 696d3ba21993 src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLSDoubtfulDebt.jrxml
--- a/src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLSDoubtfulDebt.jrxml	Thu Aug 24 23:46:28 2017 +0530
+++ b/src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLSDoubtfulDebt.jrxml	Fri Aug 25 00:41:07 2017 +0530
@@ -61,7 +61,7 @@
        'hello' AS CURRENCY, 1234 AS BASE_AMOUNT, 'hello' AS BASE_CURRENCY, 'hello' AS PAYMENT_METHOD, 'hello' AS FINANCIAL_ACCOUNT
 FROM DUAL]]>
 	</queryString>
-	<field name="INVOICE_NUMBER" class="java.lang.Integer"/>
+	<field name="INVOICE_NUMBER" class="java.lang.String"/>
 	<field name="INVOICE_ID" class="java.lang.String"/>
 	<field name="AMOUNT0" class="java.math.BigDecimal"/>
 	<field name="AMOUNT1" class="java.math.BigDecimal"/>

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2017-08-24 21:12	AtulOpenbravo	New Issue
2017-08-24 21:12	AtulOpenbravo	Assigned To	=> Triage Finance
2017-08-24 21:12	AtulOpenbravo	Modules	=> Core
2017-08-24 21:12	AtulOpenbravo	Triggers an Emergency Pack	=> No
2017-08-24 21:14	AtulOpenbravo	File Added: 36714.diff
2017-08-25 09:01	AtulOpenbravo	Summary	Aging schedule export to excel does not generated report when invoice number is aplhanumeric => Aging schedule export to excel does not generate report when invoice number is alphanumeric
2017-08-25 09:01	AtulOpenbravo	Description Updated	View Revisions
2017-09-14 13:32	aferraz	Assigned To	Triage Finance => AtulOpenbravo
2017-09-15 14:27	aferraz	Review Assigned To	=> aferraz
2017-09-15 14:27	aferraz	Status	new => closed
2017-09-15 14:27	aferraz	Resolution	open => unable to reproduce