Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0010536Openbravo ERP05. Production managementpublic2009-09-09 18:152009-10-06 11:36
egoitz 
rafaroda 
normalmajoralways
closedfixed 
30
2.50MP3 
2.50MP6 
Core
No
0010536: The calculate standard costs process does not work using oracle 10g
The calculate standard costs process does not work using oracle 10g.
-Create a new process plan. completly.
-Execute calculate standard costs process selecting the processplan but withou a budget
-Go to standard costs report
-See that the costs of the P- product are not filled
on MA_STANDARD_COST_SEQUENCE
there is a select with condition
 C_BudgetLine.C_Budget_ID = NULL
and should be
 C_BudgetLine.C_Budget_ID is NULL
No tags attached.
related to defect 0007081 closed gorkaion Generate standard cost does not work 
Issue History
2009-09-09 18:15egoitzNew Issue
2009-09-09 18:15egoitzAssigned To => rafaroda
2009-09-14 16:37roklenardicNote Added: 0019912
2009-09-18 11:10hgbotCheckin
2009-09-18 11:10hgbotNote Added: 0020189
2009-09-18 11:10hgbotStatusnew => resolved
2009-09-18 11:10hgbotResolutionopen => fixed
2009-09-18 11:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2024fe4641884c64eb5ce03b9eb2c0185b66dc97 [^]
2009-09-18 11:17rafarodaRelationship addedrelated to 0007081
2009-09-18 11:18rafarodaNote Added: 0020190
2009-09-18 13:34psarobeStatusresolved => closed
2009-09-18 13:34psarobeFixed in Version => 2.50MP6
2009-09-19 00:00anonymoussf_bug_id0 => 2861733
2009-09-29 14:13hgbotCheckin
2009-09-29 14:13hgbotNote Added: 0020483
2009-09-29 14:13hgbotStatusclosed => resolved
2009-09-29 14:13hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/2024fe4641884c64eb5ce03b9eb2c0185b66dc97 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/2024fe4641884c64eb5ce03b9eb2c0185b66dc97 [^]
2009-10-06 11:36psarobeStatusresolved => closed
2009-10-06 11:36psarobeNote Added: 0020765

Notes
(0019912)
roklenardic   
2009-09-14 16:37   
i think it does not work in postgres either since the standard cost i calculated do not include the cost of raw materials...
(0020189)
hgbot   
2009-09-18 11:10   
Repository: erp/devel/pi
Changeset: 2024fe4641884c64eb5ce03b9eb2c0185b66dc97
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Mon Sep 14 18:30:53 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/2024fe4641884c64eb5ce03b9eb2c0185b66dc97 [^]

Fixes issue 0010536 MA_STANDARD_COST_SEQUENCE procedure fixed for Oracle 10g

---
M src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml
---
(0020190)
rafaroda   
2009-09-18 11:18   
Caused by the resolution of 0007081 https://code.openbravo.com/erp/devel/pi/rev/458354ef7fa9 [^]
(0020483)
hgbot   
2009-09-29 14:13   
Repository: erp/devel/pi-pageddatagrid
Changeset: 2024fe4641884c64eb5ce03b9eb2c0185b66dc97
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Mon Sep 14 18:30:53 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/2024fe4641884c64eb5ce03b9eb2c0185b66dc97 [^]

Fixes issue 0010536 MA_STANDARD_COST_SEQUENCE procedure fixed for Oracle 10g

---
M src-db/database/model/functions/MA_STANDARD_COST_SEQUENCE.xml
---
(0020765)
psarobe   
2009-10-06 11:36   
Closed again because hudson has reopened without no reason