Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Pull rules from same destination based on conditions

Subscribe

Get notified when there's activity on this post

This question has been flagged
domain_filterroutes
2 Replies
1147 Views
Avatar
Pablo Perugini

Hi, we are implementing Odoo so I'm a newbie here....


I'm trying to prevent a pull rule from triggering in a route based on the virtual quantity available in the warehouse. I read that this might be achievable using domain filters (maybe I missunderstood)

What I want to do is create a route with two pull rules originating from the partners/customers location. The first rule, with higher priority, should try to take stock from warehouse A. If not available in Warehouse A, maybe it will trigger  the second rule from warehouse B.

This approach would allow me to reduce the number of routes and make the sales process more user-friendly without using virtual warehouses.


The route I want to achieve would something like this (simplified to explain what I need)

A/Stock -> A/Packing -> A/Out -> Partners/Customers

But if there is no stock in A/Stock, execute:

B/Stock -> B/Packing -> A/Out -> Partners/Customers


This is because I want to transfer already packed products to avoid reception process and I don't want to sales people to select from too many routes (We have several warehouses) 


Can this be achievable? 

0
Avatar
Discard
Pablo Perugini
Author

Thank you, Jaideep, your explanation was very clear. I have one more question for you.

Using the logic you showed me, is there a way to auto-cancel the items from order WH/PICK/00002 that were requested from WH2 to avoid accidentally duplicating the delivery?

Jaideep

The operation would not reserve the items that are not available, so I guess the only way to duplicate pick would be to manually change the done qty.

The case in your post might be representing only 1 of many scenarios. I would believe in practice a sales order might have multiple products with availability across WHs or maybe partial quantities of a product available in main WH.

These might require decisions on how and where these orders would be fulfilled prior leading to canceling the operation.

Jaideep

If I understand correctly your intention is to modify the demand qty of the product in the 1st operation. Am not certain if that is possible.

Avatar
Jaideep
Best Answer

Yes, it is possible. 

The latest version accomplishes multi step deliveries using Push rules, ensuring the subsequent operations are created on based on the arrival of products to destination location, also there is flexibility to change destination location on the operations. 

1.Enable 3step delivery on both the WHs Inventory > Configuration > Warehouses

2.On the rule WH: Stock → Customers (main WH) change supply method to Take from stock if unavailable trigger another rule

3.Create new route WH2 to WH 

Pull from - WH2/stock to WH/Stock

Operation - Warehouse 2: Pick (this is critical so a Pick is created in WH2 from stock to Packing zone)

Supply method - In this example take from stock, but you would add multiple rules eg. if stock not in WH2, then pull from WH3 etc..

4. Select this route on the product or product category.

On confirming the sales order (where products are not available in WH) 2 routes would be created. a. Pick in WH from WH/stock to WH/packing locations and b. Pick in WH2 from WH2/Stock to WH2/packing. The 1st operation Pick in WH can be cancelled. Subsequent routes would be created based on the destination locations selected. In practice the product route could be WH2/Stock -> WH2/Packing -> Wh2/Output -> Customer as well

Here is an example of a sale

In the above example, route was as asked in your post.

Please do treat this above as a proof of concept and not a final solution which would I believe need to be specific to your business circumstances.

0
Avatar
Discard
Avatar
Pablo Perugini
Author Best Answer

Exactly, for example, if I create a sales order for 10 units and there are 5 in warehouse A and 2 in warehouse B, I would like a picking order to be generated for 8 units in A and another for 2 units in B. Then, when processing the 5 units from A, a backorder for 3 units would be generated.

0
Avatar
Discard
Jaideep

The demand qty on an operation can be modified by unlocking. This option is available in the action menu -- (gear icon top left on the operation)

In your example above 2 pick operation is triggered with demand qty 10 in WH1 and demand 5 in WH2. Unlock these 2 operations and modify demand to 8 in WHA and 2 in WHB

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
MO Pick BOM Components Issue
routes
Avatar
0
May 25
1674
Route for 2 product lines
routes
Avatar
Avatar
1
Jul 24
2373
Dynamic Domain for states
domain_filter
Avatar
Avatar
1
May 24
3425
Odoo v16 domain, how to create a domain by user.company_id
domain_filter
Avatar
Avatar
1
Nov 22
6044
Filtering domain
domain_filter
Avatar
Avatar
2
Jul 22
4540
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now