0010422: Tax amount is calculated with less decimals than it should.

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0010422

Openbravo ERP

07. Sales management

public

2009-08-27 20:33

2009-11-19 18:28

Reporter

elopio

Assigned To

rafaroda

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

duplicate

Platform

OS Version

Ubuntu 9.04

Product Version

main

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0010422: Tax amount is calculated with less decimals than it should.

Description

I created a sales order line with a tax of 0.5%+3%. The Format.xml file uses 4 decimals for internal format and 2 for output.
However, the tax is calculated with a precission of 2 decimals.

Steps To Reproduce

Execute testcases ID 1094 :: Test Case Create a Project Type and ID 1096 :: Test Case Create a Multiphase Project (full documentation is on testlink)

Create the products SERVICE A, SERVICE B with the following attributes:
    * Search key: sera, serb, name: Service A, Service B, Tax category:VAT 10%, UOM: Day, Product type: Expense type
    * Login as userA
    * Go to Project & Service Management->Setup->Project Type
    * Click New and fill:
          o Name: Technical consultancy
    * Go to Standard Phase tab.
    * Click New and fill:
          o Name: Project preparation
          o Product: A Final goods
          o Standard Quantity: 10
    * Go to Standard Task tab.
    * Click New and fill:
          o Name: First draft
          o Product: Service A
          o Standard Quantity: 25
    * Click New and fill:
          o Name: Final prototype
    * Go back to Standard Phase tab.
    * Click New and fill:
          o Name: Project delivery
    * Go to Standard Task tab.
    * Click New and fill:
          o Name: Project closing
          o Product: A Final goods
          o Standard Quantity: 15

# 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
# 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

# Edit:

    * Sales representative: Sales A

# Click on Change Project Status button.
# Go to Project Phase tab.
# Move to Project preparation and click on Create Sales Order from Project Phase button. Click OK
# Navigate to the sales order through the link.

Expected Grand Total Amount is 72.83, but 72.84 is displayed.

Go to tax tab.
Tax amount for 3%+0.5% should be 0.88, but is 0.89, because:
- Taxable amount = 25.2
- 25.2 * 3% = 0.756
- 25.2 * 0.5% = 0.126
- 0.756 + 0.126 = 0.882

The application is using 2 decimals, but it should use 4.

Proposed Solution

Use 4 decimals to calculate the tax.

Additional Information