Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015019Openbravo ERP08. Project and service managementpublic2010-10-25 16:562010-12-09 16:07
Reporternetworkb 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP22 
Target Version2.50MP24Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015019: The application does not calculate correctly the field Planned Margin
DescriptionThe application does not calculate correctly the field Planned Margin

Reported by XME
Ticket: 9662
Steps To Reproduce- As Openbravo Admin go to Project & Service Management || Transactions || Service Project
- Create a new record (BP: McGiver)
- Create two lines:

- Line 1:
    - Product: hammer
    - Planned Quantity: 1
    - Planned Price: 45.00
    - Planned Margin: 100.00

- Line 2:
    - Product: hammer
    - Planned Quantity: 100
    - Planned Price: 3.00
    - Planned Purchase Price: 2.00
    - Planned Margin: 33.33

- Go back to the header.
- Realize that the Planned Margin is wrong
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng project.png (19,908) 2010-10-25 16:56
https://issues.openbravo.com/file_download.php?file_id=3282&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2010-10-25 16:56networkbNew Issue
2010-10-25 16:56networkbAssigned To => adrianromero
2010-10-25 16:56networkbFile Added: project.png
2010-10-25 16:56networkbOBNetwork customer => Yes
2010-11-12 06:07hgbotCheckin
2010-11-12 06:07hgbotNote Added: 0032570
2010-11-12 06:07hgbotStatusnew => resolved
2010-11-12 06:07hgbotResolutionopen => fixed
2010-11-12 06:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0a6b57198f36b58c37ad7e1809452b01c1fb4ba2 [^]
2010-11-12 06:15harikrishnanNote Added: 0032571
2010-11-13 12:09hudsonbotCheckin
2010-11-13 12:09hudsonbotNote Added: 0032602
2010-11-17 15:50sureshbabuNote Added: 0032675
2010-11-17 15:50sureshbabuStatusresolved => closed
2010-12-09 16:07anonymoussf_bug_id0 => 3133530

Notes
(0032570)
hgbot   
2010-11-12 06:07   
Repository: erp/devel/pi
Changeset: 0a6b57198f36b58c37ad7e1809452b01c1fb4ba2
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Fri Nov 12 10:36:42 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/0a6b57198f36b58c37ad7e1809452b01c1fb4ba2 [^]

Fixes Issue 15019: The application does not calculate correctly the field Planned Margin

---
M src-db/database/model/triggers/C_PROJECT_TRG2.xml
---
(0032571)
harikrishnan   
2010-11-12 06:15   
Steps to test:

Follow the steps to reproduce .

Now the new calculated amount will 95.83 (for the example given).

Formula: PSM = (PR - PC)*100/PR

Reference : http://wiki.openbravo.com/wiki/Functional_Documentation/Project_and_Service_Management#Project_and_Service_Management_reporting [^]

Impact : Impact will be in Service project window.But it was tested.
(0032602)
hudsonbot   
2010-11-13 12:09   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/0a6b57198f36 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/e4f5fe55014d [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18899.obx [^]
(0032675)
sureshbabu   
2010-11-17 15:50   
verified & now the "Planned margin" is calculated based on the formula PSM = (PR - PC)*100/PR