İçereği Atla
Bu soru işaretlendi
stockv7stock_location
1 Cevapla
13189 Görünümler
Avatar
Erwin van der Ploeg

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.

Avatar
Vazgeç
Avatar
patrick
En İyi Yanı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 :) )

Avatar
Vazgeç
klacus

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

Erwin van der Ploeg
Üretici

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

İlgili Gönderiler Cevaplar Görünümler Aktivite
How to process a supplier SKU change
stock v7
Avatar
0
Mar 15
6685
how to disable stocks ?
stock v7
Avatar
Avatar
1
Mar 15
4878
How to enter backdated stock moves?
stock v7 inventory
Avatar
Avatar
Avatar
2
Oca 22
10489
Module/Function that shows/returns stock locations in products Çözüldü
stock product stock_location
Avatar
Avatar
Avatar
Avatar
16
Oca 21
17918
How to export product quantities to a csv file? Çözüldü
stock online v7
Avatar
Avatar
Avatar
Avatar
Avatar
7
Ara 23
35518