Skip to Content
Menú
This question has been flagged
1 Respondre
5869 Vistes

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
Descartar
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
Descartar
Autor

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.

Related Posts Respostes Vistes Activitat
0
de març 15
5577
0
de març 15
4200
4
de març 15
11153
1
de jul. 25
1103
TAX 15% Solved
1
d’abr. 24
2585