Projects:Read Only Pool Manual Reports

From InfiniteERP Wiki
Jump to: navigation, search

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).

Bulbgraph.png   This feature is available starting from 3.0PR17Q4.
Bulbgraph.png   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

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

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