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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005610
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 04. Warehouse managementminoralways2008-10-22 10:292009-03-05 10:54
ReporternataliaperuView Statuspublic 
Assigned Togorkaion 
PriorityimmediateResolutionopenFixed in Version2.40MP3
StatusclosedFix in branch2.40Fixed in SCM revision12515
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005610: 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 ]
blocks defect 0005525 closedgorkaion Generate Average costs process does not calculate correctly the average 

-  Notes
(0012853)
svnbot (viewer)
2009-01-29 18:17

 Repository: openbravo
Revision: 12515
Author: gorkaion
Date: 2009-01-29 18:17:58 +0100 (Thu, 29 Jan 2009)

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

---
U branches/r2.40/src-db/database/model/functions/GENERATE_AVERAGE_COSTS.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=12515&sc=1 [^]
(0014346)
arunkumar (viewer)
2009-03-04 06:36

 I have created a purchase order with two lines.
Line 10 : Boots with price 27
Line 20 : Boots with price 0

I created purchase order and goods receipt.

I ran "Generate Average Costs". Then "Valued Stock Report"

This process does not take into account the product with price 0. It considers only 27.

- Issue History
Date Modified Username Field Change
2008-10-22 10:29 psarobe New Issue
2008-10-22 10:29 psarobe Assigned To => gorkaion
2008-10-22 10:29 psarobe Status new => scheduled
2008-10-22 12:26 villind Issue Monitored: villind
2009-01-19 10:09 rafaroda OBNetwork customer => No
2009-01-19 10:09 rafaroda version => 2.40
2009-01-29 15:45 networkb OBNetwork customer No => Yes
2009-01-29 15:45 networkb Priority normal => immediate
2009-01-29 18:17 svnbot Checkin
2009-01-29 18:17 svnbot Note Added: 0012853
2009-01-29 18:17 svnbot Status scheduled => resolved
2009-01-29 18:17 svnbot Resolution open => fixed
2009-01-29 18:17 svnbot svn_revision => 12515
2009-02-06 01:17 gorkaion Tag Attached: comsup_sprint5
2009-03-03 17:32 psarobe Fixed in Version => 2.40MP3
2009-03-04 06:36 arunkumar Status resolved => new
2009-03-04 06:36 arunkumar Resolution fixed => open
2009-03-04 06:36 arunkumar Note Added: 0014346
2009-03-04 06:36 arunkumar Fixed in Version 2.40MP3 =>
2009-03-05 10:54 psarobe Status new => scheduled
2009-03-05 10:54 psarobe Fixed in Version => 2.40MP3
2009-03-05 10:54 psarobe Status scheduled => resolved
2009-03-05 10:54 psarobe Regression testing => No
2009-03-05 10:54 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker