Re: [mv] salestax included in total

[Hans-Joachim Leidinger <hans-joachim.leidinger@home.gelsen-net.de>]

Frank Miedreich wrote:
> 
> Der Rechnungsbetrag von [total-cost] enthält die gesetzliche MwSt. von
> 16% in Höhe von
> [currency][calc][total-cost noformat=1]/1.16*0.16[/calc][/currency]
> 
> Addtl. info for the rest of the list:
> 
> I am not using sales-tax in the example, as I am currently thinking about
> adjusting the minivend taxing scheme to German (and I think many European)
> tax schemes. (This would probably work similar to the shipping calculations
> and may never be finished.)
> 
> In Germany the VAT is based on product category, with books being taxed at
> 7%, almost everything else at 16%. The same rates also apply to exports to
> other EU countries, but not to exports to other countries. The above will
> obviously fail (as in produce wrong results) with combinations of books and
> other products. The Minivend tax system is difficult to use in Germany, as
> it is illegal to use only the net price in end custumer sales. While you
> may show the net price, the price including taxes has to be the one most
> prominently displayed.
> 
> This is often done wrong (e.g. http://www.apple.com/germanstore/), but I
> have not yet found a satisfying solution.
> 
> Cheers Frank
> 

I use an extra database field like e.g. "tax" and check this field 

[if explicit]
[condition]
$dummy = '[item-field tax]';
return 1 if $dummy =~ /MWSTKZ2/;
return 0;
[/condition]
[perl arg=scratch]
$a = $Safe{'scratch'}->{'mwst'};
$b = [discount-price noformat]*[item-quantity]/116*16;
$c = $a + $b;
$Safe{'scratch'}->{'mwst'} = $c;
return "";
[/perl]
[else]
[perl arg=scratch]
$a = $Safe{'scratch'}->{'mwst'};
$b = [discount-price noformat]*[item-quantity]/107*7;
$c = $a + $b;
$Safe{'scratch'}->{'mwst'} = $c;
return "";
[/perl]
[/else]
[/if]

In a german bookstore, all books being taxed at 7%. But some items e.g.
Software being taxed at 16%. If this few items has 
16%, i write "MWSTKZ2" into the products.asc (field tax). It is simple
to calculate tax for each items. The above code calculate the total of
tax (stored in the scratch variable "mwst").

Cheers

Joachim


-- 
-------------Hans-Joachim Leidinger---------------------