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!
Thanks for the answer, I figured it was something like this. I did learn I could change the accounting tax setting "Rounded Method" to "Round per Line" and it will make it behave in a manner that matches the Order Total to the Total of the Extend lines that show. Not sure if this is the solution, but I did make the totals match as expected. We are still learning, so thanks for the help!
Any Customer who is using a "good" system to enter the order into THEIR sofware will likely ask you why you are charging them more than you should be, since their system will probably use the more accurate method.
Unless legally required NOT TO, you should always perform all calculations with full precision and only round the very last number that the Customer has to pay.