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
    • Artificial Intelligence
    • 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
    • Property 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
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

Buggy replenishment report

Subscribe

Get notified when there's activity on this post

This question has been flagged
transferroutesReorderingRulereplenishmentodoo18
1 Reply
1182 Views
Avatar
labmotionsystems, jef uytterhoeven

Hi All, 

We have ben having a lot of issues with our replenishment report. And I already fixed A few things. 
However the following problem seems a little more like a bug in odoo18. 


the picture we have 2 reasons for buying stock.

  • 1 is for serial manufacturing this should be ordered via the replenishment report.
  • 2 is custom projects we want to keep this stock completly seperate from the serial manufacturing. And buy these by just creating PO's

So I created the following location setup

WH/input → for receiving all goods

WH/cages → This is for the custom projects. Each project gets there own cage here

WH/inventory/stock → all goods for manufacturing should go here after passing by wh/input

WH/inventory/... has other locations like pre-production and production.


All my reordering rules look wat WH/inventory so input and the cages are excluded.

Now my problem is that when I create a RFQ/PO from the order button in the replenishment rapport it creates the stock transfers to get it to the correct location from that PO. However when I change the PO or cancel the PO it will ignore the already created transfers. Resulting in that they just stay open indefinetly. But these also mess with the reordering rules since odoo still thinks those are comming from input to stock.


In my opinion odoo should update those transfers when the PO that was created because of these transfers has changed.

0
Avatar
Discard
Avatar
Jainesh Shah(Aktiv Software)
Best Answer

Hi labmotionsystems, jef uytterhoeven


When you confirm a PO from the replenishment report, Odoo creates a chained stock transfer:


Vendor → WH/Input → WH/Inventory/Stock

 

These two transfers are linked via a procurement group. However when you modify or cancel the PO afterwards, Odoo only updates or cancels the first transfer (Vendor → WH/Input) and leaves the second transfer (WH/Input → WH/Inventory/Stock) untouched and open.

This causes two problems exactly as you described:

  • The open transfers pile up indefinitely and clutter your operations
  • The reordering rules still count those open transfers as incoming supply, so replenishment thinks stock is on its way when it is not
Fix 1 — Change the Route to Use a Single Step Reception

Consider changing the route for manufacturing replenishment to receive directly into WH/Inventory/Stock instead of going through WH/Input. This eliminates the chained transfer entirely and means the PO receipt goes straight to the correct location:

Vendor → WH/Inventory/Stock  (single step, no intermediate transfer)

 

Go to Inventory → Configuration → Warehouses and set incoming shipments to Receive goods directly for the manufacturing route. You can keep the two-step route only for the cage/project flow.

Fix 2 — Add a Server Action to Automate the Cleanup

Create an automated action that cancels downstream transfers when a PO is cancelled: 

Plain Text

# Automated Action on purchase.order # Trigger: When record is updated # Before update filter: state != 'cancel' # Filter: state = 'cancel'  for order in records:     domain = [         ('origin', 'like', order.name),         ('state', 'in', ['confirmed', 'assigned', 'waiting']),         ('location_dest_id.complete_name', 'ilike', 'WH/Inventory')     ]     transfers = env['stock.picking'].search(domain)     transfers.action_cancel()

 

This automatically cancels any open internal transfers going to WH/Inventory when the originating PO is cancelled.

Fix 3 — Cancel Downstream Transfers Manually When Cancelling a PO

When you cancel or significantly change a PO:

  1. Open the PO and note the Source Document reference
  2. Go to Inventory → Operations → Transfers
  3. Filter by Source Document matching your PO reference
  4. Cancel all transfers that are still in Ready or Waiting state

This clears the queue and lets the reordering rules recalculate correctly.

 

If you have any questions, feel free to reach out.

Hope this helps!

 

Thanks and Regards,

Email: odoo@aktivsoftware.com

0
Avatar
Discard
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
Odoo 18 replenishment rules
routes replenishment odoo18 Reordering
Avatar
Avatar
1
Mar 26
1186
Negative Forecasted items not appearing for Replenishment Solved
ReorderingRule replenishment
Avatar
Avatar
1
Feb 25
5677
No rule has been found to replenish XXXX Verify the routes configuration on the product.
routes ReorderingRule
Avatar
Avatar
2
Aug 25
14674
1 product 2 sources replenishment rule
ReorderingRule replenishment
Avatar
0
Mar 23
2601
Visibility Days not functioning as documented in Replenishment Solved
ReorderingRule replenishment visibilitydays
Avatar
Avatar
2
Jul 25
4275
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 Svenska ภาษาไทย 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