In supplier invoice. I want to calculate withholding taxes from base price. example:
- supplier base price = 100 (from supplier document)
- vat(7%) = 7 (my company doesn't have to pay this)
- my company base price = 107 (when key in supplier invoice form)
- withholding taxes(3%) = 3 (from supplier base price or (my company base price -(my company base price*7/107)
The problem is my company does not have to pay vat. so the result should be 100 + 7 - 3 = 104. So This formula shoude be (my company base price)-(supplier base price * 3%) = result. Someone please tell me how to set taxes in this situation. Additional, I saw taxes type can use python code but i don't know how to set it. Thanks.
I would be interested in this as well. I am trying to find something in 7.0 to be able to configure the two different kind of taxes (withholding and vat) to show in two seperate lines in the invoices (in the sum on the bottom) but so far I can only get it all sumarised as VAT...
My temporary solution is to create a separate product named withholding tax and calculate it manualy... (needless to say, not a very good solution...)
I've have the same issue about withholding.
We have the same problem. Did you managed to solved this??