Wrong type for AP Surf Set in demo data.

[fa-stable.git] / sql / en_US-demo.sql

diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql
index 9234453c37bfddfd37f96a2e619f1d20b01f7fe9..41b4cbb81c2952c747f19b57da11bae0b2b6277c 100644 (file)
--- a/sql/en_US-demo.sql
+++ b/sql/en_US-demo.sql
@@ -86,34 +86,34 @@ CREATE TABLE IF NOT EXISTS `0_audit_trail` (
 --
 
 INSERT INTO `0_audit_trail` VALUES
-('1', '18', '1', '1', '2016-05-05 14:08:02', NULL, '1', '2016-05-05', '0'),
-('2', '25', '1', '1', '2016-05-05 14:08:14', NULL, '1', '2016-05-05', '0'),
-('3', '30', '1', '1', '2016-05-05 14:09:54', NULL, '1', '2016-05-10', '0'),
-('4', '13', '1', '1', '2016-05-05 14:09:55', NULL, '1', '2016-05-10', '0'),
-('5', '10', '1', '1', '2016-05-05 14:09:55', NULL, '1', '2016-05-10', '0'),
-('6', '12', '1', '1', '2016-05-05 14:09:55', NULL, '1', '2016-05-10', '0'),
-('7', '26', '1', '1', '2016-05-05 14:18:49', 'Quick production.', '1', '2016-05-05', '0'),
-('8', '18', '2', '1', '2016-05-05 14:22:32', NULL, '1', '2016-05-05', '0'),
-('9', '25', '2', '1', '2016-05-05 14:22:32', NULL, '1', '2016-05-05', '0'),
-('10', '20', '1', '1', '2016-05-05 14:22:32', NULL, '1', '2016-05-05', '0'),
-('11', '30', '2', '1', '2016-05-07 07:55:15', NULL, '1', '2016-05-07', '0'),
-('12', '13', '2', '1', '2016-05-07 07:55:16', NULL, '1', '2016-05-07', '0'),
-('13', '10', '2', '1', '2016-05-07 07:55:16', NULL, '1', '2016-05-07', '0'),
-('14', '12', '2', '1', '2016-05-07 07:55:16', NULL, '1', '2016-05-07', '0'),
-('15', '30', '3', '1', '2016-05-07 08:08:24', NULL, '1', '2016-05-07', '0'),
-('16', '30', '4', '1', '2016-05-07 09:18:44', NULL, '1', '2016-05-07', '0'),
-('17', '30', '5', '1', '2016-05-07 11:42:41', NULL, '1', '2016-05-07', '0'),
-('18', '13', '3', '1', '2016-05-07 11:42:41', NULL, '1', '2016-05-07', '0'),
-('19', '10', '3', '1', '2016-05-07 11:42:41', NULL, '1', '2016-05-07', '0'),
-('20', '30', '6', '1', '2016-05-07 14:02:35', NULL, '1', '2016-05-07', '0'),
-('21', '30', '7', '1', '2016-05-07 14:05:38', NULL, '1', '2016-05-07', '0'),
-('22', '13', '4', '1', '2016-05-07 14:05:38', NULL, '1', '2016-05-07', '0'),
-('23', '10', '4', '1', '2016-05-07 14:05:38', NULL, '1', '2016-05-07', '0'),
-('24', '12', '3', '1', '2016-05-07 14:05:38', NULL, '1', '2016-05-07', '0'),
-('25', '26', '2', '1', '2016-05-07 15:59:34', NULL, '1', '2016-05-07', NULL),
-('26', '26', '3', '1', '2016-05-07 15:59:01', NULL, '1', '2016-05-07', '0'),
-('27', '26', '2', '1', '2016-05-07 15:59:34', 'Released.', '1', '2016-05-07', '0'),
-('28', '1', '1', '1', '2016-05-07 16:01:00', NULL, '1', '2016-05-07', '0');
+('1', '18', '1', '1', '2017-05-05 14:08:02', NULL, '1', '2017-05-05', '0'),
+('2', '25', '1', '1', '2017-05-05 14:08:14', NULL, '1', '2017-05-05', '0'),
+('3', '30', '1', '1', '2017-05-05 14:09:54', NULL, '1', '2017-05-10', '0'),
+('4', '13', '1', '1', '2017-05-05 14:09:55', NULL, '1', '2017-05-10', '0'),
+('5', '10', '1', '1', '2017-05-05 14:09:55', NULL, '1', '2017-05-10', '0'),
+('6', '12', '1', '1', '2017-05-05 14:09:55', NULL, '1', '2017-05-10', '0'),
+('7', '26', '1', '1', '2017-05-05 14:18:49', 'Quick production.', '1', '2017-05-05', '0'),
+('8', '18', '2', '1', '2017-05-05 14:22:32', NULL, '1', '2017-05-05', '0'),
+('9', '25', '2', '1', '2017-05-05 14:22:32', NULL, '1', '2017-05-05', '0'),
+('10', '20', '1', '1', '2017-05-05 14:22:32', NULL, '1', '2017-05-05', '0'),
+('11', '30', '2', '1', '2017-05-07 07:55:15', NULL, '1', '2017-05-07', '0'),
+('12', '13', '2', '1', '2017-05-07 07:55:16', NULL, '1', '2017-05-07', '0'),
+('13', '10', '2', '1', '2017-05-07 07:55:16', NULL, '1', '2017-05-07', '0'),
+('14', '12', '2', '1', '2017-05-07 07:55:16', NULL, '1', '2017-05-07', '0'),
+('15', '30', '3', '1', '2017-05-07 08:08:24', NULL, '1', '2017-05-07', '0'),
+('16', '30', '4', '1', '2017-05-07 09:18:44', NULL, '1', '2017-05-07', '0'),
+('17', '30', '5', '1', '2017-05-07 11:42:41', NULL, '1', '2017-05-07', '0'),
+('18', '13', '3', '1', '2017-05-07 11:42:41', NULL, '1', '2017-05-07', '0'),
+('19', '10', '3', '1', '2017-05-07 11:42:41', NULL, '1', '2017-05-07', '0'),
+('20', '30', '6', '1', '2017-05-07 14:02:35', NULL, '1', '2017-05-07', '0'),
+('21', '30', '7', '1', '2017-05-07 14:05:38', NULL, '1', '2017-05-07', '0'),
+('22', '13', '4', '1', '2017-05-07 14:05:38', NULL, '1', '2017-05-07', '0'),
+('23', '10', '4', '1', '2017-05-07 14:05:38', NULL, '1', '2017-05-07', '0'),
+('24', '12', '3', '1', '2017-05-07 14:05:38', NULL, '1', '2017-05-07', '0'),
+('25', '26', '2', '1', '2017-05-07 15:59:34', NULL, '1', '2017-05-07', NULL),
+('26', '26', '3', '1', '2017-05-07 15:59:01', NULL, '1', '2017-05-07', '0'),
+('27', '26', '2', '1', '2017-05-07 15:59:34', 'Released.', '1', '2017-05-07', '0'),
+('28', '1', '1', '1', '2017-05-07 16:01:00', NULL, '1', '2017-05-07', '0');
 
 -- --------------------------------------------------------
 
@@ -181,10 +181,10 @@ CREATE TABLE IF NOT EXISTS `0_bank_trans` (
 --
 
 INSERT INTO `0_bank_trans` VALUES
-('1', '12', '1', '2', '001/2016', '2016-05-10', '6240', '0', '0', '2', '1', NULL),
-('2', '12', '2', '2', '002/2016', '2016-05-07', '300', '0', '0', '2', '1', NULL),
-('3', '12', '3', '2', '003/2016', '2016-05-07', '0', '0', '0', '2', '1', NULL),
-('4', '1', '1', '1', '001/2016', '2016-05-07', '-5', '0', '0', '0', 'Goods received', NULL);
+('1', '12', '1', '2', '001/2017', '2017-05-10', '6240', '0', '0', '2', '1', NULL),
+('2', '12', '2', '2', '002/2017', '2017-05-07', '300', '0', '0', '2', '1', NULL),
+('3', '12', '3', '2', '003/2017', '2017-05-07', '0', '0', '0', '2', '1', NULL),
+('4', '1', '1', '1', '001/2017', '2017-05-07', '-5', '0', '0', '0', 'Goods received', NULL);
 
 -- --------------------------------------------------------
 
@@ -301,6 +301,7 @@ INSERT INTO `0_chart_master` VALUES ('1825', '', 'Accum. Amort. -Furn. & Equ
 INSERT INTO `0_chart_master` VALUES ('1840', '', 'Vehicle', '3', 0);
 INSERT INTO `0_chart_master` VALUES ('1845', '', 'Accum. Amort. -Vehicle', '3', 0);
 INSERT INTO `0_chart_master` VALUES ('2100', '', 'Accounts Payable', '4', 0);
+INSERT INTO `0_chart_master` VALUES ('2105', '', 'Deferred Income', '4', 0);
 INSERT INTO `0_chart_master` VALUES ('2110', '', 'Accrued Income Tax - Federal', '4', 0);
 INSERT INTO `0_chart_master` VALUES ('2120', '', 'Accrued Income Tax - State', '4', 0);
 INSERT INTO `0_chart_master` VALUES ('2130', '', 'Accrued Franchise Tax', '4', 0);
@@ -421,11 +422,11 @@ CREATE TABLE IF NOT EXISTS `0_comments` (
 --
 
 INSERT INTO `0_comments` VALUES
-('12', '1', '2016-05-10', 'Cash invoice 1'),
-('12', '2', '2016-05-07', 'Cash invoice 2'),
-('13', '4', '2016-05-07', 'Recurrent Invoice covers period 04/01/2016 - 04/07/2016.'),
-('10', '4', '2016-05-07', 'Recurrent Invoice covers period 04/01/2016 - 04/07/2016.'),
-('12', '3', '2016-05-07', 'Cash invoice 4');
+('12', '1', '2017-05-10', 'Cash invoice 1'),
+('12', '2', '2017-05-07', 'Cash invoice 2'),
+('13', '4', '2017-05-07', 'Recurrent Invoice covers period 04/01/2017 - 04/07/2017.'),
+('10', '4', '2017-05-07', 'Recurrent Invoice covers period 04/01/2017 - 04/07/2017.'),
+('12', '3', '2017-05-07', 'Cash invoice 4');
 
 -- --------------------------------------------------------
 
@@ -605,9 +606,9 @@ CREATE TABLE IF NOT EXISTS `0_cust_allocations` (
 --
 
 INSERT INTO `0_cust_allocations` VALUES
-('1', '1', '6240', '2016-05-10', '1', '12', '1', '10'),
-('2', '1', '300', '2016-05-07', '2', '12', '2', '10'),
-('3', '1', '0', '2016-05-07', '3', '12', '4', '10');
+('1', '1', '6240', '2017-05-10', '1', '12', '1', '10'),
+('2', '1', '300', '2017-05-07', '2', '12', '2', '10'),
+('3', '1', '0', '2017-05-07', '3', '12', '4', '10');
 
 -- --------------------------------------------------------
 
@@ -698,7 +699,7 @@ CREATE TABLE IF NOT EXISTS `0_debtor_trans` (
   `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
   `type` smallint(6) unsigned NOT NULL DEFAULT '0',
   `version` tinyint(1) unsigned NOT NULL DEFAULT '0',
-  `debtor_no` int(11) unsigned DEFAULT NULL,
+  `debtor_no` int(11) unsigned NOT NULL,
   `branch_code` int(11) NOT NULL DEFAULT '-1',
   `tran_date` date NOT NULL DEFAULT '0000-00-00',
   `due_date` date NOT NULL DEFAULT '0000-00-00',
@@ -718,7 +719,7 @@ CREATE TABLE IF NOT EXISTS `0_debtor_trans` (
   `dimension2_id` int(11) NOT NULL DEFAULT '0',
   `payment_terms` int(11) DEFAULT NULL,
   `tax_included` tinyint(1) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`type`,`trans_no`),
+  PRIMARY KEY (`type`,`trans_no`,`debtor_no`),
   KEY `debtor_no` (`debtor_no`,`branch_code`),
   KEY `tran_date` (`tran_date`),
   KEY `order_` (`order_`)
@@ -730,17 +731,17 @@ CREATE TABLE IF NOT EXISTS `0_debtor_trans` (
 
 
 INSERT INTO `0_debtor_trans` VALUES
-('1', '10', '0', '1', '1', '2016-05-10', '2016-05-05', '001/2016', '1', '1', '6240', '0', '0', '0', '0', '6240', '0', '1', '1', '0', '0', '4', '1'),
-('2', '10', '0', '1', '1', '2016-05-07', '2016-05-07', '002/2016', '1', '2', '300', '0', '0', '0', '0', '300', '0', '1', '1', '0', '0', '4', '1'),
-('3', '10', '0', '2', '2', '2016-05-07', '2016-06-17', '003/2016', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'),
-('4', '10', '0', '1', '1', '2016-05-07', '2016-05-07', '004/2016', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
-('1', '12', '0', '1', '1', '2016-05-10', '0000-00-00', '001/2016', '0', '0', '6240', '0', '0', '0', '0', '6240', '0', '1', '0', '0', '0', NULL, '0'),
-('2', '12', '0', '1', '1', '2016-05-07', '0000-00-00', '002/2016', '0', '0', '300', '0', '0', '0', '0', '300', '0', '1', '0', '0', '0', NULL, '0'),
-('3', '12', '0', '1', '1', '2016-05-07', '0000-00-00', '003/2016', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', NULL, '0'),
-('1', '13', '1', '1', '1', '2016-05-10', '2016-05-05', 'auto', '1', '1', '6240', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
-('2', '13', '1', '1', '1', '2016-05-07', '2016-05-07', 'auto', '1', '2', '300', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
-('3', '13', '1', '2', '2', '2016-05-07', '2016-06-17', 'auto', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'),
-('4', '13', '1', '1', '1', '2016-05-07', '2016-05-07', 'auto', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1');
+('1', '10', '0', '1', '1', '2017-05-10', '2017-05-05', '001/2017', '1', '1', '6240', '0', '0', '0', '0', '6240', '0', '1', '1', '0', '0', '4', '1'),
+('2', '10', '0', '1', '1', '2017-05-07', '2017-05-07', '002/2017', '1', '2', '300', '0', '0', '0', '0', '300', '0', '1', '1', '0', '0', '4', '1'),
+('3', '10', '0', '2', '2', '2017-05-07', '2017-06-17', '003/2017', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'),
+('4', '10', '0', '1', '1', '2017-05-07', '2017-05-07', '004/2017', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
+('1', '12', '0', '1', '1', '2017-05-10', '0000-00-00', '001/2017', '0', '0', '6240', '0', '0', '0', '0', '6240', '0', '1', '0', '0', '0', NULL, '0'),
+('2', '12', '0', '1', '1', '2017-05-07', '0000-00-00', '002/2017', '0', '0', '300', '0', '0', '0', '0', '300', '0', '1', '0', '0', '0', NULL, '0'),
+('3', '12', '0', '1', '1', '2017-05-07', '0000-00-00', '003/2017', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', NULL, '0'),
+('1', '13', '1', '1', '1', '2017-05-10', '2017-05-05', 'auto', '1', '1', '6240', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
+('2', '13', '1', '1', '1', '2017-05-07', '2017-05-07', 'auto', '1', '2', '300', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1'),
+('3', '13', '1', '2', '2', '2017-05-07', '2017-06-17', 'auto', '1', '5', '267.14', '0', '0', '0', '0', '0', '0', '1.123', '1', '1', '0', '1', '1'),
+('4', '13', '1', '1', '1', '2017-05-07', '2017-05-07', 'auto', '1', '7', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '4', '1');
 
 -- --------------------------------------------------------
 
@@ -811,7 +812,7 @@ CREATE TABLE IF NOT EXISTS `0_dimensions` (
 -- Dumping data for table `0_dimensions`
 --
 
-INSERT INTO `0_dimensions` VALUES ('1', '001/2016', 'Cost Centre', '1', '0', '2016-05-05', '2016-05-25');
+INSERT INTO `0_dimensions` VALUES ('1', '001/2017', 'Cost Centre', '1', '0', '2017-05-05', '2017-05-25');
 
 -- --------------------------------------------------------
 
@@ -834,7 +835,7 @@ CREATE TABLE IF NOT EXISTS `0_exchange_rates` (
 -- Dumping data for table `0_exchange_rates`
 --
 
-INSERT INTO `0_exchange_rates` VALUES ('1', 'EUR', '1.123', '1.123', '2016-05-07');
+INSERT INTO `0_exchange_rates` VALUES ('1', 'EUR', '1.123', '1.123', '2017-05-07');
 
 -- --------------------------------------------------------
 
@@ -857,7 +858,8 @@ CREATE TABLE IF NOT EXISTS `0_fiscal_year` (
 -- Dumping data for table `0_fiscal_year`
 --
 
-INSERT INTO `0_fiscal_year` VALUES (1, '2016-01-01', '2016-12-31', 0);
+INSERT INTO `0_fiscal_year` VALUES (1, '2017-01-01', '2017-12-31', 0);
+INSERT INTO `0_fiscal_year` VALUES (2, '2018-01-01', '2018-12-31', 0);
 
 -- --------------------------------------------------------
 
@@ -891,44 +893,44 @@ CREATE TABLE IF NOT EXISTS `0_gl_trans` (
 --
 
 INSERT INTO `0_gl_trans` VALUES
-('1', '25', '1', '2016-05-05', '1510', '101', '20000', '0', '0', NULL, NULL),
-('2', '25', '1', '2016-05-05', '1510', '102', '15000', '0', '0', NULL, NULL),
-('3', '25', '1', '2016-05-05', '1510', '103', '1000', '0', '0', NULL, NULL),
-('4', '25', '1', '2016-05-05', '1550', '', '-36000', '0', '0', NULL, NULL),
-('5', '13', '1', '2016-05-10', '5010', '', '4000', '0', '0', NULL, NULL),
-('6', '13', '1', '2016-05-10', '1510', '', '-4000', '0', '0', NULL, NULL),
-('7', '10', '1', '2016-05-10', '4010', '', '-5714.29', '0', '0', NULL, NULL),
-('8', '10', '1', '2016-05-10', '4010', '', '-228.57', '0', '0', NULL, NULL),
-('9', '10', '1', '2016-05-10', '1200', '', '6240', '0', '0', '2', '1'),
-('10', '10', '1', '2016-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL),
-('11', '12', '1', '2016-05-10', '1065', '', '6240', '0', '0', NULL, NULL),
-('12', '12', '1', '2016-05-10', '1200', '', '-6240', '0', '0', '2', '1'),
-('13', '26', '1', '2016-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL),
-('14', '26', '1', '2016-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL),
-('15', '26', '1', '2016-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL),
-('16', '26', '1', '2016-05-05', '1510', 'Produced 2 * AP Surf Set', '720', '0', '0', NULL, NULL),
-('17', '25', '2', '2016-05-05', '1510', '101', '3000', '0', '0', NULL, NULL),
-('18', '25', '2', '2016-05-05', '1550', '', '-3000', '0', '0', NULL, NULL),
-('19', '20', '1', '2016-05-05', '2150', '', '150', '0', '0', NULL, NULL),
-('20', '20', '1', '2016-05-05', '2100', '', '-3150', '0', '0', '3', '1'),
-('21', '20', '1', '2016-05-05', '1550', '', '3000', '0', '0', NULL, NULL),
-('22', '13', '2', '2016-05-07', '5010', '', '200', '0', '0', NULL, NULL),
-('23', '13', '2', '2016-05-07', '1510', '', '-200', '0', '0', NULL, NULL),
-('24', '10', '2', '2016-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL),
-('25', '10', '2', '2016-05-07', '1200', '', '300', '0', '0', '2', '1'),
-('26', '10', '2', '2016-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL),
-('27', '12', '2', '2016-05-07', '1065', '', '300', '0', '0', NULL, NULL),
-('28', '12', '2', '2016-05-07', '1200', '', '-300', '0', '0', '2', '1'),
-('29', '13', '3', '2016-05-07', '5010', '', '150', '1', '0', NULL, NULL),
-('30', '13', '3', '2016-05-07', '1510', '', '-150', '0', '0', NULL, NULL),
-('31', '13', '3', '2016-05-07', '5010', '', '10', '1', '0', NULL, NULL),
-('32', '13', '3', '2016-05-07', '1510', '', '-10', '0', '0', NULL, NULL),
-('33', '10', '3', '2016-05-07', '4010', '', '-250', '1', '0', NULL, NULL),
-('34', '10', '3', '2016-05-07', '4010', '', '-50', '1', '0', NULL, NULL),
-('35', '10', '3', '2016-05-07', '1200', '', '300', '0', '0', '2', '2'),
-('36', '12', '3', '2016-05-07', '1065', '', '0', '0', '0', NULL, NULL),
-('37', '1', '1', '2016-05-07', '5010', '', '5', '1', '0', NULL, NULL),
-('38', '1', '1', '2016-05-07', '1060', '', '-5', '0', '0', NULL, NULL);
+('1', '25', '1', '2017-05-05', '1510', '101', '20000', '0', '0', NULL, NULL),
+('2', '25', '1', '2017-05-05', '1510', '102', '15000', '0', '0', NULL, NULL),
+('3', '25', '1', '2017-05-05', '1510', '103', '1000', '0', '0', NULL, NULL),
+('4', '25', '1', '2017-05-05', '1550', '', '-36000', '0', '0', NULL, NULL),
+('5', '13', '1', '2017-05-10', '5010', '', '4000', '0', '0', NULL, NULL),
+('6', '13', '1', '2017-05-10', '1510', '', '-4000', '0', '0', NULL, NULL),
+('7', '10', '1', '2017-05-10', '4010', '', '-5714.29', '0', '0', NULL, NULL),
+('8', '10', '1', '2017-05-10', '4010', '', '-228.57', '0', '0', NULL, NULL),
+('9', '10', '1', '2017-05-10', '1200', '', '6240', '0', '0', '2', '1'),
+('10', '10', '1', '2017-05-10', '2150', '', '-297.14', '0', '0', NULL, NULL),
+('11', '12', '1', '2017-05-10', '1065', '', '6240', '0', '0', NULL, NULL),
+('12', '12', '1', '2017-05-10', '1200', '', '-6240', '0', '0', '2', '1'),
+('13', '26', '1', '2017-05-05', '1510', '1 * iPad Air 2 16GB', '-400', '0', '0', NULL, NULL),
+('14', '26', '1', '2017-05-05', '1510', '1 * iPhone 6 64GB', '-300', '0', '0', NULL, NULL),
+('15', '26', '1', '2017-05-05', '1510', '1 * iPhone Cover Case', '-20', '0', '0', NULL, NULL),
+('16', '26', '1', '2017-05-05', '1510', 'Produced 2 * AP Surf Set', '720', '0', '0', NULL, NULL),
+('17', '25', '2', '2017-05-05', '1510', '101', '3000', '0', '0', NULL, NULL),
+('18', '25', '2', '2017-05-05', '1550', '', '-3000', '0', '0', NULL, NULL),
+('19', '20', '1', '2017-05-05', '2150', '', '150', '0', '0', NULL, NULL),
+('20', '20', '1', '2017-05-05', '2100', '', '-3150', '0', '0', '3', '1'),
+('21', '20', '1', '2017-05-05', '1550', '', '3000', '0', '0', NULL, NULL),
+('22', '13', '2', '2017-05-07', '5010', '', '200', '0', '0', NULL, NULL),
+('23', '13', '2', '2017-05-07', '1510', '', '-200', '0', '0', NULL, NULL),
+('24', '10', '2', '2017-05-07', '4010', '', '-285.71', '0', '0', NULL, NULL),
+('25', '10', '2', '2017-05-07', '1200', '', '300', '0', '0', '2', '1'),
+('26', '10', '2', '2017-05-07', '2150', '', '-14.29', '0', '0', NULL, NULL),
+('27', '12', '2', '2017-05-07', '1065', '', '300', '0', '0', NULL, NULL),
+('28', '12', '2', '2017-05-07', '1200', '', '-300', '0', '0', '2', '1'),
+('29', '13', '3', '2017-05-07', '5010', '', '150', '1', '0', NULL, NULL),
+('30', '13', '3', '2017-05-07', '1510', '', '-150', '0', '0', NULL, NULL),
+('31', '13', '3', '2017-05-07', '5010', '', '10', '1', '0', NULL, NULL),
+('32', '13', '3', '2017-05-07', '1510', '', '-10', '0', '0', NULL, NULL),
+('33', '10', '3', '2017-05-07', '4010', '', '-250', '1', '0', NULL, NULL),
+('34', '10', '3', '2017-05-07', '4010', '', '-50', '1', '0', NULL, NULL),
+('35', '10', '3', '2017-05-07', '1200', '', '300', '0', '0', '2', '2'),
+('36', '12', '3', '2017-05-07', '1065', '', '0', '0', '0', NULL, NULL),
+('37', '1', '1', '2017-05-07', '5010', '', '5', '1', '0', NULL, NULL),
+('38', '1', '1', '2017-05-07', '1060', '', '-5', '0', '0', NULL, NULL);
 
 -- --------------------------------------------------------
 
@@ -955,8 +957,8 @@ CREATE TABLE IF NOT EXISTS `0_grn_batch` (
 --
 
 INSERT INTO `0_grn_batch` VALUES
-('1', '1', '1', '001/2016', '2016-05-05', 'DEF', '1'),
-('2', '1', '2', 'auto', '2016-05-05', 'DEF', '1');
+('1', '1', '1', '001/2017', '2017-05-05', 'DEF', '1'),
+('2', '1', '2', 'auto', '2017-05-05', 'DEF', '1');
 
 -- --------------------------------------------------------
 
@@ -1212,6 +1214,7 @@ INSERT INTO `0_payment_terms` VALUES (1, 'Due 15th Of the Following Month', 0, 1
 INSERT INTO `0_payment_terms` VALUES (2, 'Due By End Of The Following Month', 0, 30, 0);
 INSERT INTO `0_payment_terms` VALUES (3, 'Payment due within 10 days', 10, 0, 0);
 INSERT INTO `0_payment_terms` VALUES (4, 'Cash Only', 0, 0, 0);
+INSERT INTO `0_payment_terms` VALUES (5, 'Prepaid', -1, 0, 0);
 
 -- --------------------------------------------------------
 
@@ -1351,8 +1354,8 @@ CREATE TABLE IF NOT EXISTS `0_purch_orders` (
 --
 
 INSERT INTO `0_purch_orders` VALUES
-('1', '1', NULL, '2016-05-05', '001/2016', NULL, 'DEF', 'N/A', '37800', '0', '0', '0'),
-('2', '1', NULL, '2016-05-05', 'auto', 'rr4', 'DEF', 'N/A', '3150', '0', '0', '0');
+('1', '1', NULL, '2017-05-05', '001/2017', NULL, 'DEF', 'N/A', '37800', '0', '0', '0'),
+('2', '1', NULL, '2017-05-05', 'auto', 'rr4', 'DEF', 'N/A', '3150', '0', '0', '0');
 
 -- --------------------------------------------------------
 
@@ -1383,10 +1386,10 @@ CREATE TABLE IF NOT EXISTS `0_purch_order_details` (
 --
 
 INSERT INTO `0_purch_order_details` VALUES
-('1', '1', '101', 'iPad Air 2 16GB', '2016-05-15', '0', '200', '200', '200', '100', '100'),
-('2', '1', '102', 'iPhone 6 64GB', '2016-05-15', '0', '150', '150', '150', '100', '100'),
-('3', '1', '103', 'iPhone Cover Case', '2016-05-15', '0', '10', '10', '10', '100', '100'),
-('4', '2', '101', 'iPad Air 2 16GB', '2016-05-05', '15', '200', '200', '200', '15', '15');
+('1', '1', '101', 'iPad Air 2 16GB', '2017-05-15', '0', '200', '200', '200', '100', '100'),
+('2', '1', '102', 'iPhone 6 64GB', '2017-05-15', '0', '150', '150', '150', '100', '100'),
+('3', '1', '103', 'iPhone Cover Case', '2017-05-15', '0', '10', '10', '10', '100', '100'),
+('4', '2', '101', 'iPad Air 2 16GB', '2017-05-05', '15', '200', '200', '200', '15', '15');
 
 -- --------------------------------------------------------
 
@@ -1472,7 +1475,7 @@ CREATE TABLE IF NOT EXISTS `0_recurrent_invoices` (
 -- Dumping data for table `0_recurrent_invoices`
 --
 
-INSERT INTO `0_recurrent_invoices` VALUES ('1', 'Weekly Maintenance', '6', '1', '1', '7', '0', '2016-04-01', '2020-05-07', '2016-04-08');
+INSERT INTO `0_recurrent_invoices` VALUES ('1', 'Weekly Maintenance', '6', '1', '1', '7', '0', '2017-04-01', '2020-05-07', '2017-04-08');
 
 -- --------------------------------------------------------
 
@@ -1542,24 +1545,24 @@ CREATE TABLE IF NOT EXISTS `0_refs` (
 --
 
 INSERT INTO `0_refs` VALUES
-('1', '1', '001/2016'),
-('1', '10', '001/2016'),
-('2', '10', '002/2016'),
-('3', '10', '003/2016'),
-('4', '10', '004/2016'),
-('1', '12', '001/2016'),
-('2', '12', '002/2016'),
-('3', '12', '003/2016'),
-('1', '18', '001/2016'),
-('1', '20', '001/2016'),
-('1', '25', '001/2016'),
-('1', '26', '001/2016'),
-('2', '26', '002/2016'),
-('3', '26', '003/2016'),
-('3', '30', '001/2016'),
-('4', '30', '002/2016'),
-('6', '30', '003/2016'),
-('1', '40', '001/2016');
+('1', '1', '001/2017'),
+('1', '10', '001/2017'),
+('2', '10', '002/2017'),
+('3', '10', '003/2017'),
+('4', '10', '004/2017'),
+('1', '12', '001/2017'),
+('2', '12', '002/2017'),
+('3', '12', '003/2017'),
+('1', '18', '001/2017'),
+('1', '20', '001/2017'),
+('1', '25', '001/2017'),
+('1', '26', '001/2017'),
+('2', '26', '002/2017'),
+('3', '26', '003/2017'),
+('3', '30', '001/2017'),
+('4', '30', '002/2017'),
+('6', '30', '003/2017'),
+('1', '40', '001/2017');
 
 -- --------------------------------------------------------
 
@@ -1627,13 +1630,13 @@ CREATE TABLE IF NOT EXISTS `0_sales_orders` (
 --
 
 INSERT INTO `0_sales_orders` VALUES
-('1', '30', '1', '0', '1', '1', 'auto', '', NULL, '2016-05-10', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2016-05-05', '4', '6240', '0', '0'),
-('2', '30', '1', '0', '1', '1', 'auto', '', NULL, '2016-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2016-05-07', '4', '300', '0', '0'),
-('3', '30', '0', '0', '1', '1', '001/2016', '', NULL, '2016-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2016-05-08', '4', '300', '0', '0'),
-('4', '30', '0', '0', '2', '2', '002/2016', '', NULL, '2016-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2016-05-08', '1', '267.14', '0', '0'),
-('5', '30', '1', '0', '2', '2', 'auto', '', NULL, '2016-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2016-06-17', '1', '267.14', '0', '0'),
-('6', '30', '0', '1', '1', '1', '003/2016', '', NULL, '2016-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2016-05-08', '4', '450', '0', '0'),
-('7', '30', '1', '0', '1', '1', 'auto', '', 'Recurrent Invoice covers period 04/01/2016 - 04/07/2016.', '2016-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2016-05-07', '4', '0', '0', '0');
+('1', '30', '1', '0', '1', '1', 'auto', '', NULL, '2017-05-10', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2017-05-05', '4', '6240', '0', '0'),
+('2', '30', '1', '0', '1', '1', 'auto', '', NULL, '2017-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2017-05-07', '4', '300', '0', '0'),
+('3', '30', '0', '0', '1', '1', '001/2017', '', NULL, '2017-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2017-05-08', '4', '300', '0', '0'),
+('4', '30', '0', '0', '2', '2', '002/2017', '', NULL, '2017-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2017-05-08', '1', '267.14', '0', '0'),
+('5', '30', '1', '0', '2', '2', 'auto', '', NULL, '2017-05-07', '1', '1', 'N/A', NULL, NULL, 'MoneyMaker Ltd.', '0', 'DEF', '2017-06-17', '1', '267.14', '0', '0'),
+('6', '30', '0', '1', '1', '1', '003/2017', '', NULL, '2017-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2017-05-08', '4', '450', '0', '0'),
+('7', '30', '1', '0', '1', '1', 'auto', '', 'Recurrent Invoice covers period 04/01/2017 - 04/07/2017.', '2017-05-07', '1', '1', 'N/A', NULL, NULL, 'Donald Easter LLC', '0', 'DEF', '2017-05-07', '4', '0', '0', '0');
 
 -- --------------------------------------------------------
 
@@ -1932,21 +1935,21 @@ CREATE TABLE `0_stock_moves` (
 --
 
 INSERT INTO `0_stock_moves` VALUES
-('1', '1', '101', '25', 'DEF', '2016-05-05', '200', '', '100', '200'),
-('2', '1', '102', '25', 'DEF', '2016-05-05', '150', '', '100', '150'),
-('3', '1', '103', '25', 'DEF', '2016-05-05', '10', '', '100', '10'),
-('4', '1', '101', '13', 'DEF', '2016-05-10', '300', 'auto', '-20', '200'),
-('5', '1', '301', '13', 'DEF', '2016-05-10', '80', 'auto', '-3', '0'),
-('6', '1', '101', '26', 'DEF', '2016-05-05', '200', '001/2016', '-2', '200'),
-('7', '1', '102', '26', 'DEF', '2016-05-05', '150', '001/2016', '-2', '150'),
-('8', '1', '103', '26', 'DEF', '2016-05-05', '10', '001/2016', '-2', '10'),
-('9', '1', '301', '26', 'DEF', '2016-05-05', '0', '001/2016', '-2', '0'),
-('10', '1', '201', '26', 'DEF', '2016-05-05', '0', '001/2016', '2', '0'),
-('11', '2', '101', '25', 'DEF', '2016-05-05', '200', '', '15', '200'),
-('12', '2', '101', '13', 'DEF', '2016-05-07', '300', 'auto', '-1', '200'),
-('13', '3', '102', '13', 'DEF', '2016-05-07', '222.62', 'auto', '-1', '150'),
-('14', '3', '103', '13', 'DEF', '2016-05-07', '44.52', 'auto', '-1', '10'),
-('15', '4', '202', '13', 'DEF', '2016-05-07', '0', 'auto', '-5', '0');
+('1', '1', '101', '25', 'DEF', '2017-05-05', '200', '', '100', '200'),
+('2', '1', '102', '25', 'DEF', '2017-05-05', '150', '', '100', '150'),
+('3', '1', '103', '25', 'DEF', '2017-05-05', '10', '', '100', '10'),
+('4', '1', '101', '13', 'DEF', '2017-05-10', '300', 'auto', '-20', '200'),
+('5', '1', '301', '13', 'DEF', '2017-05-10', '80', 'auto', '-3', '0'),
+('6', '1', '101', '29', 'DEF', '2017-05-05', '200', '001/2017', '-2', '200'),
+('7', '1', '102', '29', 'DEF', '2017-05-05', '150', '001/2017', '-2', '150'),
+('8', '1', '103', '29', 'DEF', '2017-05-05', '10', '001/2017', '-2', '10'),
+('9', '1', '301', '29', 'DEF', '2017-05-05', '0', '001/2017', '-2', '0'),
+('10', '1', '201', '26', 'DEF', '2017-05-05', '0', '001/2017', '2', '360'),
+('11', '2', '101', '25', 'DEF', '2017-05-05', '200', '', '15', '200'),
+('12', '2', '101', '13', 'DEF', '2017-05-07', '300', 'auto', '-1', '200'),
+('13', '3', '102', '13', 'DEF', '2017-05-07', '222.62', 'auto', '-1', '150'),
+('14', '3', '103', '13', 'DEF', '2017-05-07', '44.52', 'auto', '-1', '10'),
+('15', '4', '202', '13', 'DEF', '2017-05-07', '0', 'auto', '-5', '0');
 
 -- --------------------------------------------------------
 
@@ -2058,7 +2061,7 @@ DROP TABLE IF EXISTS `0_supp_trans`;
 CREATE TABLE IF NOT EXISTS `0_supp_trans` (
   `trans_no` int(11) unsigned NOT NULL DEFAULT '0',
   `type` smallint(6) unsigned NOT NULL DEFAULT '0',
-  `supplier_id` int(11) unsigned DEFAULT NULL,
+  `supplier_id` int(11) unsigned NOT NULL,
   `reference` tinytext NOT NULL,
   `supp_reference` varchar(60) NOT NULL DEFAULT '',
   `tran_date` date NOT NULL DEFAULT '0000-00-00',
@@ -2069,7 +2072,7 @@ CREATE TABLE IF NOT EXISTS `0_supp_trans` (
   `rate` double NOT NULL DEFAULT '1',
   `alloc` double NOT NULL DEFAULT '0',
   `tax_included` tinyint(1) NOT NULL DEFAULT '0',
-  PRIMARY KEY (`type`,`trans_no`),
+  PRIMARY KEY (`type`,`trans_no`,`supplier_id`),
   KEY `supplier_id` (`supplier_id`),
   KEY `tran_date` (`tran_date`)
 ) ENGINE=InnoDB;
@@ -2079,7 +2082,7 @@ CREATE TABLE IF NOT EXISTS `0_supp_trans` (
 --
 
 
-INSERT INTO `0_supp_trans` VALUES ('1', '20', '1', '001/2016', 'rr4', '2016-05-05', '2016-05-15', '3000', '0', '150', '1', '0', '0');
+INSERT INTO `0_supp_trans` VALUES ('1', '20', '1', '001/2017', 'rr4', '2017-05-05', '2017-05-15', '3000', '0', '150', '1', '0', '0');
 
 -- --------------------------------------------------------
 
@@ -2115,7 +2118,8 @@ INSERT INTO `0_sys_prefs` VALUES ('coy_logo', 'setup.company', 'varchar', 100, '
 INSERT INTO `0_sys_prefs` VALUES ('domicile', 'setup.company', 'varchar', 55, '');
 INSERT INTO `0_sys_prefs` VALUES ('curr_default', 'setup.company', 'char', 3, 'USD');
 INSERT INTO `0_sys_prefs` VALUES ('use_dimension', 'setup.company', 'tinyint', 1, '1');
-INSERT INTO `0_sys_prefs` VALUES ('f_year', 'setup.company', 'int', 11, '1');
+INSERT INTO `0_sys_prefs` VALUES ('f_year', 'setup.company', 'int', 11, '2');
+INSERT INTO `0_sys_prefs` VALUES ('shortname_name_in_list','setup.company', 'tinyint', 1, '0');
 INSERT INTO `0_sys_prefs` VALUES ('no_item_list', 'setup.company', 'tinyint', 1, '0');
 INSERT INTO `0_sys_prefs` VALUES ('no_customer_list', 'setup.company', 'tinyint', 1, '0');
 INSERT INTO `0_sys_prefs` VALUES ('no_supplier_list', 'setup.company', 'tinyint', 1, '0');
@@ -2157,7 +2161,7 @@ INSERT INTO `0_sys_prefs` VALUES ('version_id', 'system', 'varchar', 11, '2.4.1'
 INSERT INTO `0_sys_prefs` VALUES ('auto_curr_reval', 'setup.company', 'smallint', 6, '1');
 INSERT INTO `0_sys_prefs` VALUES ('grn_clearing_act', 'glsetup.purchase', 'varchar', 15, '1550');
 INSERT INTO `0_sys_prefs` VALUES ('bcc_email', 'setup.company', 'varchar', 100, '');
-INSERT INTO `0_sys_prefs` VALUES ('deferred_income_act', 'glsetup.sales', 'varchar', '15', '');
+INSERT INTO `0_sys_prefs` VALUES ('deferred_income_act', 'glsetup.sales', 'varchar', '15', '2105');
 INSERT INTO `0_sys_prefs` VALUES ('gl_closing_date','setup.closing_date', 'date', 8, '');
 INSERT INTO `0_sys_prefs` VALUES ('alternative_tax_include_on_docs','setup.company', 'tinyint', 1, '0');
 INSERT INTO `0_sys_prefs` VALUES ('no_zero_lines_amount','glsetup.sales', 'tinyint', 1, '1');
@@ -2168,6 +2172,9 @@ INSERT INTO `0_sys_prefs` VALUES ('print_invoice_no','glsetup.sales', 'tinyint',
 INSERT INTO `0_sys_prefs` VALUES ('allow_negative_prices','glsetup.inventory', 'tinyint', 1, '1');
 INSERT INTO `0_sys_prefs` VALUES ('print_item_images_on_quote','glsetup.inventory', 'tinyint', 1, '0');
 INSERT INTO `0_sys_prefs` VALUES ('suppress_tax_rates','setup.company', 'tinyint', 1, '0');
+INSERT INTO `0_sys_prefs` VALUES ('company_logo_report','setup.company', 'tinyint', 1, '0');
+INSERT INTO `0_sys_prefs` VALUES ('barcodes_on_stock','setup.company', 'tinyint', 1, '0');
+INSERT INTO `0_sys_prefs` VALUES ('ref_no_auto_increase','setup.company', 'tinyint', 1, '0');
 INSERT INTO `0_sys_prefs` VALUES ('default_loss_on_asset_disposal_act', 'glsetup.items', 'varchar', '15', '5660');
 INSERT INTO `0_sys_prefs` VALUES ('depreciation_period', 'glsetup.company', 'tinyint', '1', '1');
 INSERT INTO `0_sys_prefs` VALUES ('use_manufacturing','setup.company', 'tinyint', 1, '1');
@@ -2307,13 +2314,13 @@ CREATE TABLE IF NOT EXISTS `0_trans_tax_details` (
 --
 
 INSERT INTO `0_trans_tax_details` VALUES
-('1', '13', '1', '2016-05-10', '1', '5', '1', '1', '5942.86', '297.14', 'auto', NULL),
-('2', '10', '1', '2016-05-10', '1', '5', '1', '1', '5942.86', '297.14', '001/2016', '0'),
-('3', '20', '1', '2016-05-05', '1', '5', '1', '0', '3000', '150', 'rr4', '1'),
-('4', '13', '2', '2016-05-07', '1', '5', '1', '1', '285.71', '14.29', 'auto', NULL),
-('5', '10', '2', '2016-05-07', '1', '5', '1', '1', '285.71', '14.29', '002/2016', '0'),
-('6', '13', '3', '2016-05-07', '0', '0', '1.123', '1', '267.14', '0', 'auto', NULL),
-('7', '10', '3', '2016-05-07', '0', '0', '1.123', '1', '267.14', '0', '003/2016', '0');
+('1', '13', '1', '2017-05-10', '1', '5', '1', '1', '5942.86', '297.14', 'auto', NULL),
+('2', '10', '1', '2017-05-10', '1', '5', '1', '1', '5942.86', '297.14', '001/2017', '0'),
+('3', '20', '1', '2017-05-05', '1', '5', '1', '0', '3000', '150', 'rr4', '1'),
+('4', '13', '2', '2017-05-07', '1', '5', '1', '1', '285.71', '14.29', 'auto', NULL),
+('5', '10', '2', '2017-05-07', '1', '5', '1', '1', '285.71', '14.29', '002/2017', '0'),
+('6', '13', '3', '2017-05-07', '0', '0', '1.123', '1', '267.14', '0', 'auto', NULL),
+('7', '10', '3', '2017-05-07', '0', '0', '1.123', '1', '267.14', '0', '003/2017', '0');
 
 -- --------------------------------------------------------
 
@@ -2387,7 +2394,7 @@ CREATE TABLE IF NOT EXISTS `0_users` (
 -- Dumping data for table `0_users`
 --
 
-INSERT INTO `0_users` VALUES (1, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', 2, '', 'adm@example.com', 'C', 0, 0, 0, 0, 'default', 'Letter', 2, 2, 4, 1, 1, 0, 0, '2016-05-07 13:58:33', 10, 1, 1, '1', 1, 0, 'orders', 30, 0, 1, 0, 0, 0);
+INSERT INTO `0_users` VALUES (1, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', 2, '', 'adm@example.com', 'C', 0, 0, 0, 0, 'default', 'Letter', 2, 2, 4, 1, 1, 0, 0, '2017-05-07 13:58:33', 10, 1, 1, '1', 1, 0, 'orders', 30, 0, 1, 0, 0, 0);
 
 -- --------------------------------------------------------
 
@@ -2460,9 +2467,9 @@ CREATE TABLE IF NOT EXISTS `0_workorders` (
 --
 
 INSERT INTO `0_workorders` VALUES
-('1', '001/2016', 'DEF', '2', '201', '2016-05-05', '0', '2016-05-05', '2016-05-05', '2', '1', '1', '0'),
-('2', '002/2016', 'DEF', '5', '201', '2016-05-07', '2', '2016-05-27', '2016-05-07', '0', '0', '1', '0'),
-('3', '003/2016', 'DEF', '5', '201', '2016-05-07', '2', '2016-05-27', '0000-00-00', '0', '0', '0', '0');
+('1', '001/2017', 'DEF', '2', '201', '2017-05-05', '0', '2017-05-05', '2017-05-05', '2', '1', '1', '0'),
+('2', '002/2017', 'DEF', '5', '201', '2017-05-07', '2', '2017-05-27', '2017-05-07', '0', '0', '1', '0'),
+('3', '003/2017', 'DEF', '5', '201', '2017-05-07', '2', '2017-05-27', '0000-00-00', '0', '0', '0', '0');
 
 -- --------------------------------------------------------