Monthly Archives: January 2011

vTiger Links

vtiger Open Source CRM

Developers How To’s –

Vtiger wiki FR –
Vtiger CRM – Vtigerservices :: Vtiger CRM & gestion de la relation client
Vtiger Tutorial – Vtiger Emails
vtigerCRM-Spain Wiki 

vtlibrelated [vtigerCRM-Spain Wiki]

TSolucio, Consultoria Informática – Software libre
CRM – vtiger Open Source CRM – vtiger CRM Outlook Plugin
CRM – vtiger Open Source CRM – MS Excel Macro for data import by crm-now
CRM – vtiger Open Source CRM – Advanced Outlook® Plugin for 5.0.4 and 5.1
CRM – vtiger Open Source CRM – UTF-8 Converter for CRM data imports by crm-now
CRM – vtiger Open Source CRM – Google Gadget for vtiger CRM
CRM – vtiger Open Source CRM – Multiple Company Address & Terms & Conditions
CRM – vtiger Open Source CRM – Super Quick Telephone Search
CRM – vtiger Open Source CRM – Multiple From Addresses
CRM – vtiger Open Source CRM – Receipt Cards Issue Card and Receipt Card Modules: Liste de fichiers du projet
Creating new fields in a vtiger module | Enbake Consulting
vtiger520:User Manual –
vtiger CRM v5.x

vTiger, Taxes, VAT

If a product is taxable, the Tax checkbox must be checked in the product Pricing Information, otherwise, it will not be possible to set a tax in quotes or invoices.

There is a Tax Class field in the Product table, which does not seem to be used.

Taxe Types and Tax Rates are stored in table:

Table Field Type Null Key Default Extra
vtiger_producttaxrel productid int(11) NO MUL NULL
vtiger_producttaxrel taxid int(3) NO MUL NULL
vtiger_producttaxrel taxpercentage decimal(7,3) YES NULL

There is a line for each product for which Tax has been checked.

When one imports Products, there is apparently no way to import or set the Tax.

So I log into phpMyAdmin. I export the Products into a CSV, which gets me the productid

I create a new csv file with “productid”;”taxid”;”taxpercentage” value for each product.

productid comes from the vtiger_product table
taxid comes from the table vtiger_inventorytaxinfo
taxpercentage is the percentage: 17.000 as example.

I then load the csv file with phpMyAdmin into the table vtiger_producttaxrel.