284 projects - 9237 developers
Openbravo ERP > Reports > Orders Awaiting Delivery report
Project Wiki
Views

Technical Documentation

From Wiki

Jump to: navigation, search

Contents

Orders Awaiting Delivery - Technical Documentation

Overview

This article will explain how to proceed in order to create an Orders Awaiting Delivery Report.

Technical design

Module folder structure

Orders Awaiting Delivery Report filter window

  • Create a new HTML file to display the report filters: /modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped.html
  • Create a new XML file to get/set the values of filter window: /modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped.xml
  • Create a new Java file to process the values of the filter window: /modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped.java
  • Create a new report within the Application Dictionary (Application Dictionary || Report and Process) with search key ReportOrderNotShipped and name Orders Awaiting Delivery Report. Define it as a Report and set its Process class: org.openbravo.reports.ordersawaitingdelivery
  • Create a new menu entry (General Setup || Application || Menu) called Orders Awaiting Delivery Report and make it point to ReportOrderNotShipped report.
  • Place this new entry inside Sales Management Management || Analysis Tools.

Orders Awaiting Delivery Report

  • Create a new XSQL file to get the order and shipment values from the database: /modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped_data.xsql
  • Modify the Java file in order to read the XSQL and send it to the JRXML template file: /modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped.java
  • Create a JRXML template file to display the report result: /modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped.jrxml