Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
1 Trả lời
12626 Lượt xem

I have a warehouse and in this warehouse i have stored my products. The products are stored on shelves. So a product can be in warehouse A on position, Rack AA, Position 5, shelve 3 (AA-5-3).

This location is used to put the products from a purchase order (incoming shipment) and pulled of on sales order (delivery).

How can i easily set up: - The product location - The incoming delivery order to be sorted on the product location (the path to walk when putting products on shelve) - The delivery order to be sorted on the product location (the path to walk when pulling products from shelve)

I can't see how to set this up, i thought i had to make a location for every product, but that seems not the way.

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

Under warehouse, there is an option to create the various locations. In my situation I use the location as a name (AA-5-3).

I also made a module to extend stock.picking or stock.move, to add a new field sort_order. By default this is 'zzzzzzzzzz', but will be filled with the name of the location of the product when checking for availability.

I can post that part of the code if you are still interested.

To answer the first part: How to setup:

I made a csv-file, with the code of the product and the location, than I used a script to read that file and process the information. So I can recreate the information everytime I have to recreate a database (doing a lot of testing -> lots of errors :) )

Ảnh đại diện
Huỷ bỏ

And can you query the parts quantity by locations? If yes how to set?

Tác giả

Patrick, thanks for your answer. yes i would like to test your code. If you can post it, that would be great.

Bài viết liên quan Trả lời Lượt xem Hoạt động
0
thg 3 15
6044
1
thg 3 15
4306
2
thg 1 22
9749
16
thg 1 21
17251
7
thg 12 23
34794