Hi,
Just tried that, no luck.
In Dropdown Editor -> vat_list I’ve added the entry “0.0” the the name “None” (I’ve also tried 0 in both).
Error on trying to create quotation with Tax at 0:
Mon May 14 11:33:53 2018 [811][1][FATAL] Error inserting into table: aos_quotes: Query Failed: INSERT INTO aos_quotes (id,name,date_entered,date_modified,modified_user_id,created_by,deleted,assigned_user_id,approval_issue,billing_account_id,billing_contact_id,billing_address_street,billing_address_city,billing_address_state,billing_address_postalcode,billing_address_country,shipping_address_street,shipping_address_city,shipping_address_state,shipping_address_postalcode,shipping_address_country,expiration,number,opportunity_id,total_amt,total_amt_usdollar,subtotal_amount,subtotal_amount_usdollar,discount_amount,discount_amount_usdollar,tax_amount,tax_amount_usdollar,shipping_amount,shipping_amount_usdollar,shipping_tax,shipping_tax_amt,shipping_tax_amt_usdollar,total_amount,total_amount_usdollar,currency_id,stage,term,approval_status,invoice_status,subtotal_tax_amount_usdollar)
VALUES ('c45f6380-f1f0-74fd-9b3f-5af974a6e693','test','2018-05-14 11:33:53','2018-05-14 11:33:53','1','1',0,'1','','','','','','','','','','','','','','2018-06-14',4,'',1,0,1,0,0,0,,0,0,0,'0.0',0,0,1,0,'-99','Draft','','Approved','Not Invoiced',0): MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '0,0,0,'0.0',0,0,1,0,'-99','Draft','','Approved','Not Invoiced',0)' at line 2
Mon May 14 11:33:53 2018 [811][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
I’m on 7.8.8 I’ve noticed - so I’ll try upgrading at some point… but I’m more convinced I’m messing something up!