You may henceforth refer to the various extension modules - Charts, Extensions, Languages and Themes - by linking to files in my unofficial GitHub repo's extensions folder or your fork of it. In this case it would be:

Default American coa (5 digits)
US chart of accounts for service company.
Spanish COA - ISO

http://screenshot.net/37qnktm......[img]http://screenshot.net/37qnktm.jpg[/img]

Let me know if it´s ok.

Thanks for collaboration.

FYI, and based on my assumption, I went ahead and reversed the above changes on the db to its original " gst_no " ....and voila...it worked.

Replace all instances of ruc_no with gst_no and R.U.C. No: with GSTNo: in your suppliers.php file. Looks like there is something wrong with your FA php files itself. The suppliers table is missing the supp_ref field and the gst_no field is wrongly named ruc_no.

DROP TABLE IF EXISTS `0_suppliers`;
CREATE TABLE IF NOT EXISTS `0_suppliers` (
  `supplier_id` int(11) NOT NULL auto_increment,
  `supp_name` varchar(60) NOT NULL default '',
  `supp_ref` varchar(30) NOT NULL default '',
  `address` tinytext NOT NULL,
  `supp_address` tinytext NOT NULL,
  `gst_no` varchar(25) NOT NULL default '',
  `contact` varchar(60) NOT NULL default '',
  `supp_account_no` varchar(40) NOT NULL default '',
  `website` varchar(100) NOT NULL default '',
  `bank_account` varchar(60) NOT NULL default '',
  `curr_code` char(3) default NULL,
  `payment_terms` int(11) default NULL,
  `tax_included` tinyint(1) NOT NULL default '0',
  `dimension_id` int(11) default '0',
  `dimension2_id` int(11) default '0',
  `tax_group_id` int(11) default NULL,
  `credit_limit` double NOT NULL default '0',
  `purchase_account` varchar(15) NOT NULL default '',
  `payable_account` varchar(15) NOT NULL default '',
  `payment_discount_account` varchar(15) NOT NULL default '',
  `notes` tinytext NOT NULL,
  `inactive` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`supplier_id`),
  KEY `supp_ref` (`supp_ref`)
) ENGINE=MyISAM;

RUC [General/National Taxpayers Register by its acronym in Spanish] Nr.

Which CoA are you using and from where?

[img]http://s4.postimg.org/iktj8u9fd/2015_11_13_3.png[/img]

it seems as if script can´t communicate with db....that´s my impression.....FYI....I´m just an empirical fellow....so please, share your expert knowledge....it´ll be greatly appreciated.

Perhaps, you might want to check my supplier.php file here.....suppliers.php

Web Browser: Google Chrome / Ver. 46.0.2490.86 m

Hope we have provided you with the requested info.

For snapshot provided....I guess we need to upload zip and decompress in order to replace currrent FA folder....right ?

I´m about to go blind and insane. Looked all over and can´t find any info on it that will correct the problem....plzzzz....HELP.

            add_supplier($_POST['supp_name'], $_POST['supp_ref'], $_POST['address'], $_POST['supp_address'],
                $_POST['gst_no'], $_POST['website'], $_POST['supp_account_no'], $_POST['bank_account'], 
                input_num('credit_limit',0), $_POST['dimension_id'], $_POST['dimension2_id'],
                $_POST['curr_code'], $_POST['payment_terms'], $_POST['payable_account'], $_POST['purchase_account'],
                $_POST['payment_discount_account'], $_POST['notes'], $_POST['tax_group_id'], check_value('tax_included'));

if not, you should upgrade to 2.3.11.

/Joe

error message : Incorrect integer value: '' for column 'tax_included' at row 1
sql that failed was : UPDATE 1_suppliers SET supp_name='Printed.com', supp_ref='Printed.com', address='Unit 2\nArcot Court\nNelson Road\nCramlington\nNorthumberland\nNE23 1BB', supp_address='', gst_no='621141690', website='www.printed.com', supp_account_no='', bank_account='', credit_limit=0, dimension_id='0', dimension2_id='0', curr_code='GBP', payment_terms='5', payable_account='2100', purchase_account='', payment_discount_account='5000', notes='', tax_group_id='6', tax_included='' WHERE supplier_id = '49'

If the checkbox is ticked - then no problem - but that isn't good if the suppliers prices do NOT contain VAT.

Thanks