Skip to Content

Welcome!

Share and discuss the best content and new marketing ideas, build your professional profile and become a better marketer together.

Sign up

You need to be registered to interact with the community.
All Posts People Badges
About this forum
This question has been flagged
1 Reply
44 Views
Avatar
Shravya Shetty

I have a sales order with the following items:

  • Item 1 → Qty: 10.7 → Price: $297.45 → Line Total: $3,182.72
  • Item 2 → Qty: 11.5 → Price: $146.65 → Line Total: $1,686.48
  • Order Total: $4,869.19

When I add the line totals ($3,182.72 + $1,686.48), I get $4,869.20, but the order total shows as $4,869.19. This will cause confusion for customers on invoices and for sales reps when entering orders. Is this a bug from not rounding the line items before calculating the total? I notice the margin shows $4,869.20, so it's correct there but not at the total level. I'm new to Odoo, was this how it worked in previous versions, or is this a bug in version 19?

Thanks for your help!

Avatar
Discard
Avatar
Manoj Chauhan

There are two different methods for arriving at the total amount, one rounds the lines then adds, the other adds the unrounded totals, then rounds.

The margin is actually using the less accurate method, the Sales Order total is more accurate:

Line 1 (unrounded): 10.7 × 297.45 = $3,182.715

Line 2 (unrounded): 11.5 × 146.65 = $1,686.475

Total: $3,182.715 + $1,686.475 = $4,869.19


Odoo is using this more accurate method to avoid "rounding-on-rounding" errors.   This method is standard practice in financial software because it is more accurate.

Avatar
Discard

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!