View source for Projects:Read Only Pool Manual Reports

== Introduction ==

This project aims to adapt read only connection provider for the compatible reports that provide their own datasource (not using a query in jrxml template).

* Tracking issue: https://issues.openbravo.com/view.php?id=36736

* To configure read only pool, please follow instruction at [http://wiki.openbravo.com/wiki/Openbravo.properties#Read-Only_Pool Read Only Pool Configuration]

{{AvailableFrom|3.0PR17Q4}}

{{(!) | Make sure that read only database in the read only pool configuration is updated as much as possible. User may face problem in getting updated information from read only pool adapted reports depending on synchronization mechanism.}}

===List of read only pool adapted reports===
{|border="1" cellpadding="2" cellspacing="0" 
! Sr No
! Report Name
! Class Name
|-
| 01  
| Price List Report
| ReportPricelist.java
|-
| 02  
| Purchase Dimensional Report
| ReportPurchaseDimensionalAnalysesJR.java
|-
| 03  
| Goods Receipt Dimensional Report
| ReportMaterialDimensionalAnalysesJR.java
|-
| 04  
| Purchase Invoice Dimensional Report
| ReportInvoiceVendorDimensionalAnalysesJR.java
|-
| 05  
| Vendor Invoice Report
| ReportInvoiceVendorJR.java
|-
| 06  
| Expiration Date Report
| ReportGuaranteeDateJR.java
|-
| 07  
| Offers Report
| ReportOffer.java
|-
| 08  
| Shipper Report
| ReportShipper.java
|-
| 09  
| Tracebility Report
| MInOutTraceReports.java
|-
| 10  
| Material Transaction Report
| ReportMaterialTransactionEditionJR.java
|-
| 11  
| Warehouse Control Report
| ReportWarehouseControl.java
|-
| 12  
| Stock Report
| ReportWarehousePartnerJR.java
|-
| 13
| Valued Stock Report
| ReportValuationStock.java
|-
| 14  
| Product Movement Report
| ReportProductMovement.java
|-
| 15  
| BOM Production Report
| ReportProductionJR.java
|-
| 16  
| Pareto Product Report
| ReportParetoProduct.java
|-
| 17  
| Sales Dimensional Report
| ReportSalesDimensionalAnalyzeJR.java
|-
| 18  
| Shipments Dimensional Report
| ReportShipmentDimensionalAnalyzeJR.java
|-
| 19  
| Discount Invoice Report
| ReportInvoiceDiscountJR.java
|-
| 20  
| Sales Order Report
| ReportSalesOrderJR.java
|-
| 21  
| Stock for Open Orders
| ReportPendingProductionJr.java
|-
| 22  
| Invoiced Sales Order Report
| ReportSalesOrderInvoicedJasper.java
|-
| 23  
| Orders Awaiting Invoice Report
| ReportOrderNotInvoiceJR.java
|-
| 24  
| Delivered Sales Order Report
| ReportSalesOrderProvidedJR.java
|-
| 25  
| Shipment Report
| ReportShipmentEditionJR.java
|-
| 26  
| Orders Awaiting Delivery Report
| ReportOrderNotShipped.java
|-
| 27  
| Invoice Detail
| ReportInvoicesJR.java
|-
| 28  
| Customer Invoice Report
| ReportInvoiceCustomerJR.java
|-
| 29  
| Sales Invoice Dimensional Report
| ReportInvoiceCustomerDimensionalAnalysesJR.java
|-
| 30  
| Cashflow Forecast Report
| CashflowForecastReportActionHandler.java
|-
| 31  
| Receivables Aging Schedule, Payables Aging Schedule
| ReportAgingBalance.java, AgingDao.java, AgingBalanceReportActionHandler.java
|-
| 32  
| Payment Report
| PaymentReport.java, PaymentReportDao.java
|-
| 33  
| Create Budget Reports in Excel
| ReportBudgetGenerateExcel.java
|-
| 34  
| Not Posted Transaction Report
| ReportNotPosted.java
|-
| 35  
| Balance Sheet and P&L Structure
| GeneralAccountingReports.java
|-
| 36  
| Trial Balance Report
| ReportTrialBalance.java
|-
| 37  
| General Ledger Report
| ReportGeneralLedger.java
|-
| 38  
| Asset report for depreciation schedule
| ReportAssetDepreciationSchedule.java
|-
| 39  
| Standard Costs Report
| ReportStandardCostJR.java
|-
| 40  
| Production Run Status Report
| ReportProductionRunJR.java
|-
| 41  
| Production Cost Report
| ReportProductionCost.java
|-
| 42  
| Pending Work Requirement
| ReportWorkRequirementJR.java
|-
| 43  
| Project Progress 
| ReportProjectProgress.java
|-
| 44  
| Project Profitability
| ReportProjectProfitabilityJR.java
|-
| 45  
| Expense Report
| ReportExpense.java
|-
| 46  
| Journal Entries Report (when not launched automatically after document post)
| ReportGeneralLedgerJournal.java, ReportGeneralLedgerJournalDetail.java
|}

===List of non-compatible reports===

{|border="1" cellpadding="2" cellspacing="0" 
! Sr No
! Report Name
! Class Name
! Reason
|-
| 01  
| Journal Entries Report (when launched automatically after document post)
| ReportGeneralLedgerJournal.java, ReportGeneralLedgerJournalDetail.java
| Immediately launched after record creation
|-
| 02  
| Valued Stock Report Legacy
| ReportValuationStock_legacy.java
| Legacy
|-
| 03  
| Invoice Tax Report
| ReportTaxInvoiceJR.java
| Inactive
|-
| 04 
| Export Budget to Excel
| ReportBudgetExportExcel.java
| Print button
|-
| 05  
| Sales Invoice Dimensional Report Legacy - 
| ReportInvoiceCustomerDimensionalAnalysesJR_legacy.java
| Legacy
|-
| 06  
| Reconciliation Summary, Reconciliation Details
| ReportReconciliation.java
| Immediately launched after record creation 
|-
| 07  
| Service Project Report
| ReportProjectBuildingSiteJR.java
| Inactive
|-
| 08
| Pareto Product Report Legacy
| ReportParetoProductLegacy.java
| Legacy
|-
| 09
| Tax Payment
| ReportTaxPaymentJR.java
| Print button
|-
| 10
| Tax Payment Header 
| ReportVatRegisterJR.java
| Print button
|-
| 11
| Process Plan
| RptMA_ProcessPlan.java
| Print button
|-
| 12
| Business Partner
| RptC_Bpartner.java
| Print button
|-
| 13
| Quality Control Report
| RptMA_CCP_Measures.java
| Print button
|-
| 14
| Quality Control Point
| RptMA_CCP_Group.java
| Print button
|-
| 15
| Sales Order Returns Dimensional Report
| ReportRefundSalesDimensionalAnalyses.java, ReportRefundSalesDimensionalAnalysesPDF.java
| Inactive
|-
| 16
| Total Product Template Report
| ReportTotalProductTemplate.java
| Inactive
|-
| 17
| Invoice Consignment Report
| ReportToInvoiceConsignmentJR.java
| Inactive
|-
| 18
| Cashflow Forecast
| ReportCashflowForecast
| Inactive, old flow
|-
| 19
| Daily Work Requirements Report
| RReportWorkRequirementDaily.java
| Inactive
|-
| 20
| Payment Report
| ReportDebtPayment.java
| Inactive
|-
| 21
| Payment Tracker
| ReportDebtPaymentTrack.java
| Inactive
|-
| 22
| Cash Flow Statement
| ReportCashFlow.java
| Inactive
|-
| 23
| Cash Report
| ReportCashJR.java
| Inactive
|-
| 24
| Bank Report
| ReportBankJR.java
| Inactive
|-
| 25
| Delivery Note / Shipment Print
| RptM_Inout.java
| Unused
|-
| 26
| Warehouse movement
| RptM_Movement.java
| Unused
|-
| 27
| Invoice Print
| RptC_Invoice.java
| Unused
|-
| 28
| Order Print
| RptC_Order.java
| Unused
|-
| 29
| OrderPO Print
| RptC_OrderPO.java
| Unused
|-
| 30
| Promissory Note.
| RptPromissoryNote.java
| Unused
|-
| 31
| Remittance printed
| RptC_Remittance.java
| Unused
|- 
| 32
| Proposal print Jr
| RptC_ProposalJr.java
| Unused
|-
| 33
| Settlement printed
| RptC_Settlement.java
| Unused
|-
| 34
| Sales Order Open Item
| ReportSalesOrderOpenItemJR.java
| Inactive
|-
| 35
| Withholding Report
| ReportAnnualCertification.java
| Inactive
|-
| 36
|
| ReportWorkRequirementDailyEnv.java
| Unused
|-
| 37
|
| ReportAcctRedirectUtility.java
| Unused
|- 
| 38
| Print Requisition
| RptM_Requisition.java
| Not Applicable (jrxml query based)
|}

== References ==

[[Category:Projects ERP]]