[Vtigercrm-developers] Webservices and Taxes...

Alan Lord alanslists at gmail.com
Thu Sep 24 09:23:37 GMT 2020


Using the server APIs, I was trying to work out how to retrieve a list 
of all the configured taxes in vtiger?

vtws_describe only gave me some of the field meta data.

So I tried vtws_query("SELECT * FROM Tax;");

Surprisingly, this actually worked, in part... This gives me the 
configured Taxes. What it doesn't give me however is the configured 
taxes for Shipping and Handling.

How do I get those?


> phpwww vtws_query-tests.php
> Array
> (
>     [0] => Array
>         (
>             [id] => 34x1
>             [taxname] => tax1
>             [taxlabel] => VAT
>             [percentage] => 4.500
>             [deleted] => 0
>             [method] => Simple
>             [type] => Fixed
>             [compoundon] => []
>             [regions] => []
>         )
> 
>     [1] => Array
>         (
>             [id] => 34x2
>             [taxname] => tax2
>             [taxlabel] => Sales
>             [percentage] => 10.000
>             [deleted] => 0
>             [method] => Simple
>             [type] => Fixed
>             [compoundon] => []
>             [regions] => []
>         )
> 
>     [2] => Array
>         (
>             [id] => 34x3
>             [taxname] => tax3
>             [taxlabel] => Service
>             [percentage] => 12.500
>             [deleted] => 0
>             [method] => Simple
>             [type] => Fixed
>             [compoundon] => []
>             [regions] => []
>         )
> 
>     [3] => Array
>         (
>             [id] => 34x4
>             [taxname] => tax4
>             [taxlabel] => Super Tax
>             [percentage] => 20.000
>             [deleted] => 0
>             [method] => Simple
>             [type] => Fixed
>             [compoundon] => []
>             [regions] => []
>         )
> 
> )






More information about the vtigercrm-developers mailing list