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

Advanced Supply Chain - visibility into frequently updated scheduled arrival dates of Forecasted Inventory?

Subscribe

Get notified when there's activity on this post

This question has been flagged
trackingsupply_chainadvancedforecasting
1 Reply
4956 Views
Avatar
Community Question

We have our own Manufacturing Plant in China. It takes multiple weeks, usually months, for us to receive products we order.

We update the scheduled arrival date up to 10 times between when the PO is accepted to when the Distribution Center plans the Receipt, as a result we need very granular visibility into our supply chain.

Example:
• We place a PO for multiple products at high quantities
• Factory notifies us of PO acceptance
• Factory fulfills the order based on capacity
• We receive updates like "we have X ready to ship" (a subset of the PO quantity)
• We track the shipment to the port, on the water, waiting to dock, etc
• Employees are scheduled to provide information, pay fees, arrange inspections, etc
• Once products are at the DC, we get our final date for the Receipt

In a given month, our Procurement team will be reviewing the forecast PER PO LINE ITEM.

They will need to see:
• quantity on order
• scheduled arrival date
• current step in our procurement process
• when was the scheduled arrival data last updated
• who updated it

This provides our team with a level of confidence about each scheduled arrival date - since with each step in the process the date becomes more accurate.

What is the best way to support this in Odoo?

1
Avatar
Discard
Avatar
Ray Carnes (ray)
Best Answer

You can create a new Menu to manage Forecast Updates:


Updating the Date Scheduled and Step from here gives you what you need.


How?

1. Create a Custom field for your Steps:



2. Create the new Menu using the button at the bottom of the Form view of the Stock Move model.


3. Create a Custom View and set it as the View Ref of the Window Action of that new Menu:

[Copy / Paste the XML from https://gist.github.com/ray-odoo/a21899d334dd899c4268286b999fc8b0]


4. Set the Context of the Window Action to:

{'search_default_future': 1, 'search_default_incoming': 1}


5. Create your own Custom Activities:


6. Create a User Defined default so all Stock Moves from your Purchase Orders start at Step 1.



Workflow:

Create a Blanket Order Purchase Agreement for your initial Products and Quantities (activate this feature in Settings if needed).

Your Inventory Forecast begins in Odoo when you place your Purchase Orders. From the Blanket Order, create a Purchase Order representing the accepted quantity and delivery date.

Our first PO will be for 50 of Widget1, 150 of Widget2 and 250 of Widget3 with Delivery Dates in July. Our second PO will be for 50 of each product with Delivery Dates in August.

Visiting our Menu, we can update the Step for the first 50 we ordered:

This screen works like a spreadsheet, click a cell to edit.

If you need to make updates to multiple PO's, Receipts or Products - you select them and use our "multi edit" feature:


Each time you update the Date Scheduled, the Forecasted Inventory Report will reflect the update and provide you with accurate information about when products can be expected as each of your Steps are completed.

To schedule Activities for those responsible for each Receipt, click the Transfer to open it and click Schedule Activity from the Chatter.


Extra Credit:

You can "pack" your products into Containers (activate Product Packagings) if you need to keep track at that level. 

HINT: This will need additional defaults in the Context dictionary for Product and Quantity to carry over to created Packagings.

3
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
Access Error on mail.message tracking_value_ids
tracking
Avatar
0
Mar 25
2194
Email Tracking
tracking
Avatar
Avatar
1
Oct 22
4312
The best way to track navigation process in Odoo and website ? Solved
tracking
Avatar
Avatar
Avatar
4
Oct 21
7701
Shipping Tracking Reference - Manual Entered
shipping tracking
Avatar
Avatar
Avatar
2
Jan 25
6268
Track Inventory Solved
inventory tracking
Avatar
Avatar
1
Sep 24
3712
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