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

How to deal with returnable products or "consignes" in Odoo ? V14

Subscribe

Get notified when there's activity on this post

This question has been flagged
inventorytaxesreturnsquickstartPoint Of Sale
1 Reply
6883 Views
Avatar
Hadrien Meulders (hms)

V14

Explanation of the flow:

Example of returnable beer bottles (33cl) :        

  • The supplier sells beers with an extra price of 50 cents on each bottle, refundable if the empty bottle is returned to him.        
  • The end customer pays the same 50 cents extra price on each beer sold for the bottle.     
  • The customer get the 50 cents back for each bottle he brings back to the points of sale accepting the empty bottles.    
  • There is a stock of empty bottles to hold, to be returned to the supplier and get refunded the same amount per bottle.       
  • The amount is fixed per bottle type (33cl, 75cl,...). 
  •  Not tax to apply on this amount.

  • How to create this flow and use it in Odoo ?   

5
Avatar
Discard
Avatar
Hadrien Meulders (hms)
Author Best Answer

The solution proposed here will use a fake tax to solve the problem.        

Important facts to keep in mind:        

  • The bottle itself does not exist in the stock when filled with beer. We do not want to have two products (bottle and beer 33cl) to sell to the consumers.
  • The empty bottle only exists in the stock when the customer brings it back and follow a reversed flow (End consumer > MyCompany > Supplier).
  • You cannot use products without price but with a tax only in the POS app (even if it is a fixed tax and not a percentage one). E.g. empty bottle => sales price = 0, tax = 0,50 euros.
Normal flow (Supplier > MyCompany > End customer)

  • The bottle and the beer are one single product
  • The extra price for the bottle is not an income, but a debt owed to the final customer (and also a debt my supplier owes to my company).
Solution :     

Add a tax to my product 

=> Tax computation = Fixed

=>Set an amount

=> Add the account on which the debt / receivable must be recorded. 

=> Advanced options (on tax form) > Add label on invoice (e.g. "Consigne")

=> If you want your fake tax to be displayed in another section than the main tax ligne (above total): Advanced options (on tax form) > Tax Group, create "Consigne" (e.g. "Consigne")


In this example, I have a receivable account set for any purchase I do so the tax of my bottle is recorded in here. The same principle is applied on my sales tax, with a debt account. 

Reversed flow:

  • Empty bottles to refund to the customer
  • Stock of empty bottles to hold
  • Empty bottles to be sent to the supplier in order to get the refund.
In the POS, when a returnable product come back, I create a negative order line (can be part of a normal order, or only the bottles to refund). 
  • My product "empty bottle" is defined as follow :
  • Sales price : 0,50    
  • Cost : 0,50    
  • Tax : 0% (a 0% tax has to be set. If no tax is set, Odoo will use the default tax in invoicing, e.g. 20%.)    
  • Accounting, you can use the same income and expense accounts as the ones used for the tax in the normal flow. (to be set on the product or product category if you have a specific one for your returnable products). 

The flow starts when the customer returns products to the point of sale.A negative line is added to the order. The refund can be done in cash or, if your terminal allows it, through a credit operation.

The empty bottles are then in the stock and can be returned to the supplier (credit notes can be useful for the refund from the supplier).

6
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
POS: What is the configuration “inventory: real time vs at closing of the session” and how to use it? Solved
pos inventory quickstart Point Of Sale
Avatar
1
Feb 22
5545
How to manage Inventory Valuation and Credit note journal entries when doing a return? Solved
accounting inventory returns quickstart creditnotes
Avatar
1
Dec 24
7536
Using MTO and Dropshipping in a Single Sales Order in Odoo
inventory quickstart
Avatar
Avatar
2
Apr 25
2526
2 companies => one warehouse (inter-company and Dropship) Solved
inventory quickstart
Avatar
1
Aug 24
3920
Cancel a transfer after it's done Solved
inventory quickstart
Avatar
3
Mar 24
7553
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