This question has been flagged
1 Reply
4827 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

Avatar
Discard
Best Answer

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.

Avatar
Discard
Author

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.

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.