View source | View content page | Page history | Printable version   

Projects:Project Scheduling Capabilities Enhancement/Technical Documentation

Contents

Project Scheduling Capabilities Enhancement - Technical Documentation

Overview

This article will explain how to proceed in order to enhance the project scheduling capabilities within Openbravo ERP.


Current status

At present, Openbravo ERP has some scheduling capabilities that need to be improved.


Technical design

Service and Multiphase Project windows

In order to add Starting Date field to Service and Multiphase Project windows:


Project Profitability and Service Project reports

In order to modify Project Profitability and Service Project Report reports to include From Project Starting Date and To Project Starting Date fields:

Project Profitability report

Service Project Report

<Parameter name="dateFrom" optional="true" after="AND 1=1"><![CDATA[ AND C_PROJECT.CREATED >= to_date(?)]]></Parameter>
<Parameter name="dateTo" optional="true" after="AND 1=1"><![CDATA[ AND C_PROJECT.CREATED < to_date(?)]]></Parameter>

by

<Parameter name="dateFrom" optional="true" after="AND 1=1"><![CDATA[ AND C_PROJECT.STARTDATE >= to_date(?)]]></Parameter>
<Parameter name="dateTo" optional="true" after="AND 1=1"><![CDATA[ AND C_PROJECT.STARTDATE < to_date(?)]]></Parameter>


Project Phase and Task tabs

In order to add Contract Date field to Project Phase and Project Task tabs inside Multiphase Project window:


Standard Phase and Task tab

In order to add Standard Duration in Days field to Standard Phase and Standard Task tabs inside Project Type window:


Set Project Type process

In order to modify Set Project Type process and add Starting Date field review:

Retrieved from "http://wiki.openbravo.com/wiki/Projects:Project_Scheduling_Capabilities_Enhancement/Technical_Documentation"

This page has been accessed 5,608 times. This page was last modified on 8 June 2012, at 05:30. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.