Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Is there a bug while calculating subtotal for a line with an included tax?

By
evon_dun
on 3/5/14, 3:35 AM 1,335 views

I have been wondering why OpenERP showing wrong subtotal amount and hence the base amount for tax calculation where the taxes are included in price. Please have a look on the data:

Unit Price: 250
Qty: 20
Tax: 13.5% (included in price)
Subtotal: 4405.29, where it should be 4325

This difference increases as the quantity increases and the correct amount deviates hugely to what it should be. Anyone who went through such issue, please help.

C:\fakepath\Untitled.png

-1

Nehal

--Nehal--
2090
| 5 2 8
Ahmadabad, India
--Nehal--
Nehal
On 3/5/14, 5:49 AM

Hi,

This is not a bug and not displaying wrong calculation.

Unit Price : 250
Qty : 20 Tax : 13.5 Subtotal shows you amount excluding tax In your case calculation would be like below: (250*20) = 5000 (113.5% = 100+13.5) Subtotal = (5000 * 100) / 113.5 = 4405.29

Hope this explains the issue.

Hi, as per your answer I checked and feel that you are right but my trouble is that the base amount changes in the taxes table. I attached here an image file and highlighted the problem with red circles. Please have a look and comment if you can figure it out.

evon_dun
on 3/6/14, 2:42 AM

This may be a bug for the version(you might be using versin 6.1). You may post it on launchpad if this issue occurs for all invoices in your case.

Nehal
on 3/6/14, 3:44 AM

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!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 3/5/14, 3:35 AM
Seen: 1335 times
Last updated: 3/16/15, 8:10 AM