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 generate an invoice for the subscription until the first fixed renewal date (prorate / partial)

Subscribe

Get notified when there's activity on this post

This question has been flagged
subscriptionSubscriptions
2 Replies
5350 Views
Avatar
Erik

Dear Odoo Community,

We are currently facing a challenge regarding Odoo 16 Subscription.

Imagine we have a subscription product that renews annually, and we want all subscriptions to be renewed on January 1st. Now, let's say we sell these subscriptions throughout the year. For instance, if we sell a contract on November 1st, we would like to invoice the customer a prorated / partial amount for the service for November and December. Then, on January 1st, we want to invoice them for the entire year.

How would you suggest solving this challenge?

0
Avatar
Discard
Patrick Presto

Also interested in a solution to this; we'll be facing a similar challenge with subscription products that essentially require a pro-rated period for the initial invoice.

Many of our subscription services are billed quarterly but we follow the calendar quarters for billing. So if we sell and activate a subscription on January 20th, we need the first invoice to be pro-rated to reflect January 20th - March 31st to satisfy Q1, then on April 1st, Q2 invoice is invoiced for the full quarter.

bla@apik.cloud

Hi Ray,

Could you tell me if the discount (fisrt bill prorata) is auto calculated by Odoo directly or user should do it manually ?

Avatar
Ray Carnes (ray)
Best Answer

Use the UPSELL feature for this.  Also works the same way for Odoo 17.


Example Product:



Create the Subscription Sales Order, confirm it, then change the Date of Next Invoice:



Note: At this point, you need to change the Quantity on the Sales Order to 0, because Odoo will automatically increment it when you use the Upsell feature:


Click Upsell:


This creates a Quotation with a pro-rated amount based on the difference, with a discount automatically calculated for the correct percentage:

Once this is confirmed, change the Quantity to 1


You can then Invoice your Customer for the partial amount due this quarter.

In this case, they are getting a discount (automatically calculated by Odoo) for the first 25 days of the quarter they didn't receive the service - 25/[31+29+31] = 27.47%.


Invoice:


You can check that the quantity on the original subscription Sales Order is 1 (incremented automatically from 0 by Odoo when you created the upsell) because you are going to invoice 1 full subscription at the start of the following month.


2
Avatar
Discard
Patrick Presto

Thank you Ray; I will test this in my database to verify the workflow.

I appreciate the details and screenshots!

Philippe TOURNOIS

Thank you so much !!! I was blocked on this problem for several days and the official documentation is seriously laking about it. But in fact, it's so simple. Works perfectly on v17

Isaías Dávila Delgado

Hola Ray, mi problema es que a la hora de intentar hacer esto me aparece un mensaje de error que dice: "No se puede realizar una venta adicional o una renovación para una suscripción que aún no se ha facturado. Actualice directamente el contrato **** o factúrelo primero". El problema es que yo no quiero todavía generar la factura del primer periodo completo de la suscripción, sino que primero tendría que factura el periodo prorrateado. ¿A qué puede deberse? Gracias de antemano

Ray Carnes (ray)

I have repeated the steps and they work without the error you mention, please open a ticket with Odoo Supports so they can help you.

Avatar
EWall Solutions
Best Answer

Hi Erik,

Yes with this custom Odoo Subscription application, https://apps.odoo.com/apps/modules/16.0/ewall_subscription/ 

You can create & map the same product for different subscription periods/journal entries and then you can be able to bill the customers for the period of November and December as you mentioned above, and then bill for the annual subscription on January! 


Please let us know if this solves your issue! And if you have any further requirements then we can customize the same module regarding the business needs! You can contact support@ewallsolutions.com for specific requirements



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
How to set up annual subscriptions
sales subscription Subscriptions
Avatar
Avatar
Avatar
2
Jun 24
3337
Unable to add to cart Subscription product even the cart is empty
Subscriptions
Avatar
Avatar
Avatar
Avatar
3
Sep 25
829
How do I transfer my subscription from the old database to the new one? Solved
subscription
Avatar
Avatar
1
Jun 25
1747
Subscription scam Solved
subscription
Avatar
Avatar
1
Apr 25
3282
This combination does not exist.
subscription
Avatar
Avatar
Avatar
2
Feb 25
5746
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