Skip to Content
मेन्यू
This question has been flagged

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 :)

Avatar
Discard
Best Answer

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. 


Avatar
Discard
Author

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.

Author

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.

Author

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 :)

Best Answer

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).

Avatar
Discard
Related Posts Replies Views Activity
1
जून 25
3688
1
अप्रैल 23
2508
1
जुल॰ 20
2296
1
जुल॰ 25
1526
2
मार्च 24
1926