VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: icinfo on January 16, 2012, 12:08:56 PM

Title: VM 2.0 Discount before TAX calculations, is it possible?
Post by: icinfo on January 16, 2012, 12:08:56 PM
Hi,

I'm trying to make the price to show the following with the new VM2:

Base price 123€ (includes 100€ + 23% tax)
Sales price 110€
Reduction 13€
Real Tax for the customer counted from 110€ (price that customer actually pays) 20,57€ (not 23€ since 23% is from the Base price before discount

I cannot get the tax calculations correctly but the tax stays the same no matter if the customer pays 123€ (price without discount) or 110€ (price with discount). This is not correct since tax is not paid of the original price but only of the price that customer actually pays. I have tried different settings but cannot figure out how to get the tax show correctly from the Sales price not from the base price.

Here is how it looks like now:
http://virtuemart2.shop1.internet-content.net/virtuemart/powertools/circular-saw-detail (http://virtuemart2.shop1.internet-content.net/virtuemart/powertools/circular-saw-detail)

Can someone explain how do I get the tax show the correct tax from the discount price and still show the baseprice with tax as well? Or is this not possible in the new VM2?

The hole price issue has been a problem in the old VM1.0. Shops today must be able to show the following fields:

Base Price (normal price + tax%)
Discounted price (normal price + tax - discount)
Discount
Real tax (tax from discounted price)

Amy
Title: Re: VM 2.0 Discount before TAX calculations, is it possible?
Post by: Milbo on January 16, 2012, 12:40:02 PM
Use DBTax and not DATax (DB = discount Before tax). Should work exactly as you wish.
Title: Re: VM 2.0 Discount before TAX calculations, is it possible?
Post by: icinfo on January 16, 2012, 13:02:10 PM
Hi,

when I change to DATax then I don't get the discount amount right:

http://virtuemart2.shop1.internet-content.net/virtuemart/powertools/circular-saw-detail (http://virtuemart2.shop1.internet-content.net/virtuemart/powertools/circular-saw-detail)

I get the following:

Price with discount: 123,00 € (this should not be called Price with discount since this is price without discount)
Sales price: 110,00 €
Sales price without tax: 123,00 € (this should not be called price without tax since this includes tax)
Discount: -10,00 €

And tax amount is not shown at all. That is ok, but the Discount should show 13€ not 10€. This does not show correctly in my view. Am I still missing something?

Amy
Title: Re: VM 2.0 Discount before TAX calculations, is it possible?
Post by: Milbo on January 16, 2012, 18:31:26 PM
I would like to take a look on your BE, if possible, please write a pn.
Title: Re: VM 2.0 Discount before TAX calculations, is it possible?
Post by: jjk on January 16, 2012, 20:47:05 PM
I think at present this is only possible if you set the Discount to:

Type of Arithmetic Operation: Price modifier before tax (DBTax)
Value: 10.57 (the net amout of the  €13 discount)

Otherwise you get either the discount or the tax correct, but not both.
See screenshot below (ignore the €0.01 difference - that's because of my profit margin setup)



[attachment cleanup by admin]
Title: VM 2.0 Discount before TAX calculations, is it possible?
Post by: icinfo on January 17, 2012, 10:41:29 AM
Hi,

I have now both regular tax 23% with DBTax and discount also with DBTax. Still I cannot get the prices correct on the frontend. The tax does not show on frontend and the price with tax shows as "Sales price without tax".

Sales price: 110,00 €
Sales price without tax: 123,00 €
Discount: 13,00 €

http://virtuemart2.shop1.internet-content.net/virtuemart/powertools/circular-saw-detail (http://virtuemart2.shop1.internet-content.net/virtuemart/powertools/circular-saw-detail)

There must be still something I'm doing wrong in the backend since tax is not showing correctly. The prices are otherwise correct (except the wrong label "Sales price without tax". Is there any tutorial how to set the taxes and discounts in the new VM2?

Amy

Title: VM 2.0 Discount before TAX calculations, is it possible?
Post by: icinfo on January 19, 2012, 11:32:10 AM
I just cannot get the prices working. I cannot add tax to the product unless I have the tax defined as Per Product. If I have the taxes as DBTax (Price modifier before tax) then it is shown only on discount rules options not in the tax options on product page (see the image).

Only way I can get the some tax rules to show on the Pricing rules overrides in Tax options is that I have the Tax defines as Per Product (not as I need it Price modifier before tax). If I use this Per product option for taxes then I cannot get the tax correct if I have discount since that must reduce the tax amount.

Also what does it mean on product page when it says "Apply default rules". Where are the default rules or how are they set?

"JJK" how did you set your taxes in your price sample? Can you please send me images of both tax and discount rules and product page!

Amy










[attachment cleanup by admin]
Title: Re: VM 2.0 Discount before TAX calculations, is it possible?
Post by: dangelo on June 25, 2013, 12:41:27 PM
Have you found a solution for this?
I have the same problem too..

Price(Αξία): 0,65 €
Sales Price before tax (Τιμή πώλησης): 0,45 €
Discount Amount (Αξία έκπτωσης): 0,23 € WRONG ---> Correct is: 0,20 €