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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005525
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminoralways2008-10-14 19:082009-04-21 12:39
ReporternataliaperuView Statuspublic 
Assigned Togorkaion 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision12514
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005525: Generate Average costs process does not calculate correctly the average

DescriptionWhen an order contains two lines with the same product and one of them has price 0, the process does not take into account the product with price 0.
Proposed SolutionComment the following lines in GENERATE_AVERAGE_COST procedure:

      --IF(Cur_InOutLine.MOVEMENTDATE=v_DateOld AND Cur_InOutLine.M_PRODUCT_ID=v_ProductOld) THEN
        v_CumQty:=v_CumQty + Cur_InOutLine.MOVEMENTQTY;
     -- END IF;
Tagscomsup_sprint5
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0005610 closedgorkaion Generate Average costs process does not calculate correctly the average 
depends on backport 0005611 closedgorkaion Generate Average costs process does not calculate correctly the average 

-  Notes
(0009644)
psarobe (manager)
2008-10-20 11:24

 Please we need more feedback for you proposed solution
(0009672)
psarobe (manager)
2008-10-22 10:29

 Gorka when fix the bug write an explanation of what to do for cheking that the bug has been really fixed
(0010034)
olli (reporter)
2008-11-06 12:52

 I have a different problem but the solution is the same. The problem occurs when there are two goods receipts containing the same product in the same day. The procedure doesn't increment the v_CumQty when calculating the first line, because Cur_InOutLine.M_PRODUCT_ID=v_ProductOld is false. That's why the quantity of the first line is not taken into account.
(0012852)
svnbot (reporter)
2009-01-29 18:16

 Repository: openbravo
Revision: 12514
Author: gorkaion
Date: 2009-01-29 18:16:13 +0100 (Thu, 29 Jan 2009)

Fixed bug 5525. Applied the proposed solution removing the if clause.

---
U trunk/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=12514&sc=1 [^]

- Issue History
Date Modified Username Field Change
2008-10-14 19:08 nataliaperu New Issue
2008-10-14 19:08 nataliaperu Assigned To => cromero
2008-10-14 19:08 nataliaperu sf_bug_id 0 => 2166412
2008-10-20 11:24 psarobe Note Added: 0009644
2008-10-20 11:24 psarobe Status new => feedback
2008-10-22 10:29 psarobe Status feedback => scheduled
2008-10-22 10:29 psarobe Note Added: 0009672
2008-10-22 10:29 psarobe Assigned To cromero => gorkaion
2008-10-22 10:29 psarobe fix_in_branch => trunk
2008-11-06 12:52 olli Note Added: 0010034
2009-01-19 10:09 rafaroda version => 2.40
2009-01-19 10:09 rafaroda fix_in_branch trunk =>
2009-01-29 16:58 rafaroda Priority normal => immediate
2009-01-29 18:16 svnbot Checkin
2009-01-29 18:16 svnbot Note Added: 0012852
2009-01-29 18:16 svnbot Status scheduled => resolved
2009-01-29 18:16 svnbot Resolution open => fixed
2009-01-29 18:16 svnbot svn_revision => 12514
2009-02-06 01:17 gorkaion Tag Attached: comsup_sprint5
2009-04-21 12:39 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker