291 projects - 9572 developers
Openbravo ERP > Reports > Shipments Awaiting Invoice report
Project Wiki
Views

Technical Documentation

From Wiki

Jump to: navigation, search

Contents

Shipments Awaiting Invoice - Technical Documentation

Overview

This article will explain how to proceed in order to create a Shipments Awaiting Invoice Report.

Technical design

Module Development

  • Create a new module Shipments Awaiting Invoice Report with
  • Name: Shipments Awaiting Invoice Report
  • Java package: org.openbravo.reports.shipmentsawaitinginvoice

Development in Application Dictionary

  • Create a new report within the Application Dictionary (Application Dictionary || Report and Process) with search key ReportShipmentNotInvoiced and name Shipments Awaiting Invoice Report. Define it as a Report and set its Process class: org.openbravo.reports.shipmentsawaitinginvoice
  • Create a new menu entry (General Setup || Application || Menu) called Shipments Awaiting Invoice Report and make it point to ReportShipmentNotInvoiced report.
  • Place this new entry inside Sales Management Management || Analysis Tools between Shipment Report and Invoice Detail reports.

UI development (View)

  • Create a new XML file to get/set the values of filter window: /modules/org.openbravo.reports.shipmentsawaitinginvoice/src/org/openbravo/reports/shipmentsawaitinginvoice/erpCommon/ad_reports/ReportShipmentNotInvoiced.xml
  • Create a new HTML file to display the report filters: /modules/org.openbravo.reports.shipmentsawaitinginvoice/src/org/openbravo/reports/shipmentsawaitinginvoice/erpCommon/ad_reports/ReportShipmentNotInvoiced.html
  • Create a JRXML template file to display the report result: /modules/org.openbravo.reports.shipmentsawaitinginvoice/src/org/openbravo/reports/shipmentsawaitinginvoice/erpCommon/ad_reports/ReportShipmentNotInvoiced.jrxml

Xsql development (Model)

  • Create a new XSQL file to get the order and shipment values from the database: /modules/org.openbravo.reports.shipmentsawaitinginvoice/src/org/openbravo/reports/shipmentsawaitinginvoice/erpCommon/ad_reports/ReportShipmentNotInvoiced_data.xsql

Servlet development (Controller)

  • Create a new Java file to process the values of the filter window: /modules/org.openbravo.reports.shipmentsawaitinginvoice/src/org/openbravo/reports/shipmentsawaitinginvoice/erpCommon/ad_reports/ReportShipmentNotInvoiced.java
  • Modify the Java file in order to read the XSQL and send it to the JRXML template file: /modules/org.openbravo.reports.shipmentsawaitinginvoice/src/org/openbravo/reports/shipmentsawaitinginvoice/erpCommon/ad_reports/ReportShipmentNotInvoiced.java