Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010067Openbravo ERP08. Project and service managementpublic2009-07-27 12:172009-11-20 13:40
Reporterarunkumar 
Assigned Torafaroda 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
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
Summary0010067: Grant total amount changes before and after the completion of the sales order document.
DescriptionGrant total amount changes before and after the completion of the sales order document.
Steps To ReproduceLogin as userA
Go to Project & Service Management->Transactions->Multiphase Project
Click New and fill:
Search Key: cca
Name: Consultancy for Customer A
Click on Set Project Type button and select Technical consultancy. Click OK
Issues to verify:
Verify that phases and task created have the same values that in the project type selected.
Go to Project Phase tab.
Edit Project preparation and fill:
Quantity: 14
Unit Price: 1.8
Go to Project Task tab.
Edit First draft and fill:
Unit Price: 1.7
Go to back Project Phase tab.
Edit Project delivery and fill:
Starting date: 06-01-2008
Ending date: 25-12-2008
Go to Project Task.
Edit Project closing and fill:
Quantity: 20
Click New and fill:
Name: Project presentation
Go back to Multiphase Project tab.
Edit Consultancy for Customer A and fill:
Business Partner: CUSTOMER A
Verify that:
Partner Address: "Pamplona, Street Customer center nº1"
The combo box User/Contact must have the value: Alfred
Price list: CUSTOMER A
Form of payment: Money Order
Payment terms: 30 days, 5
Edit:
Sales representative: Sales A
Click on Change Project Status button.
Verify that:
Project Status is Order.
Price List is CUSTOMER A.
Go to Project Phase tab.
Move to Project preparation and click on Create Sales Order from Project Phase button. Click OK
Issues to verify:
Create Sales Order from project Phase button disappears
Sales Order field is completed.
Navigate to the sales order through the link.
Verify that:
Description: Project preparation
Business Partner: CUSTOMER A
Price List: CUSTOMER A
Invoice Terms: Customer schedule after delivery
Sales Representative: Sales A
Form of Payment: Money Order
Payment Terms: 30 days, 5
Project: cca - Consultancy for Customer A
Summed Line Amount: 67.7
Grand Total Amount: 72.83
Go to Lines tab.
Select A Final goods line and check that:
Description: Project preparation
Ordered Quantity: 14
UOM: Unit
Unit Price: 1.8
List Price: 2
Discount: 10
Tax: VAT(3) + Charge(0,5)
Line Net Amount: 25.2
Select Service A line and check that:
Description: First draft
Ordered Quantity: 25
UOM: Day
Unit Price: 1.7
List Price: 2
Discount: 15
Tax: VAT 10%
Line Net Amount: 42.5
Go back to Header tab.
Click on Complete button.

After completing the sales order grant total amount has been changed to 72.84
Proposed SolutionGrant total amount should remain same before and after completing the amount.
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0010422 closed rafaroda Tax amount is calculated with less decimals than it should. 
related to defect 0010262 closed balamurugan 'TAD_PI.C_ORDERLINE_TRG' is invalid and failed re-validation 
related to defect 00120962.50MP12 closed rafaroda When saving an order line the total amount is modified with a wrong value 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-27 12:17arunkumarNew Issue
2009-07-27 12:17arunkumarAssigned To => rafaroda
2009-07-27 12:17arunkumarOBNetwork customer => No
2009-07-29 12:59psarobeStatusnew => scheduled
2009-07-29 12:59psarobefix_in_branch => pi
2009-08-12 12:41balamuruganNote Added: 0018924
2009-08-13 06:34hgbotCheckin
2009-08-13 06:34hgbotNote Added: 0018929
2009-08-13 06:34hgbotStatusscheduled => resolved
2009-08-13 06:34hgbotResolutionopen => fixed
2009-08-13 06:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/141a7e86f4f72934611e8b7acef6ff3471b5e48a [^]
2009-08-13 10:48gnuyogaRelationship addedrelated to 0010262
2009-08-13 12:44rafarodaAssigned Torafaroda => balamurugan
2009-08-18 09:07sureshbabuStatusresolved => closed
2009-08-18 09:07sureshbabuNote Added: 0018987
2009-08-18 09:07sureshbabuFixed in Version => pi
2009-08-19 00:00anonymoussf_bug_id0 => 2839891
2009-08-31 08:27rafarodaRelationship addedrelated to 0010422
2009-09-18 14:44rafarodaRelationship replacedhas duplicate 0010422
2009-11-19 18:27plujanAssigned Tobalamurugan => rafaroda
2009-11-19 18:27plujanNote Added: 0022034
2009-11-19 18:27plujanStatusclosed => new
2009-11-19 18:27plujanResolutionfixed => open
2009-11-19 18:27plujanFixed in Versionpi =>
2009-11-19 18:28plujanStatusnew => scheduled
2009-11-20 13:40plujanNote Added: 0022062
2009-11-20 13:40plujanStatusscheduled => closed
2009-11-20 13:40plujanResolutionopen => no change required
2010-02-08 12:42rafarodaRelationship addedrelated to 0012096

Notes
(0018924)
balamurugan   
2009-08-12 12:41   
While creating a new Sales Order,
Whenever we add new line item with 3%VAT and 0.5%(Surcharge), the tax would be calculated cumulatively and rounded off.
For example,
if the taxable amount is 25.20 then the tax is computed as follows
    25.20*3.5/100=0.882 and rounded off to 0.88.
So the tax is 0.88 for 25.20.

But whenever we complete the order, the tax is computed and rounded off separately for VAT and surcharge.

For example,
  
    For 3% of VAT it is calculated as 25.20*3/100=0.756 rounded off to 0.76 and
    For 0.5% of surcharge it is calculated as 25.20*0.5/100=0.126 which is rounded off to 0.13,
    so, finally tax is calculated by adding those 0.76+0.13=0.89.

This makes the difference in GrandTotal Amount
(0018929)
hgbot   
2009-08-13 06:34   
Repository: erp/devel/pi
Changeset: 141a7e86f4f72934611e8b7acef6ff3471b5e48a
Author: Balamurugan Ramadoss <balamurugan.ramadoss <at> openbravo.com>
Date: Thu Aug 13 10:02:09 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/141a7e86f4f72934611e8b7acef6ff3471b5e48a [^]

Fixed Issue 0010067: Grant total amount changes before and after the completion of the sales order document.

---
M src-db/database/model/triggers/C_ORDERLINE_TRG.xml
---
(0018987)
sureshbabu   
2009-08-18 09:07   
Tested working fine.
(0022034)
plujan   
2009-11-19 18:27   
Issue can still be reproduced in our daily smokes. Sometimes can be a little tricky to make this issue to show up. The best procedure is to run an automated test and check the created value for the G_02 test case.
(0022062)
plujan   
2009-11-20 13:40   
Smoke test behaviour will be changed to reflect this fix