Skip to Content
Menú
This question has been flagged
2 Respostes
2805 Vistes

When looking at a stock report in the inventory module, why is the Unit Cost displayed as a zero whenever the On Hand quantity is zero?

Here's an example showing the product page (general info tab)

Here's the inventory tab:

This is the category...

...and these next two are from an inventory report.  The first one has qty of 0 for on hand.

And this one has the qty set to 1.


Avatar
Descartar
Best Answer

Hi Hampton,

In Odoo, the Unit Cost displayed in stock reports or inventory valuations is typically calculated based on the costing method defined for the product. The most common costing methods used are:

  1. Standard Price: The Unit Cost is set manually as a predetermined value called the "Standard Price" for each product.
  2. Average Cost (AVCO): The Unit Cost is calculated as the weighted average cost of all the stock moves (receipts) that brought the product into stock.
  3. FIFO (First In First Out): The Unit Cost is calculated based on the cost of the oldest stock moves first.

When the On Hand quantity is zero, the Unit Cost is displayed as zero because there are no stock moves or receipts recorded for that particular product at that time. In other words, when there is no stock available, there is no cost associated with it, hence the Unit Cost is shown as zero.

However, as soon as new stock is received through a purchase, manufacturing order, or any other incoming stock move, the Unit Cost will be updated based on the costing method used for that product.

It's important to note that even when the On Hand quantity is zero, the product may still have a defined Standard Price or an Average Cost from previous stock movements, but these values are not displayed in the stock report when there is no available quantity.


Hope it helps

Avatar
Descartar
Best Answer

Hello,

You can check out the following scenarios:

  • The costing method that you are using. If you are using Average Cost or FIFO, then it could impact when the stocks are moving in or out. For details, you can check Valuation methods in Odoo
  • If the product cost is zero (in standard costing), the report will show the item's unit cost as zero
Avatar
Descartar
Autor

Hi, Thanks for the response. The product cost is not zero and the costing method is standard. The Unit Cost on the report accurately reflects the product cost whenever the stock level is anything but zero. This doesn't make sense to me.

Can you post the screenshots of any product, category configurations of that product and report?

Autor

Ok, I posted a few pictures of one of the items that doesn't work right. I found another item that does work correctly but I can't seem to find any differences in them. I'll keep looking though.

In the reports, the Unit Cost will show only if you have an on-hand quantity. Otherwise, the unit cost will show as zero only. That's the standard behavior of Odoo.
If you want to know the unit cost of the products, you may have to check the products page. Use the list view for easy checking.

Related Posts Respostes Vistes Activitat
2
de maig 25
567
0
de març 15
3895
2
de febr. 25
2602
0
de nov. 24
758
2
de set. 24
2890