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.

1

Tax calculation Problem in Purchase order Screen

By
HappyOdoo
on 5/18/15, 5:18 AM 691 views

hi all,

when I apply Tax for Purchase order Product.It display wrong calculation.

I have applied Excise 12% + VAT 5%.

Example:

Product Sub total is 1000

Excise 12 %

Vat      5 %

Total Tax  Value  :  173.60 correct value(179.78)

Amount With Tax:1173.60  correct value(1179.78)

How can I solve This Problem.

Please explain your calculation how u received this values.

Zura Tsiklauri
on 5/19/15, 6:06 AM
Hi zura,

As per my Indian accounting rules. I have apply 1st excise tax + 2nd.
service tax.

Let's take one example.
Price subtotal is 1000.
Excise is 12.50 %
Service tax is 5%.

As per the Indian accounting  rule first 12.50 is apply on 1000.
So,
1000*0.1250=125
1000+125=1125

now service tax is apply 5%. 1125 * 0.05=56.25

1000+125+56.25=1181.25
Total Tax=125+56.25=181.25
Total With Tax= 1181.25

But Openerp Display Wrong Fig.
Total Tax=175
Total With Tax=1000+175=1175

if more info required please tell me.
HappyOdoo
on 5/20/15, 12:49 PM
Hi Hiral,

I have already set this type of configuration. your answer is helpful
for me to improve my knowledge.
thanks dear.

On 5/21/15, Jeel Khanpara <jbk261292@gmail.com> wrote:
> hi,
>
> configuration for Tax is totally right as you suggest.
>


-- 
*JEEL B. KHANPARA*
HappyOdoo
on 5/21/15, 1:09 PM
2

Hiral Patel (hip)

--Hiral Patel (hip)--
Tiny ERP Pvt Ltd
http://www.odoo.com
913
| 2 1 5
India
--Hiral Patel (hip)--


Hiral Patel (hip)
On 5/21/15, 3:36 AM

You configuration for Tax seems wrong.

Try with following:

Tax Name = Excise

Tax Type = Percentage

Value = 0.12500

Included in base amount = True


Tax Name = Vat

Tax Type = Percentage

Value = 0.05000

Included in base amount = False

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

3 follower(s)

Stats

Asked: 5/18/15, 5:18 AM
Seen: 691 times
Last updated: 8/18/15, 6:00 AM