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.
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.
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
|Asked: 3/5/14, 3:35 AM|
|Seen: 1289 times|
|Last updated: 3/16/15, 8:10 AM|