Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0002625Openbravo ERP03. Procurement managementpublic2008-02-19 13:092008-07-09 18:47
user71 
gorkaion 
normalminoralways
closedfixed 
5
 
2.40beta 
No
Core
No
0002625: PROC. GENERATE_AVERAGE_COSTS: Delete Production Costs
Version 2.35MP1 (Oracle)

In the begining of the PROCEDURE “GENERATE_AVERAGE_COSTS”, it Delete all the existing cost in M_COSTING with the next sentence:

DELETE FROM M_COSTING WHERE ISPERMANENT='N' AND ISMANUAL='N' AND COSTTYPE='AV';

With this DELETE, the Propduction Costs are deleted-->ERROR
The sentence must be changed by this one:

DELETE FROM M_COSTING WHERE ISPERMANENT='N' AND ISMANUAL='N' AND COSTTYPE='AV' AND ISPRODUCTION = 'N';
No tags attached.
depends on backport 0003671 closed gorkaion PROC. GENERATE_AVERAGE_COSTS: Delete Production Co 
Issue History
2008-07-09 18:47plujanStatusresolved => closed
2008-07-09 18:47plujanFixed in Version2.40alpha-r2 => 2.40beta

Notes
(0006214)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1896869 [^]