Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000373Openbravo ERP08. Project and service managementpublic2008-05-19 18:232008-12-02 13:01
Reporterrafaroda 
Assigned Torafaroda 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target Version2.40Fixed in Version2.40alpha-r3 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0000373: Service and Expenses Margin fields auto-calculated
DescriptionIn Multiphase and Service Project windows inside Project & Service Management module, there are two fields named Service and Expenses Margin that should be expressed in % and automatically calculated in function of revenues and costs.
Steps To Reproduce1) Go to Project & Service Management || Transactions || Multiphase Project
2a) Fill Service Revenue (SR) and Service Cost (SC) fields: Service Margin (SM) should be automatically calculated as (SR - SC)*100/SR
2b) Fill Service Revenue (SR) and Service Margin (SM) fields: Service Cost (SC) should be automatically calculated as SR*(1-SM/100)
3a) Fill Planned Expenses (PE) and Reinvoiced Expenses (RE) fields: Expenses Margin (EM) should be automatically calculated as (RE - PE)*100/RE
3b) Fill Planned Expenses (PE) and Expenses Margin (EM) fields: Reinvoiced Expenses (RE) should be automatically calculated as PE/(1-EM/100)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-05-19 18:23rafarodaNew Issue
2008-05-19 18:23rafarodaAssigned To => rafaroda
2008-05-19 18:23rafarodaOBNetwork customer => N
2008-05-22 11:39rafarodaStatusnew => scheduled
2008-06-11 10:48svnbotCheckin
2008-06-11 10:48svnbotNote Added: 0000495
2008-06-11 10:48svnbotStatusscheduled => resolved
2008-06-11 10:48svnbotResolutionopen => fixed
2008-06-11 10:48svnbotsvn_revision => 4945
2008-06-11 14:33cromeroFixed in Version => 2.40alpha r3
2008-06-12 16:19svnbotCheckin
2008-06-12 16:19svnbotNote Added: 0007681
2008-06-12 16:19svnbotsvn_revision4945 => 5014
2008-11-06 09:11psarobeRegression testing => No
2008-11-06 09:11psarobeStatusresolved => closed
2008-12-02 13:01jaimetorresf_bug_id0 => 2377025

Notes
(0000495)
svnbot   
2008-06-11 10:48   
Repository: openbravo
Revision: 4945
Author: rafaroda
Date: 2008-06-11 10:48:30 +0200 (Wed, 11 Jun 2008)

Fixes bug 0000373 Added 'SL_Project_Margin' callout in order to:
* Calculate Service Margin (SM) field based on Service Revenue (SR) and Service Cost (SC) fields.
* Calculate Service Revenue (SR) field based on Service Margin (SM) and Service Cost (SC) fields.
* Calculate Expenses Margin (EM) field based on Planned Expenses (PE) and Reinvoiced Expenses (RE) fields.
* Calculate Reinvoiced Expenses (RE) field based on Expenses Margin (EM) and Planned Expenses (PE) fields.

---
A trunk/src/org/openbravo/erpCommon/ad_callouts/SL_Project_Margin.java
A trunk/src/org/openbravo/erpCommon/ad_callouts/SL_Project_Margin_data.xsql
U trunk/src-db/database/sourcedata/AD_CALLOUT.xml
U trunk/src-db/database/sourcedata/AD_COLUMN.xml
U trunk/src-db/database/sourcedata/AD_MODEL_OBJECT.xml
U trunk/src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=4945&sc=1 [^]
(0007681)
svnbot   
2008-06-12 16:19   
Repository: openbravo
Revision: 5014
Author: rafaroda
Date: 2008-06-12 16:19:50 +0200 (Thu, 12 Jun 2008)

Fixes bug 0000373 Modified 'SL_Project_Margin' callout in order it does not crash when dividing by zero.

---
U trunk/src/org/openbravo/erpCommon/ad_callouts/SL_Project_Margin.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=5014&sc=1 [^]