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

Credit Note Price based on the lot Number sold to customer during return

Subscribe

Get notified when there's activity on this post

This question has been flagged
priceLots/SerialOdoo18.0credit note
1 Reply
327 Views
Avatar
Tenth Planet

Here is the one scenario one of our customer facing

One of customer as a Manufacturer produces Butter cookies as product. They sell it to Distributor on different periods with different expiry date. Distributor sell this product to different retailers.

When that product not fully sold within the expiry date, retailer returns the product to Distributor without mentioning any Lot number or any reference number

Distributor collects returned products from different retailers and return the same to Manufacturer.

Manufacturer receives goods from Distributor without any previous invoice references. But the Manufacturer needs to accept the return and raise the credit Notes. Since return as no previous references and returned products comes from different invoices,  Credit note creation to be done manually without any old invoice reference. In this situation, Manufacturer needs to select the Lot Serial Number/expiry date in invoice (Which is not available in credit note) so that the they know on which cost they sold to distributor, the price can be set accordingly in credit note.


How do we handle this scenario in odoo? Please suggest if there any solution or workaround possible in odoo

0
Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,


By default, Odoo does not fully support this process. While you can manually create a credit note without referencing an existing invoice, Odoo does not allow linking a lot or serial number directly to invoice lines. Also, the system cannot automatically fetch the product cost based on the lot, as lot traceability is handled at the stock movement level rather than the accounting level.


To address this, the recommended approach is to extend the account.move.line model by adding a field for selecting the lot or serial number and configuring logic to auto-populate the cost price based on that lot. When the credit note is validated, the system can automatically generate a corresponding return picking, ensuring both accounting and stock are synchronized. This allows accurate cost and lot tracking for the returned goods.


If customization is not an option, the workaround is to manually create credit notes and separately record the lot numbers in notes or text fields. The manufacturer can then manually adjust the pricing and process a stock return through the inventory module. Alternatively, there are third-party Odoo apps available that enable lot or serial number selection in credit notes and automate product cost fetching, offering a more streamlined solution for managing such returns.


Hope it helps

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
Only the department manager can modify their team members' information.
Odoo18.0
Avatar
Avatar
1
Nov 25
345
Problem with tax included price Solved
price
Avatar
1
Jun 23
243
With odoo 16 what are the prices for iot box?
price
Avatar
Avatar
1
Dec 22
4716
Sales Unit Price Solved
price
Avatar
Avatar
1
Jan 22
3146
How to hide out of stock or expired lots from selecting list in DN or MO
Lots/Serial
Avatar
Avatar
2
Sep 21
3844
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