Difference between revisions of "File:Reports.zip"
Line 13: | Line 13: | ||
4) Login as SuperUser to System role | 4) Login as SuperUser to System role | ||
− | 5) Select window REPORT & PROCESS from menu and create a new process with following details | + | 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 | Search Key : REG_C_ORDER_SUM | ||
Line 23: | Line 44: | ||
and SAVE record | 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 | # Name DB Column Name Element Reference ReferenceKey Range Default Logic DisplayLogic ReadOnlyLogic | ||
Line 40: | Line 61: | ||
130 NOT Invoiced IsInvoiced IsInvoiced Yes-No No N | 130 NOT Invoiced IsInvoiced IsInvoiced Yes-No No N | ||
140 Summary Report IsSummary Yes-No No N | 140 Summary Report IsSummary Yes-No No N | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
8) Select window MENU and create a new menu with following details | 8) Select window MENU and create a new menu with following details |
Latest revision as of 08:14, 17 August 2009
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: