File:Reports.zip
No file by this name exists.
A Jasper Report for C_ORDER table - Shiju01
Download the C_ORDER Jasper files from here File:Reports.zip
How to install
1) Create a folder REPORTS under ADEMPIERE_HOME.
2) Extract the REPORTS.ZIP file.
3) Copy the files just extracted namely reg_C_ORDER.jrxml & reg_C_ORDER.jasper to \ADEMPIERE\REPORTS folder
4) Login as SuperUser to System role
5) Select window REFERENCE and create a new LIST for report grouping/order by
Name : Order_By Description : Report Sort Order Validation Type : List Validation
and click SAVE record
Now select tab List Validations and enter following line
Search Key Name AD_Org_ID Org. C_BPartner_ID Business Partner C_PaymentTerm_ID Payment Terms DateAcct Month DateInvoiced Date Invoiced DateOrdered Date Ordered DocStatus Status DocumentNo Document No SalesRep_ID SalesRep
6) Select window REPORT & PROCESS from menu and create a new process with following details
Search Key : REG_C_ORDER_SUM
Name : Order Register (summary) ClassName : org.compiere.report.ReportStarter JasperRpt : reg_C_ORDER.jasper
and SAVE record
7) Select PARAMETER TAB and add new lines to define following parameters in the given order
# Name DB Column Name Element Reference ReferenceKey Range Default Logic DisplayLogic ReadOnlyLogic 10 Company ID AD_Client_ID AD_Client_ID Table AD_Client No @#AD_Client_ID@ 1=1 20 Company Name AD_Client_Name String No @#AD_Client_Name@ 1=2 1=1 30 Org Id AD_Org_ID AD_Org_ID Table AD_Org(Trx) No -1 40 Org Name AD_Org_Name OrgName Table AD_Org_Name No -1 1=2 1=1 50 Date Range DateOrdered DateOrdered Date Yes @#Date@ 60 BPartner C_BPartner_ID C_BPartner_ID Search C_BPartner(ALL) No 70 Salesman SalesRep_ID SalesRep_ID Table No -1 80 Terms C_PaymentTermID C_PaymentTermID Table No -1 90 Status DocStatus DocStatus List _DocumentStatus No 100 Type C_DocType_ID C_DocType_ID Table No 1000030 110 Order Order_By List Order_By No DocumentNo 120 NOT Delivered IsDelivered IsDelivered Yes-No No N 130 NOT Invoiced IsInvoiced IsInvoiced Yes-No No N 140 Summary Report IsSummary Yes-No No N
8) Select window MENU and create a new menu with following details
Name : Order Register Summary Type : Report Process : REG_C_ORDER_SUM
Done-Enjoy-Your Order Register is ready
File usage
The following 2 pages link to this file: