Skip to Content
This question has been flagged
stockv7stock_location
1 Odpoveď
13230 Zobrazenia
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
Zrušiť
Avatar
patrick
Best Answer

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
Zrušiť
klacus

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

Erwin van der Ploeg
Autor

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

Related Posts Replies Zobrazenia Aktivita
How to process a supplier SKU change
stock v7
Avatar
0
mar 15
6710
how to disable stocks ?
stock v7
Avatar
Avatar
1
mar 15
4908
How to enter backdated stock moves?
stock v7 inventory
Avatar
Avatar
Avatar
2
jan 22
10544
Module/Function that shows/returns stock locations in products Solved
stock product stock_location
Avatar
Avatar
Avatar
Avatar
16
jan 21
17952
How to export product quantities to a csv file? Solved
stock online v7
Avatar
Avatar
Avatar
Avatar
Avatar
7
dec 23
35560