Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010067 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 08. Project and service management | major | always | 2009-07-27 12:17 | 2009-11-20 13:40 | |||
| Reporter | arunkumar | View Status | public | |||||
| Assigned To | rafaroda | |||||||
| Priority | high | Resolution | no change required | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 141a7e86f4f7 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0010067: Grant total amount changes before and after the completion of the sales order document. | |||||||
| Description | Grant total amount changes before and after the completion of the sales order document. | |||||||
| Steps To Reproduce | Login 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 Solution | Grant total amount should remain same before and after completing the amount. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||||||||||||||||
|
||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0018924) balamurugan (reporter) 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 (developer) 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 (reporter) 2009-08-18 09:07 |
Tested working fine. |
|
(0022034) plujan (manager) 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 (manager) 2009-11-20 13:40 |
Smoke test behaviour will be changed to reflect this fix |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-07-27 12:17 | arunkumar | New Issue | |
| 2009-07-27 12:17 | arunkumar | Assigned To | => rafaroda |
| 2009-07-29 12:59 | psarobe | Status | new => scheduled |
| 2009-07-29 12:59 | psarobe | fix_in_branch | => pi |
| 2009-08-12 12:41 | balamurugan | Note Added: 0018924 | |
| 2009-08-13 06:34 | hgbot | Checkin | |
| 2009-08-13 06:34 | hgbot | Note Added: 0018929 | |
| 2009-08-13 06:34 | hgbot | Status | scheduled => resolved |
| 2009-08-13 06:34 | hgbot | Resolution | open => fixed |
| 2009-08-13 06:34 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/141a7e86f4f72934611e8b7acef6ff3471b5e48a [^] |
| 2009-08-13 10:48 | gnuyoga | Relationship added | related to 0010262 |
| 2009-08-13 12:44 | rafaroda | Assigned To | rafaroda => balamurugan |
| 2009-08-18 09:07 | sureshbabu | Status | resolved => closed |
| 2009-08-18 09:07 | sureshbabu | Note Added: 0018987 | |
| 2009-08-18 09:07 | sureshbabu | Fixed in Version | => pi |
| 2009-08-19 00:00 | anonymous | sf_bug_id | 0 => 2839891 |
| 2009-08-31 08:27 | rafaroda | Relationship added | related to 0010422 |
| 2009-09-18 14:44 | rafaroda | Relationship replaced | has duplicate 0010422 |
| 2009-11-19 18:27 | plujan | Assigned To | balamurugan => rafaroda |
| 2009-11-19 18:27 | plujan | Note Added: 0022034 | |
| 2009-11-19 18:27 | plujan | Status | closed => new |
| 2009-11-19 18:27 | plujan | Resolution | fixed => open |
| 2009-11-19 18:27 | plujan | Fixed in Version | pi => |
| 2009-11-19 18:28 | plujan | Status | new => scheduled |
| 2009-11-20 13:40 | plujan | Note Added: 0022062 | |
| 2009-11-20 13:40 | plujan | Status | scheduled => closed |
| 2009-11-20 13:40 | plujan | Resolution | open => no change required |
| 2010-02-08 12:42 | rafaroda | Relationship added | related to 0012096 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |