Skip to Content
This question has been flagged
warehouseinventorylocations
6 Replies
9543 Views
Avatar
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?




Avatar
Discard
Avatar
Kevin McMenamin
Best Answer

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. 

Avatar
Discard
Avatar
Pinakin Nayi (pna)
Best Answer

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".

Avatar
Discard
Alex Theordore
Author

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
Author

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.

Related Posts Replies Views Activity
Location Capacity limit
warehouse inventory locations
Avatar
Avatar
1
Feb 22
5861
How can I define a default warehouse location for a product
warehouse inventory locations v14
Avatar
Avatar
1
Nov 24
5048
How do you manage warehouse locations?
warehouse inventory locations emplacements
Avatar
Avatar
2
Mar 15
9123
Assign inventory tasks to employee
warehouse inventory
Avatar
0
Jul 25
1319
How to prevent negative stock in Odoo18? Solved
warehouse inventory
Avatar
Avatar
Avatar
Avatar
Avatar
4
Sep 25
11261