Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0020600Openbravo ERPA. Platformpublic2012-05-24 13:192019-09-20 10:37
egoitz 
Triage Finance 
highminorhave not tried
scheduledopen 
5
3.0MP10.2 
 
Core
No
0020600: Arabic characters set are not printed on the standar reports.
When using arabic language, the reports are arabic characters are not printed on the report.
-Create a salers order
-create a line with a prodcut
-change the name of the product. for exmple with:

سركون بولص. بورتريه للشخص العراقي ف

Print the report.
The name of the product is not printed.
-Change in all the jrxml files the fontName and pdfFontName to use "Dejavu Sans" instead of the fonts used actually (Helvetica or Bitstream Vera Sans)
No tags attached.
related to defect 0041790 closed markmm82 č slovenian character disappearing in Openbravo PDF Jasper Reports 
has duplicate defect 00237703.0MP25 closed shankarb The warning from Jasper are creating big logs of tomcat and the log is not readable 
related to design defect 0019325 acknowledged Triage Platform Base i'm using the application in arabic and all pdf and reports doesn't support arabic encoding 
related to defect 00253143.0PR14Q2 closed caristu Arabic characters set are not printed on some standard reports. 
related to feature request 0025729 closed Sandrahuguet Create jasper template for balance sheet report and profit & loss 
Issue History
2012-05-24 13:19egoitzNew Issue
2012-05-24 13:19egoitzAssigned To => alostale
2012-05-24 13:19egoitzModules => Core
2012-06-04 11:46alostaleAssigned Toalostale => mirurita
2012-06-07 10:31SandrahuguetAssigned Tomirurita => Sandrahuguet
2012-06-07 10:31SandrahuguetStatusnew => scheduled
2012-06-07 10:31Sandrahuguetfix_in_branch => pi
2012-06-12 08:56SandrahuguetNote Added: 0049741
2012-06-12 08:59SandrahuguetNote Added: 0049742
2012-06-12 09:00SandrahuguetNote Edited: 0049742bug_revision_view_page.php?bugnote_id=0049742#r3537
2012-06-12 09:10SandrahuguetNote Edited: 0049741bug_revision_view_page.php?bugnote_id=0049741#r3539
2012-06-12 10:29SandrahuguetNote Added: 0049745
2012-07-25 09:40jonalegriaesarteAssigned ToSandrahuguet => egoitz
2012-07-25 09:40jonalegriaesarteNote Added: 0050822
2012-07-25 09:40jonalegriaesarteTypedefect => design defect
2012-07-25 09:40jonalegriaesarteTarget Version3.0MP14 =>
2012-07-25 09:40jonalegriaesartefix_in_branchpi =>
2012-09-13 10:42jonalegriaesarteAssigned Toegoitz => dmiguelez
2013-02-16 09:14thirumalaikRelationship addedrelated to 0019325
2013-06-27 18:13SandrahuguetStatusscheduled => acknowledged
2013-06-27 18:14SandrahuguetStatusacknowledged => scheduled
2013-06-27 18:14Sandrahuguetfix_in_branch => pi
2013-06-27 18:17AugustoMauchRelationship addedhas duplicate 0023770
2013-12-12 11:17caristuRelationship addedrelated to 0025314
2014-02-13 18:26SandrahuguetRelationship addedrelated to 0025729
2014-03-13 10:40SandrahuguetAssigned Todmiguelez => Sandrahuguet
2014-03-21 08:59psanjuanNote Added: 0065334
2014-03-21 09:09psanjuanNote Edited: 0065334bug_revision_view_page.php?bugnote_id=0065334#r5599
2014-03-21 11:08SandrahuguetNote Added: 0065352
2017-05-29 13:45SandrahuguetAssigned ToSandrahuguet => Triage Finance
2019-09-20 10:37SandrahuguetRelationship addedrelated to 0041790

Notes
(0049741)
Sandrahuguet   
2012-06-12 08:56   
(edited on: 2012-06-12 09:10)
We have deleted in all jrxml files the fontName and pdfFontName. Besides, the default styles(isDefault="true") have been changed to isDefault="false".
We have created a new propertie in openbravo.properties for font name in the iReports. The font name by default is DejaVu Sans.
 *jasperreports.default.font=DejaVu Sans
If you do not write this property or write the font name incorrectly in openbravo.properties the jrxml used the default font name in iReport (San Serif)

(0049742)
Sandrahuguet   
2012-06-12 08:59   
(edited on: 2012-06-12 09:00)
The following iReports have been modified in core:

 modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_reports/ReportReconciliation.jrxml
  modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportExcel.jrxml
  modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportPDF.jrxml
  modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped.jrxml
  src/org/openbravo/erpCommon/ad_reports/productionReport.jrxml
  src/org/openbravo/erpCommon/ad_reports/productionSubReport.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportAgingBalance.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportAnnualCertification.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportAssetDepreciationSchedule.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportBankJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_perDay.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_sub.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportCashJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_BankAcc.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_NoBP_BankAcc.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_NoBP.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportDebtPaymentTracker.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportExpense.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerExcel.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalExcel.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportGuaranteeDateJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportInvoicesEditJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportMaterialTransactionEditionJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportPendingProductionJr.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportProductionRun.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSiteJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportProjectProgress.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportPurchaseOrder.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoicedJasper.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportSalesPartnerProduct.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportShipmentEdition.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportStandardCostsJR_srptcosts.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportStandardCostsJR_subreport0.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportStandardCostsJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoice.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoicePurchase.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoicePurchaseForeign.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSale.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSaleForeign.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignmentJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceExcel.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportTrialBalancePDF.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartnerJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementDailyEdit.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalComparative.jrxml
  src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalNoComparative.jrxml
  src/org/openbravo/erpCommon/ad_reports/SubreportWorkRequirementDaily.jrxml
  src/org/openbravo/erpCommon/ad_reports/WeightDimensionalComparative.jrxml
  src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml
  src/org/openbravo/erpReports/C_OrderJR.jrxml
  src/org/openbravo/erpReports/C_OrderLinesJR.jrxml
  src/org/openbravo/erpReports/C_RMOrderJR.jrxml
  src/org/openbravo/erpReports/C_RMOrderLinesJR.jrxml
  src/org/openbravo/erpReports/ReportRegisterByVatJR.jrxml
  src/org/openbravo/erpReports/ReportRegisterLineJR.jrxml
  src/org/openbravo/erpReports/RptC_Invoice_Lines.jrxml
  src/org/openbravo/erpReports/RptC_Invoice_TaxLines.jrxml
  src/org/openbravo/erpReports/RptC_Invoice.jrxml
  src/org/openbravo/erpReports/RptC_OrderPO_Lines.jrxml
  src/org/openbravo/erpReports/RptC_OrderPO.jrxml
  src/org/openbravo/erpReports/RptC_ProposalJr.jrxml
  src/org/openbravo/erpReports/RptC_Remittance_Lines.jrxml
  src/org/openbravo/erpReports/RptC_Remittance.jrxml
  src/org/openbravo/erpReports/RptFIN_PaymentLines.jrxml
  src/org/openbravo/erpReports/Rptm_InOut_Lines.jrxml
  src/org/openbravo/erpReports/RptM_InOut.jrxml
  src/org/openbravo/erpReports/RptM_Requisition_Lines.jrxml
  src/org/openbravo/erpReports/RptM_Requisition.jrxml
  src/org/openbravo/erpReports/RptM_RMInOut_Lines.jrxml
  src/org/openbravo/erpReports/RptM_RMInOut.jrxml
  src/org/openbravo/erpReports/RptMA_ProcessPlan.jrxml
  src/org/openbravo/erpReports/SubreportLines.jrxml

(0049745)
Sandrahuguet   
2012-06-12 10:29   
Test Plan:
- Go to Business Partner select one, and change the Commercial Name to: سركون بولص. بور
تريه للشخص العراقي ف
- Go to sales order create a order to the business partner سركون بولص. بورتريه للشخص العراقي ف, and Book.

- Go to sales order report and Print the report, notice that the business partner is printed.
(0050822)
jonalegriaesarte   
2012-07-25 09:40   
Clasified as design defect because all the reports need to be changed
(0065334)
psanjuan   
2014-03-21 08:59   
(edited on: 2014-03-21 09:09)
The solution provide to this issue (Chinese, Japanese, Arabic..etc character not printed properly on OB PDF format reports) is:

We have deleted in all jrxml files the fontName and pdfFontName. Besides, the default styles(isDefault="true") have been changed to isDefault="false".

We have created a new property in OB properties that is *jasperreports.default.font, which is set to DejaVu Sans font by default, unless the end-user wants to change it to another font.

If you do not want to use DejaVu Sans font but another one, it is necessary to create a .jar as described in this How to document: http://wiki.openbravo.com/wiki/How_to_Change_Fonts_in_Openbravo_Reports#Changing_the_font_in_Jasper_Reports. [^]
Once done, remember to fill in the font to be used in the *jasperreports.default.font OB property.

Have in mind that if you do not fill in this property or write the font name incorrectly or if you fill in a font which does not have the corresponding .jar created, the OB reports will the be printed by using the defaulted font name in iReport that is San Serif.

This solution is going to be provided in the next release that is PR14 Q3.

(0065352)
Sandrahuguet   
2014-03-21 11:08   
List of modified reports:

M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_reports/ReportReconciliation.jrxml
M modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportExcel.jrxml
M modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportPDF.jrxml
M modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped.jrxml
M src/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReportsPDF.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportAgingBalance.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportAnnualCertification.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportAssetDepreciationSchedule.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportBankJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportCashJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_perDay.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_sub.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPaymentTracker.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_BankAcc.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_NoBP.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_NoBP_BankAcc.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportExpense.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerExcel.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalExcel.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGuaranteeDateJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR_legacy.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR_legacy.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoicesEditJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportMaterialTransactionEditionJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportPendingProductionJr.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportProductionRun.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSiteJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportProjectProgress.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportPurchaseOrder.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoicedJasper.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportSalesPartnerProduct.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportShipmentEdition.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportStandardCostsJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportStandardCostsJR_srptcosts.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportStandardCostsJR_subreport0.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoice.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoicePurchase.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoicePurchaseForeign.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSale.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSaleForeign.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignmentJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceExcel.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalancePDF.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartnerJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementDailyEdit.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalComparative.jrxml
M src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalNoComparative.jrxml
M src/org/openbravo/erpCommon/ad_reports/SubreportWorkRequirementDaily.jrxml
M src/org/openbravo/erpCommon/ad_reports/WeightDimensionalComparative.jrxml
M src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml
M src/org/openbravo/erpCommon/ad_reports/productionReport.jrxml
M src/org/openbravo/erpReports/C_OrderJR.jrxml
M src/org/openbravo/erpReports/C_OrderJR_new.jrxml
M src/org/openbravo/erpReports/C_OrderLinesJR.jrxml
M src/org/openbravo/erpReports/C_OrderLinesJR_new.jrxml
M src/org/openbravo/erpReports/C_OrderLinesTaxIncludedJR.jrxml
M src/org/openbravo/erpReports/C_OrderLinesTaxIncludedJR_new.jrxml
M src/org/openbravo/erpReports/C_QuotationJR.jrxml
M src/org/openbravo/erpReports/C_RMOrderJR.jrxml
M src/org/openbravo/erpReports/C_RMOrderLinesJR.jrxml
M src/org/openbravo/erpReports/ReportRegisterByVatJR.jrxml
M src/org/openbravo/erpReports/ReportRegisterLineJR.jrxml
M src/org/openbravo/erpReports/RptC_Invoice.jrxml
M src/org/openbravo/erpReports/RptC_Invoice_Lines.jrxml
M src/org/openbravo/erpReports/RptC_Invoice_Lines_new.jrxml
M src/org/openbravo/erpReports/RptC_Invoice_TaxLines.jrxml
M src/org/openbravo/erpReports/RptC_Invoice_TaxLines_new.jrxml
M src/org/openbravo/erpReports/RptC_Invoice_new.jrxml
M src/org/openbravo/erpReports/RptC_OrderPO.jrxml
M src/org/openbravo/erpReports/RptC_OrderPO_Lines.jrxml
M src/org/openbravo/erpReports/RptC_Order_TaxLines.jrxml
M src/org/openbravo/erpReports/RptC_Order_TaxLines_new.jrxml
M src/org/openbravo/erpReports/RptC_ProposalJr.jrxml
M src/org/openbravo/erpReports/RptC_Remittance.jrxml
M src/org/openbravo/erpReports/RptC_Remittance_Lines.jrxml
M src/org/openbravo/erpReports/RptFIN_PaymentLines.jrxml
M src/org/openbravo/erpReports/RptMA_ProcessPlan.jrxml
M src/org/openbravo/erpReports/RptM_InOut.jrxml
M src/org/openbravo/erpReports/RptM_InOut_new.jrxml
M src/org/openbravo/erpReports/RptM_RMInOut.jrxml
M src/org/openbravo/erpReports/RptM_RMInOut_Lines.jrxml
M src/org/openbravo/erpReports/RptM_Requisition.jrxml
M src/org/openbravo/erpReports/RptM_Requisition_Lines.jrxml
M src/org/openbravo/erpReports/Rptm_InOut_Lines.jrxml
M src/org/openbravo/erpReports/Rptm_InOut_Lines_new.jrxml
M src/org/openbravo/erpReports/SubreportLines.jrxml