0008503: Difference in invoice amount generated through volume discount.(in decimal places)

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0008503

Openbravo ERP

02. Master data management

public

2009-04-08 12:30

2009-04-29 00:00

Reporter

sureshbabu

Assigned To

vinothbabu

Priority

high

Severity

major

Reproducibility

always

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

2.50beta

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

0008503: Difference in invoice amount generated through volume discount.(in decimal places)

Description

when invoice is generated through volume discount(scaled), there is a difference in the invoice amount(in decimal places)

The scenario which i tried to test here is, creating a volume discount(with scaled option checked) where i have defined different discount for each scale of amount. After generating the invoice through volume discount i found difference in invoice amount (in decimal places)

(issue with precession)

Steps To Reproduce

steps which i used to reproduce the issue:

created a volume discount1 ( Master Data Management || Business Partner Setup || Volume Discount || Volume Discounts )
Name: <enter a valid name >
Scaled: Check
Included Product: All selected
Included Product categories: Not selected

Step 2: Move to Product tab and
product: Hammer

step 3: Move to volume discount parameters tab
Discount %: 5 (5%)
Min Amount : 1
Max amount : 9 999
Click save and click new

Discount %:10 (10%)
Min Amount : 10 000
Max amount : 14 999

Move to Business partners tab

Business partner: Red bunny
Valid from date: <today's date>
Sales Transaction: checked

*** Sales Management testing the range1 : 1 - 9999 (5%)****

Create sales order for Red Bunny supplies with product : Hammer and qyt : 1 (line net amount : 5.22)
Complete Goods Shipment for the above generated SO
Complete Sales invoice for the above generated SO

Move to Master data management and click Business partner
Edit the Red bunny BP and click volume discount tab and click 'Generate Invoice' button. "process completed successfully message appears and Invoice id will be generated : <INV1>
Check the invoice details under volume discount settlement tab.

Open the above created invoice <INV1> and verify the invoice details.
Sales Management || Transactions || Sales Invoice || Header

in line tab in the description it is mentioned as
(5.22*(4.04214559386973180076628352490421455939/100)) - 0
and line net amount -0.21.

But when i calculated through excel i am getting line amount as (5.22*5/100 = 0.261)

Actual amount is -0.21 whereas expected is -0.261

*** Again i tried to test the range2 : 10 000 - 14 999 (10%)****

Create sales order for Red Bunny supplies with product : Hammer and qyt:2000 (line net amount : 10440.00)
Complete Goods Shipment for the above generated SO
Complete Sales invoice for the above generated SO

Move to Master data management and click Business partner
Edit the Red bunny BP and click volume discount tab and click 'Generate Invoice' button. "process completed successfully message appears and Invoice id will be generated : <INV2>
Check the invoice details under volume discount settlement tab.

Open the above created invoice <INV2> and verify the invoice details.
Sales Management || Transactions || Sales Invoice || Header

in line tab in the description it is mentioned as
(10445.22*(5.21015354391769632425166726981336917748/100)) - 0
and line net amount -544.21.

But when i calculated through excel i am getting line amount as (9999*5/100) + (441*10/100) = 544.05

Expected amount is -544.05 whereas actual amount is -544.21

Proposed Solution

Additional Information