Hello Tony,

Based on your screenshots, I can explain why some products show zero total value in stock reporting despite having on-hand quantities.

The Root Cause

The total value calculation in Odoo follows this formula:

Total Value = On Hand Quantity × Product Cost

In your case, the zero values occur because:

1. Missing Cost Data: For products like "JAY CARTON GINGER GARLIC PASTE", the unit cost shows as ₹0.00 (as visible in your first screenshot)
2. Manual Inventory Adjustments: When you added stock manually without specifying the cost, Odoo defaulted to zero cost for those products
3. Inconsistent Cost Updates: Some products have costs (like the ₹45.00 one), while others don't

How to Fix This

1. Update Product Costs

Go to each affected product:

1. Open the product form (Inventory → Products)
2. Go to the Inventory tab
3. Set the Cost field with the correct value
4. Save the product

2. Correct Historical Valuations

For existing stock:

1. Go to Inventory → Operations → Inventory Adjustments
2. Create a new adjustment for each affected product
3. Enter both:
   • The correct on-hand quantity
   • The unit cost (under "Accounting" tab during adjustment)
4. Validate the adjustment

3. Verify Valuation Methods

Check your inventory valuation method:

1. Go to Settings → Inventory → Settings
2. Ensure you're using FIFO or Average Cost (not Standard Price unless you maintain it)
3. For Standard Price method, costs must be manually maintained

Prevention for Future Transactions

1. Always specify costs when:
   • Receiving products (Purchases)
   • Doing manual inventory adjustments
   • Manufacturing products
2. Use landed costs if you have additional expenses:
   • Go to Inventory → Operations → Landed Costs
   • Distribute additional costs across received products

Why Some Products Show Correct Values

Products showing correct values likely had their costs set:

• During purchase order receipt
• Via manual inventory adjustment with cost specified

Through automated manufacturing orders with proper costing

🚀 Did This Solve Your Problem?

If this answer helped you save time, money, or frustration, consider:

✅ Upvoting (👍) to help others find it faster

✅ Marking as "Best Answer" if it resolved your issue

Your feedback keeps the Odoo community strong! 💪

(Need further customization? Drop a comment—I’m happy to refine the solution!)

If the total value in the stock report is showing 0, here are the most common causes and solutions:

 1. Missing Inventory Valuation Setup

• Check Product Category → Inventory Valuation
  • Should be Automated
  • Should have correct Stock Input/Output and Inventory accounts

✅ Navigate to:

Inventory > Configuration > Product Categories > Your Category

 2. Incorrect Costing Method

• Verify the Costing Method:
  • Standard, Average, or FIFO
  • If set incorrectly, stock valuation may not calculate expected values.

✅ Set this under the same product category.

 3. No Valuation Entries Recorded

• For valuation to work:
  • Product must be storable
  • Moves should be done (not draft)
  • You must have accounting entries generated via the automated valuation

🛠 Run the scheduler or force valuation entries via Inventory > Reporting > Inventory Valuation

 4. Debug Mode Check

Enable developer mode and check:

• stock.quant and stock.valuation.layer records
• Verify value field is not 0