Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

ลูกค้าสัมพันธ์
e-Commerce
ระบบบัญชี
สินค้าคงคลัง
PoS
โปรเจกต์
MRP

All apps

All Posts คน เหรียญรางวัล

แท็ก (View all)

odoo accounting v14 pos v15

เกี่ยวกับฟอรั่มนี้

ช่วยเหลือ

Filtering Locations by Stock in Product Delivery View on Odoo Online with Studio Customization

inventory locations delivery filtering domains

1 ตอบกลับ

2067 มุมมอง

Robin JOSEPH

Hello,

In the inventory module, when I make a delivery, I would like the list of locations available for transferring goods to include only those that contain the product in question.

My store has around 100 locations, and it's difficult for my staff to remember which location each product is in.

So, when they make a delivery, they either have to physically go into the store to see where the product was taken from (which is not at all optimal), or check the list of locations in which the product is stored, from the product sheet, which is not ideal either.

I'd therefore like the delivery interface to show, when they select a product to be delivered, the list of selectable locations to include only those containing the product just selected. Naturally, if there are only two or three left, they'll be in a much better position to choose.

I tried to use a domain to create this filter, based on the 'Qty → product_id' field accessible from 'location_id', but I couldn't do it. I'm on Odoo online with Odoo Studio, so I have some customization possibilities, but they're not very extensive either.

Does anyone have a solution to my problem?

Thank you in advance, and I'll be happy to talk to you.

Cybrosys Techno Solutions Pvt.Ltd

Hi Robin,

You can achieve this functionality by creating a custom computed field in the stock.picking model and applying a domain on the location_id field based on the computed field.

Here are the steps to follow:

Open Studio mode on the stock.picking model and add a new computed field.
Choose "Many2many" as the field type and name it available_locations.
In the "Relation" field, select stock.location (or the model name for the locations).
In the "Compute" section, add a compute function like this:

Quant = self.env['stock.quant']
for record in self:
    if record.product_id:
        quants = Quant.search([('product_id', '=', record.product_id.id), ('quantity', '>', 0)])
        record['available_locations'] = quants.mapped('location_id')
    else:
        record['available_locations'] = False

Set the dependent field as product_id.
After creating the computed field, proceed to apply a domain on the location_id field like so:

[("id", "ilike", "available_locations.ids")]

This method should meet your requirements.

Hope it helps

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
How to create material flow with material supplier and subcontractor V18.0 inventory locations delivery subcontractor routes	2 ต.ค. 25	776
How to deliver to workshop or customer from same sales order? Add parts SO from delivery แก้ไขแล้ว inventory locations delivery sales.order route	1 ส.ค. 24	1688
How salesman control [committed product and to be consumed materials quantities] in his Sale order? sales manufacturing inventory locations delivery	0 ก.ย. 19	3093
Odoo - use different production virtual locations with different GL accounts inventory locations	0 ม.ค. 24	2281
Configuration problems in warehouses and locations แก้ไขแล้ว inventory locations	3 ธ.ค. 22	5389

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!