VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: sohopros on March 16, 2017, 17:09:52 PM

Title: 2 taxes per product
Post by: sohopros on March 16, 2017, 17:09:52 PM
Hi,

Some of our Users should pay 2 taxes. For example Tax1 = 21% and Tax2 = 5.2%.

1. We have created 2 shopper groups:
1.1 One shopper group "Default" pay taxes = tax1= 21%
1.2. other Shopper group "Additional-tax" Pay taxes  = tax2 = 5.2%

2. We created 2 Tax rules.
2.1. Tax rule Tax1 = 21%. Added shopper group "Default"
2.2. tax rule Tax2 = 5.2 %. Added shopper group "Additional-tax"

3. Creates User test1 = added to this user shopper groups "Default" and "Additional-tax".

4. TEST:
Added product to the cart and see following
4.1 Product Price before tax = 20.60 Euro
4.2. Tax price =  5.62 Euro
4.3. Discount = 0.22 Euro
4.4 Total = 26.22 Euro.

test1 user should pay taxes  = 26.2 (21+5.2) = 20.60 Euro  = 5.4 Euro of taxes.
If we will calculate Total price is correct. ( 20.60 Product price + Tax Price - Discount = Total)

But why it is showing in discount, not in correct Taxes? How we can change it?

Please advise,
Sandra


Title: Re: 2 taxes per product
Post by: jjk on March 16, 2017, 19:18:14 PM
Which VirtueMart version?
Title: Re: 2 taxes per product
Post by: sohopros on March 16, 2017, 19:19:24 PM
Sorry Virtuemart 3.0.18. Joomla 3.6.5. PHP 5.6.30

Thanks,
Sandra
Title: Re: 2 taxes per product
Post by: jjk on March 16, 2017, 22:22:53 PM
1. In which cases do customers have to pay the 5.2 percent tax? Does it depend on their location?
2. Which types of tax do you use for each of the two tax rules in the 'Tax and Calculation Rules' setting?
Title: Re: 2 taxes per product
Post by: sohopros on March 17, 2017, 19:05:22 PM
1. In which cases do customers have to pay the 5.2 percent tax? Does it depend on their location?
Depends on what Shipper group they are.
2. Which types of tax do you use for each of the two tax rules in the 'Tax and Calculation Rules' setting?
Vat Tax per product.

Thanks,
Sandra

Title: Re: 2 taxes per product
Post by: jjk on March 17, 2017, 23:20:37 PM
Tried to reproduce your tax configuration, but can't get it to work at present. Probably you will have to combine the two taxes into a single tax and then assign only the first or the second (combined) tax to a shopper group.

However, which tax is 5.2 percent only for certain people in Portugal? Sounds very unusual for an EU country.
Title: Re: 2 taxes per product
Post by: sohopros on July 09, 2018, 16:59:28 PM
Hi,

Our customer still needs to implementation when User pay 2 taxes. And combining 2 taxes into one is not correct for the customer. Is there any other way? Maybe you implemented new features?

Please advise,
Sandra
Title: Re: 2 taxes per product
Post by: Studio 42 on July 09, 2018, 18:57:10 PM
I think that you have to use 2 tax type to solve the problem.
But if you set 2 shopper groups, the first tax is applied and not the second one.
If you add tax to 2 shoppergroups, then this get applied for  the tow shopper groups.
Try to use type = VatTax for the main tax and TaxBill for the second tax should work, but only in the bill.
Title: Re: 2 taxes per product
Post by: jjk on July 09, 2018, 20:30:12 PM
Quote from: sohopros on July 09, 2018, 16:59:28 PM
Is there any other way? Maybe you implemented new features?

Maybe somebody here knows a solution if you let us know which country the shop (your customer) is located in and what the names/types of the two taxes are.
Title: Re: 2 taxes per product
Post by: sohopros on July 10, 2018, 13:34:05 PM
Hi,

Quote from: Studio 42 on July 09, 2018, 18:57:10 PM
I think that you have to use 2 tax type to solve the problem.
But if you set 2 shopper groups, the first tax is applied and not the second one.
If you add tax to 2 shoppergroups, then this get applied for  the tow shopper groups.
Try to use type = VatTax for the main tax and TaxBill for the second tax should work, but only in the bill.


1. Created New Shopper group. This new Shopper group only pay 5.2%  taxes
2. Created New BillTax and assigned this New BillTax to New created shopper group.
3. Added to the user New Shopper group.

User pay 21% VAt Tax and 5.2% Bill Tax

Results in Card:
Product price + 21% Vat Tax =  ProductPrice1
ProductPrice1 + 5.2% Bill Tax = FinalProductPrice.

Expected Value:
Product Price + 21%VatTax = ProductPrice1
Product Price + 5.2%Bill TAx = FinalProduct Price

Attached Screenhsots for explanation

How can I calculate BillTax from Original Product Price, not from The product price + 21%VatTax?

Please advise,
Sandra

Title: Re: 2 taxes per product
Post by: Studio 42 on July 10, 2018, 15:29:03 PM
YOu can get the difference from the taxed price.
If you have always tax 21% in product then
5.2%Bill TAx = 5.2/1.21 = 4.29752066115703 %
4.29752066115703 is the tax percent value to apply, but i think that 4.29752 should be right
Title: Re: 2 taxes per product
Post by: jjk on July 10, 2018, 16:24:58 PM
@Studio 42
Apparently Sandra is trying to implement a special spanish VAT (IVA) system known as 'recargo de equivalencia — RDE'
https://infoautonomos.eleconomista.es/fiscalidad/recargo-de-equivalencia/ (https://infoautonomos.eleconomista.es/fiscalidad/recargo-de-equivalencia/) (Use Google for translation of the link)
I didn't know that something like this still exists in an EU country.
I think in this case ideally the VM cart and invoice should display the net amount plus the IVA and RDE values and the total for customers in the 'RDE Customer' shopper group.
Title: Re: 2 taxes per product
Post by: Studio 42 on July 10, 2018, 19:33:02 PM
jjk, i think that wit the percent 4.29752 aplyed to the 21%+ base price, the total is right and the tax display 5.2% of the product.
Title: Re: 2 taxes per product
Post by: sohopros on July 20, 2018, 08:39:06 AM
Hi Again,

Quote from: Studio 42 on July 10, 2018, 19:33:02 PM
jjk, i think that wit the percent 4.29752 aplyed to the 21%+ base price, the total is right and the tax display 5.2% of the product.
and

Quote from: Studio 42 on July 10, 2018, 15:29:03 PM
YOu can get the difference from the taxed price.
If you have always tax 21% in product then
5.2%Bill TAx = 5.2/1.21 = 4.29752066115703 %
4.29752066115703 is the tax percent value to apply, but i think that 4.29752 should be right

The customer told that we also need to apply the same taxes 21% and 5.2% for Shipping. I created a separate forum here: http://forum.virtuemart.net/index.php?topic=140528.0

Maybe you know how to apply the same rule to shipping?


Thanks for your help,
Sandra
Title: Re: 2 taxes per product
Post by: sohopros on July 24, 2018, 15:58:33 PM
Hi,

Any advice on how you apply two taxes for the shipping?

Thanks,
Sandra
Title: Re: 2 taxes per product
Post by: Studio 42 on July 24, 2018, 20:36:43 PM
merge the 2 taxes and use 2 shipping methods, each for one case (wtih 1 or 2 taxes)
Title: Re: 2 taxes per product
Post by: sohopros on July 24, 2018, 23:52:43 PM
Hi,
That would yield the correct total, but the two taxes are supposed to show up as separate line items on the invoice. If we merge them, won't they appear on the same line/field?  If so, is there a way to keep them separate and still apply the shipping fees to both taxable amounts?