Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0008431Openbravo ERP04. Warehouse managementpublic2009-04-03 15:332009-06-02 00:00
sureshbabu 
rafaroda 
normalminoralways
closedno change required 
30
2.50beta 
 
Core
No
0008431: In Valued stock report for some products the average cost shows zero
In Valued stock report for some products the average cost shows zero

Warehouse Management || Analysis Tools || Valued Stock Report || Valued Stock Report

Note: Check the screen shot for details
Needed to discuss what would be the correct solution
250 final review
jpg Value stock for some products the average cost is Zero.JPG (245,667) 2009-04-03 15:33
https://issues.openbravo.com/file_download.php?file_id=1124&type=bug
jpg
Issue History
2009-04-03 15:33sureshbabuNew Issue
2009-04-03 15:33sureshbabuAssigned To => rafaroda
2009-04-03 15:33sureshbabuFile Added: Value stock for some products the average cost is Zero.JPG
2009-04-03 15:33sureshbabuRegression testing => No
2009-04-03 15:36sureshbabuTag Attached: 250 final review
2009-04-22 17:13psarobePriorityhigh => normal
2009-04-22 17:13psarobeSeveritymajor => minor
2009-04-22 17:13psarobeStatusnew => scheduled
2009-04-22 17:13psarobeSteps to Reproduce Updated
2009-06-01 17:12rafarodaStatusscheduled => closed
2009-06-01 17:12rafarodaNote Added: 0016816
2009-06-01 17:12rafarodaResolutionopen => no change required
2009-06-02 00:00anonymoussf_bug_id0 => 2799680

Notes
(0016816)
rafaroda   
2009-06-01 17:12   
Hi Suresh,

Valued Stock Report reports data from Costing tab (M_Costing table) inside Product window. This table is filled running Generate Average Costs process (Warehouse Management || Transactions || Generate Average Costs) using price/cost data from products which cost type is Average and have been purchased and then received. If a stocked product has not been purchased and received there will not be lines in Costing tab and both Average Cost and Valuation (Quantity x Average Cost) will be zero in the Valued Stock Report. By navigating from those products links in the Valued Stock Report to Costing tab you will see their average cost.