Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
2 Odpowiedzi
3563 Widoki

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!

Awatar
Odrzuć
Autor

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

Autor

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?

Najlepsza odpowiedź

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

Awatar
Odrzuć
Najlepsza odpowiedź

HI Sir

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

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
1
cze 25
1861
3
lip 25
3478
1
maj 25
1602
1
maj 25
1844
4
maj 25
2953