Real-Time Stock Visibility in POS Lot Selection

[nkirui]

Is your feature request related to a problem?

Yes. Currently, the Odoo POS Lot Selection module allows cashiers to select or enter any lot number without indicating its availability. This leads to:

Operational delays: Cashiers select a lot, only to find out during validation or post-sync that it is out of stock.

Inventory Errors: It allows for "ghost" sales of lots that don't exist in that specific branch/location.

Manual Work: Cashiers have to manually check a separate "Inventory" app to see which lots are actually on the shelf.

Describe the solution you'd like
I want the POS Lot Selection pop-up to be "Stock Aware":

Quantity Preview: Beside each lot number in the selection list, the available quantity (On Hand) for the current POS location should be displayed.
Auto-Filtering: Any lot number with a quantity less than 1 it should be filtered out of the display entirely.
Real-time Update: The quantities should be fetched from the loaded POS indexedDB or via an RPC call to ensure they are current

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.
Manual lookup: Cashiers use the "Product Info" button, but this doesn't specifically link back to the lot selection flow efficiently

Additional context
This is particularly critical for businesses dealing with perishables (pharmacies, supermarkets, or high-end shampoos) where FIFO (First In, First Out) depends on selecting the correct batch.

[cvinh]

Hello,

thanks for reporting, we had this thought as well but...

When we have a product at the cashier, it means it's in stock (as you have it in your hands). So how could this be managed if you have a wrong stock in odoo ? With that feature, you won't be able to sell the product as the software will block your sale.

IMHO the best way is to scan the lot number with https://github.com/OCA/pos/tree/17.0/pos_lot_barcode or better way to scan the datamatrix if you have it on the box

WDYT ?

[nkirui]

Hello,

thanks for reporting, we had this thought as well but...

When we have a product at the cashier, it means it's in stock (as you have it in your hands). So how could this be managed if you have a wrong stock in odoo ? With that feature, you won't be able to sell the product as the software will block your sale.

IMHO the best way is to scan the lot number with https://github.com/OCA/pos/tree/17.0/pos_lot_barcode or better way to scan the datamatrix if you have it on the box

WDYT ?

Look at it this way, sometimes you have lots numbers that dont have quantities but still get displayed on the pos , so cashier doesnt know which has and which doesnt.

Below is how the current pos selection looks like.

I was toying around to look like this ,at glance it enables the cashier sell on the lot that has qnt

[cvinh]

Can you decribe how the cashier chooses the right lot ? I don't understand the use case.

In all our use cases, the product is in the hand of the cashier so he just have to read the lot number on the box...

Or do you mean that the customer pays first the pos order and then someone delivers the lot number selected by the cashier... ? In that case, how does the cashier chooses the lot number ? 0000205 (qty 497) or AR0000206 (qty 42) ? it would mean that the cashier manually chooses the logistic strategy (therefore he will break FIFO, FEFO or whatever rule)

There's another use case in the pharmacy industry where you pay for the product first then an automate gets the right lot (depending on the logistic strategy) in the stock and sends back the lot number to the stock move... but it's anothet story

On the other side, just adding the quantity besides the lot number should not be a very big deal... the module should be named pos_lot_selection_quantity module or something like that

My 2 cents

[nkirui]

Can you decribe how the cashier chooses the right lot ? I don't understand the use case.

In all our use cases, the product is in the hand of the cashier so he just have to read the lot number on the box...

Or do you mean that the customer pays first the pos order and then someone delivers the lot number selected by the cashier... ? In that case, how does the cashier chooses the lot number ? 0000205 (qty 497) or AR0000206 (qty 42) ? it would mean that the cashier manually chooses the logistic strategy (therefore he will break FIFO, FEFO or whatever rule)

There's another use case in the pharmacy industry where you pay for the product first then an automate gets the right lot (depending on the logistic strategy) in the stock and sends back the lot number to the stock move... but it's anothet story

On the other side, just adding the quantity besides the lot number should not be a very big deal... the module should be named pos_lot_selection_quantity module or something like that

My 2 cents

I will do a pull request.