跳至内容
菜单
此问题已终结

I using Odoo13 CE.

I do inventory adjustment on 14/07/2020, and the quantity done for the product is 28 units.

And then on 18/07/2020 I sell that product, it moved from WH/Stock to Partner Locations/Customer 1 units.

Like this image:



But, why on my product information the quantity on hand and forecasted is -4?



How exactly to read the product moves?

Any help and explanation would be very appreciated, thanks :)

形象
丢弃
最佳答案

Hello Lima Saudara,

Stock move done with 28 qty it doesn't mean you have 28 qty in stock at that time. It means product moves has been created with 28 qty to make your theoratical and counted qty equal.

Actually on the product view (listview / formview) shows the quantity including all your warehouses and the forecasted quantity considered confirmed sales which are not done yet (means outgoing quantity), so if you have any open sales then it will be reflected to the forecasted quantity. 

One more factor is, if you have multiple warehouses then it will shows the forecasted quantity combined of all your warehouses. 


To check the proper stock go to INVENTORY => REPORTING => INVENTORY REPORT

Remove Group by option Product > Location and set new group by Location only. 

Here you will get the detailed stock for all the locations. You can also hide/ see the reserved quantity field. 


形象
丢弃
编写者

Hi Setu, thanks for the response,

I know it, the quantity on hand = all quantity on my warehouse

and the forecasted quantity = the product that will be outgoing or incoming to my warehouse.

The thing that makes me confused is:

I have 28 units product on 14/07/2020 after inventory adjustment, then on 18/07/2020 I sell the product 4 units.

But after it, why now my stock is -4?

Can you show me Inventory adjustment you done on 14/07/2020?

Inventory adjustment line where I can check the real quantity and theoritical quantity of the project at that time.

编写者

Here is the screenshot for the inventory adjustment that I do on 14/07/2020:

https://pasteboard.co/JiE6Ztj.png

in Inventory adjustment form view there is one field which is invisible for now, make it visible temporary to check.

<field name="line_ids" invisible="0"/>

Once this field visible, you will see adjustment lines, by clicking on record you will see the theoratical qty and counted qty and see the difference.

Stock move done with 28 qty it doesn't mean you have 28 qty in stock at that time. It means product moves has been created with 28 qty to make your theoratical and counted qty equal.

编写者

I got the key:

"Stock move done with 28 qty it doesn't mean you have 28 qty in stock at that time"

Thanks a lot Man :)

最佳答案

Hi Lima:

Forecasted Qty = Qty On Hand (Done) +/- Reserved Quantities

In your case, since you have a -ve Forecasted Qty, check whether there are any Delivery Orders that are in Ready status (with reserved quantity).

形象
丢弃
相关帖文 回复 查看 活动
1
6月 25
3721
1
4月 23
2512
1
7月 20
2300
1
7月 25
1547
2
3月 24
1934