Warehouse and Locations setup suggestions

warehouse inventory locations

6 Svar

10959 Vyer

Alex Theordore

I need help with deciding on how to setup warehouse and locations. I have the following situation:

1. Multiple companies involved and each company have many branches

2. Within each company, there are many branches. For example, say there are three branches: Los Angeles, New York, Florida.

3. For each locations, there are many delivery trucks. Each day, goods are loaded into a truck (depending on the routes (not Odoo route but physical road routes)). For example, a route going to zip code 91111 to 93333 will be loaded to a truck called "Zip 91111-93333".

4. While trucks will go to each site and deliver the goods. Upon finishing delivery to a customer site, the truck driver will process "Finish" in Odoo. meaning that it should deduct the stocks.

5. At the beginning of the day, in addition to Delivery lists, additional stocks will be loaded to the truck (to sell as non Presales order. i.e. selling a new customer, existing customers want an additional SKU or more quantities).

6. Trucks will return to the warehouse at the end of the day. They will return stocks to warehouse (whatever remaining for Presales:customers changed their minds and don't want it anymore and Non-Presales)

How should I set up warehouses and trucks in Odoo? I want stocks to be transferred between warehouses and trucks easily. and when delivering, the stocks need to be deducted accordingly from a truck. (we want to differentiate what truck delivered to what customers/Sales Order.

I don't think setting up trucks as locations seems easy but how can I link sales order to a location(truck) in Odoo?

Kevin McMenamin

Alex

I don't think you are going to get a solution from standard so i would look at the following process

1. Assuming LA is a warehouse with many trucks, create a warehouse for LA and a warehouse per truck

2. On sale order, warehouse is LA to commit the stock (standard logic) and create the picking/moves. This will have customer as the destination location.

3. Have a module which either logically (based on the customer zip code) or manually
a) updates the existing picking and changes the destination location to the truck location
b) creates a picking and moves for the truck warehouse --> customer

4. for your additional lines, since you don't know who is getting, create a picking from LA stock --> truck warehouse so the stock is correct.

5. truck diver confirms picking. Use this to then create the customer invoice (may or may not be standard in Odoo as we have our own module to do this so i haven't checked)

6. Do a stock return for the ad hoc items and then create sale orders and confirm dispatch for what each customer has taken.

Pinakin Nayi (pna)

Probably this is possible by using picking wave.

How this work ?

You can create sales order and confirm. In Picking wave you can collect(group by) sales order's picking and assign person(in your case truck). Probably you need one more intermediate location "In Truck".

Alex Theordore

Författare

Can I have multiple locations in one warehouse? (i.e Truck1, Truck 2, Truck 3 under one warehouse and choose a truck accordingly to the road route?)

Is Picking Wave the same as Picking as I am not familiar with Picking Wave?

Pinakin Nayi (pna)

That is also possible to create multiple locations under warehouse. But then you have issue with which sales goes to which truck ? How can you decide or how can you assign truck location in sales ?

Picking wave we are using in different manner but in your case we may use it. Like, you have 10 sales order and among 10 5 sales order we need to assign to Truck 1. So we select those picking in picking wave and assign the responsible person as a Truck 1. We take print out of that and gives to truck driver...

Alex Theordore

Författare

Are you referring to this module https://apps.openerp.com/apps/modules/10.0/stock_picking_wave/

I am using Odoo 11 Enterprise. I cannot find it in the Apps or module.

Pinakin Nayi (pna)

Opps. In v11 it is renamed to "Batch Pickings" you can find in inventory setting.

Njuter du av diskussionen? Läs inte bara, delta också!

Skapa ett konto idag för att ta del av exklusiva funktioner och engagera dig i vår fantastiska community!

Registrera dig

Relaterade inlägg	Svar	Vyer
Location Capacity limit warehouse inventory locations	1 feb. 22	6826
How can I define a default warehouse location for a product warehouse inventory locations v14	1 nov. 24	6031
How do you manage warehouse locations? warehouse inventory locations emplacements	2 mars 15	10096
Location type "View" Löst warehouse locations	1 jan. 26	1315
Assign inventory tasks to employee warehouse inventory	0 juli 25	2544

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!