File:Reports.zip

From ADempiere ERP Wiki

Jump to: navigation, search

Reports.zip (file size: 22 KB, MIME type: application/zip)

Warning: This file may contain malicious code, by executing it your system may be compromised.

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 history

Click on a date/time to view the file as it appeared at that time.

(Latest | Earliest) View (newer 50) (older 50) (20 | 50 | 100 | 250 | 500)
Date/TimeThumbnailDimensionsUserComment
current13:09, 17 August 2009No thumbnail (22 KB)Shiju01 (Talk | contribs) (A Jasper Report for C_ORDER table - Shiju01)
(Latest | Earliest) View (newer 50) (older 50) (20 | 50 | 100 | 250 | 500)

The following 2 pages link to this file:

Personal tools