İçereği Atla
Bu soru işaretlendi
invoicevaluestaxpricechange
1 Cevapla
6101 Görünümler
Avatar
evon_dun

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
Vazgeç
Avatar
Nehal
En İyi Yanıt

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
Vazgeç
evon_dun
Üretici

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.

Nehal

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.

İlgili Gönderiler Cevaplar Görünümler Aktivite
Difference in subtotal and base amount for taxes in invoice?
v6.1 invoice values tax change
Avatar
0
Mar 15
5706
Is there a bug while calculating subtotal for a line with an included tax?
values tax price 6.1 included
Avatar
0
Mar 15
4349
How to automatically add a fixed amount to the invoice?
invoice tax
Avatar
Avatar
Avatar
Avatar
4
Mar 15
11304
How do I make the taxes visible on the website?
tax price website
Avatar
Avatar
1
Tem 25
1216
TAX 15% Çözüldü
invoice tax quotation
Avatar
Avatar
1
Nis 24
2699