Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0008503
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementmajoralways2009-04-08 12:302009-04-29 00:00
ReportersureshbabuView Statuspublic 
Assigned Tovinothbabu 
PriorityhighResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.50betaSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

Descriptionwhen 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 Reproducesteps 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
Tags250 final review, 250MP1
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
duplicate of feature request 0006516 newrmorley Review Scaled Volume Discount 

-  Notes
(0015835)
rafaroda (developer)
2009-04-28 12:05

Hi Suresh,

The calculation of SCALED Volume Discounts has to be completely reviewed (0000651).

Thank you for your detailed feedback.

- Issue History
Date Modified Username Field Change
2009-04-08 12:30 sureshbabu New Issue
2009-04-08 12:30 sureshbabu Assigned To => rafaroda
2009-04-08 12:30 sureshbabu Regression testing => No
2009-04-08 12:31 sureshbabu Tag Attached: 250 final review
2009-04-14 12:17 psarobe Status new => scheduled
2009-04-14 12:17 psarobe fix_in_branch => pi
2009-04-22 10:40 psarobe Priority normal => high
2009-04-22 10:40 psarobe fix_in_branch pi =>
2009-04-22 12:24 rafaroda Assigned To rafaroda => sathiyan
2009-04-22 12:48 sathiyan Assigned To sathiyan => vinothbabu
2009-04-23 16:04 psarobe Tag Attached: 250MP1
2009-04-28 11:05 rafaroda Relationship added related to 0006516
2009-04-28 12:05 rafaroda Relationship added duplicate of 0000651
2009-04-28 12:05 rafaroda Status scheduled => closed
2009-04-28 12:05 rafaroda Note Added: 0015835
2009-04-28 12:05 rafaroda Duplicate ID 0 => 651
2009-04-28 12:05 rafaroda Resolution open => duplicate
2009-04-28 12:06 rafaroda Relationship deleted 0000651
2009-04-28 12:06 rafaroda Relationship replaced duplicate of 0006516
2009-04-29 00:00 anonymous sf_bug_id 0 => 2783263


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker