SimpleVATTax

The SimpleVATTax component, which appears in the Tax stage of an order processing pipeline, calculates the Value Added Tax (VAT).

Note

The SimpleVATTax component is a simple tool for you to use to calculate tax rates. Microsoft strongly recommends that you have an independent tax professional verify all applicable tax rates and data generated by this component before you use such information for personal or business purposes.

Remarks

SimpleVATTax always sets _tax_total name/value pairs to zero (0) for both the item and the order. The component does not handle fractions of currency units; all calculations are rounded to the nearest whole unit.

The combination of the Key, Apply when, and Country fields determine whether tax should be applied.

The SimpleVATTax component first checks the Apply when value. If it is set to Always, the tax is always applied to the order. If Apply when is set to Has any value, the tax is applied to the order whenever the order form contains any value for ship_to_country. If Apply when is set to Equal to Country, the component does a comparison between the value of ship_to_country on the order form and the text string in the Country field on this property page. If there is a match, the component applies the tax whose value is stored in the field specified in Rate Item Key.

Example

To specify that a VAT tax rate of 6.5% is charged for an item in Germany, do the following:

  1. Add a column for the VAT rate in Germany to your product table. The tax rate should be specified as a real number:
    ger_vat_tax_rate   real  NOT NULL
    
  2. Assign tax rates to each product in your product table using an SQL script. For this example, assign the 6.5% VAT rate to Product ABC. Type 6.5 into the ger_vat_tax_rate column in the Product ABC row.
    1. Double-click the SimpleVATTax icon in the Win32-based Pipeline Editor, or click the Edit link for the component in the ASP-based Pipeline Editor and enter the following in the resulting property page.
Field Value
Apply when Always
Country GER
Rate Item Key _product_get_vat_tax_rate

If the customer types a country on the OrderForm that is not specified in the SimpleVATTax component configuration, the values of the _tax_total and _tax_included name/value pairs on the order and on the items will not be set.

Related Topics


© 1997-1998 Microsoft Corporation. All rights reserved.