Skip to Content
Menu
This question has been flagged
2 Replies
2804 Views

Hi all,


I am wanting to show the 'Available Quantity' on the Lots/Serial Numbers list view.

The 'Available Quantity' for each Lot/Serial number can be viewed on the Product Template under the 'On Hand' tab.


How can I do this? Preferably using Odoo Studio

I am on v15


Thanks in advance!

Avatar
Discard
Author

Hi Samir,

Available Quantity and on hand quantity are not the same when dealing with Lot/Serial numbers. Available quantity for a specific Lot/Serial number is the quantity that is on hand AND not reserved. On hand quantity is how many that are in stock (whether they are reserved or not). I want to show the available quantity in the Lots/Serial Numbers list view so that my team can see which serial numbers are still available to sell. The available quantity can be viewed through Product>On Hand. However, I want to show it in the Lots/Serial numbers list view so that it can be viewed from the 'Detailed Operations' screen when assigning Lot/Serial numbers to a manufacturing order.
Please see my screenshot in the other comment showing the 'On Hand' tab from the product page.

Hi Sir
Let me clarify your issue
Your issue is when u reserve the Quantity for MO order and that Quantity on Lot Number not identical with the Quantity on the main Stock
So i need to ask you in case the Product Quantity consumed on Manufacture order how it can be same with the On hand Quantity
it should be less according to the Consummations in factory

Author

Hi Samir,

Please see the below screenshots:
https://ibb.co/6nNMX7z
https://ibb.co/QF8S12B

Users want to choose specific Lot/Serial numbers when reserving them on the MO.
When doing so, they cannot see the 'Available Quantity'.
If the Serial Number has already been reserved by another MO, there is no way to see this without navigating to the Product Template.
If the user selects a Serial Number that is already reserved (Quantity on Hand = 1, Available Quantity = 0) then the Serial number is unreserved from the other MO. There is no alert or way to tell when this happens from the user perspective.
If I can add the 'Available Quantity' field to the Lots/Serial Numbers List View, then users can filter out Serial Numbers where the 'Available Quantity' is 0.

Regards,
Lucas

Have you found a solution?

Best Answer

In Odoo V15 + Studio I see quants field but it's a many2one. Samir, Could you share a screenshot how to do it? Thanks

Avatar
Discard
Best Answer

HI Sir

it is very simple by using odoo studio you can select existing field ( Quantity ) will display the Available / on hand Quantity 

Avatar
Discard
Related Posts Replies Views Activity
2
Dec 24
3130
1
Dec 24
352
4
Nov 24
1366
1
Sep 24
1136
1
Sep 24
1203