Skip to Content
Menu
This question has been flagged
2 Replies
3330 Views

Hi Guys,


Need some advice on how to implement a 3PL warehousing solution for a company, the company itself is the 3PL provider, so It receives goods and stores them on racks until delivery is required.


The Problem: 

The issue is that when using the inventory and warehousing module on odoo v.15, all the goods that we receive to store are treated as sellable items which need to have buying price, selling price etc. BASICALLY the module is treating the goods stored in the correct way if they were in a retail company or something like that.

I need it to record type and qty received as well as the exact pallet rack position they are stored in and then to generate a picklist using which we can 'exit' the inventory (using barcodes).

In essence:

The best possible scenario for me would be to get a functioning 3PL module for odoo or something similar, If anyone can guide me on this, I'd really be thankful.

 


Avatar
Discard
Author

@Licia Portu, If you use the Basic 'Inventory' and 'barcode' Module, then I'd say Yes, you will face such issues when dealing with storing and 3PL.

BUT.

With a little bit of customization and the help of a good partner, we were able to resolve most of our critical issues and migrate our operations onto odoo with 90% of our issues resolved, the remaining 10% to be solved during the go-live period.

Are such issues common for 3rd party logistics and storing?

Are such issues common for 3rd party logistics and storing?

/I need the same exact thing for an 3pl warehousing, did you find any solution let me know. Thanks

Best Answer

In Odoo, a Warehouse is the actual building/place in which your items are stocked. You can setup multiple warehouses and create moves between warehouses.


Location, is a specific space within your warehouse. It can be considered as a sublocation of your warehouse, as a shelf, a floor, an aisle, etc. Therefore, a location is part of one warehouse only and it is not possible to link one location to multiple warehouses. You can configure as many locations as you need under one warehouse.

Locations are understood by the Barcode App and you can print barcodes for them, or enter the barcode for them if you already have barcodes on your Racks - see https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/barcode/setup/software.html#set-locations-barcodes

You can activate this feature from the Inventory App, Configuration --> Settings Menu:


Multi-step Routes support things like cross docking - see https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/routes/concepts/cross_dock.html


Storage Categories are useful if you have rules about where products are allowed to be stored, when they can be mixed, or need to know if a location is full BEFORE you try to put something there, and have an ALTERNATE location suggested instead. This is supported when your products can be created in advance (because you regularly receive them to REPLENISH quantities, perhaps because you are a third party fulfillment warehouse) - see https://www.cybrosys.com/blog/storage-categories-in-odoo-15


Packages are containers of products, like palettes or crates or totes, which also may (or may not) have separate barcodes. In addition to storing the location, you can store the package within the location. See https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/management/products/usage.html


A Consignment feature supports you assigning an Owner to each Receipt Transfer you receive - see https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/management/misc/owned_stock.html


Serial Numbers and Lots can optionally be recorded for high value products or those needing track and trace - see https://www.odoo.com/documentation/15.0/applications/sales/point_of_sale/shop/serial_numbers.html

 

Landed Costs can be added to the cost of the product if you charge per product fees or storage charges, etc. - see https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/management/reporting/integrating_landed_costs.html


We integrate with 3rd Party Shippers (UPS, FedEx, OnTrac, Deutsche Post, etc) to get labels and provide tracking information for shipments - see https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/shipping/setup/third_party_shipper.html


We support location based or task based inspections, with an audit trail of the inspection steps performed (and by whom) - see https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/management/delivery/inventory_flow.html and https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/manufacturing/management/quality_control.html


We have multi-company support (if you manage multiple LLC's or legal entities) - see https://www.odoo.com/documentation/15.0/developer/howtos/company.html


We have multi-currency support (if you work in multiple countries) see https://www.odoo.com/documentation/15.0/applications/finance/accounting/getting_started/main_concept.html


We have an Email Server (or can integrate with your email system), with all emails available from beneath the corresponding Receipt, Transfer, Return, Delivery, etc.  See https://www.odoo.com/documentation/15.0/applications/general/email_communication/email_domain.html


We have an integrated Order Management (Purchase Orders and Sales Orders) system - see https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/purchase.html and https://www.odoo.com/documentation/15.0/applications/sales/sales.html


Our Customer Portal gives your Customers a view into the status of their shipments. See https://www.odoo.com/documentation/15.0/applications/sales/sales/advanced/portal.html


Our Invoicing App manages your billing - see https://www.odoo.com/documentation/15.0/applications/finance/accounting.html

Avatar
Discard
Author

Hey Ray,

Thanks so much for your comment.

Even though what you have said is very helpful for someone who's "Dealing with 3PL's" but in our case, we are the 3PL ourselves.

So we need to:
1.) Track Incoming shipments
2.) Print barcodes and use them to track pallet locations on the Racks.
3.) Do storage invoicing for the stock kept in warehouse and send monthly recurring invoice.
4.) print Certain forms that go along with the goods as they exit our inventory.

We are still working though the issues that we are facing, specially with storage invoicing.

Please do let me know if you have any thoughts on this.

Thanks.

I don't have a good solution for storage invoicing without customization. The Sales Order is the place where a record of which locations are used each month can be managed, and Invoicing would be automated. The challenge is the trigger to update each "location" (product) and increment the quantity "delivered". If someone uses location A each month you simply increment the quantity delivered each month and that line becomes invoiceable. I would start there with a manual process and learn which parts would be automatable and what the edge cases were.

Author

Thanks for your reply ray,

It is indeed a complex problem with many different scenarios.

We are still trying to work on a solution, here's where we are at the moment:

in its simplest form the entire quantity that comes in goes out all together on a single day... so we can simply use the formula { quantity x Days x Rate per day } and that works.

but the problem arises later on when we go into the more complex scenarios,

eg: half the shipment goes out on day # 10 and the rest goes out in multiple different pieces over the course of the next few days, so how does the system calculate the number of days (per in document or per qty delivered)

in another case, some customers need to be given a variable number of free days, after which the system should start calculating the storage of remaining quantity automatically.

Author Best Answer

Hi JNZ, yes, we have found a solution, In our case, we took the standard Inventory and Barcode module and modified it heavily to suit our needs. each rack location had to be inputted as both a source and destination location and we had to manually link the barcodes on our physical racks to the virtual locations.


It's been a little long and tedious process but we now have the system working well enough to suit our needs, although it does require a little more work to make it perfect.

Feel free to reach out again if you need more info, maybe we can exchange information for mutual benifit.


Avatar
Discard

Could you please share more information that what exactly you customized? And what was the strategy.

Related Posts Replies Views Activity
3
Jan 24
17087
2
Mar 23
3523
3
Mar 16
4116
0
Dec 24
14
1
Oct 24
838