Shipments Awaiting Invoice/Technical Documentation

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