[Web-erp-svn] SF.net SVN: web-erp:[5890] trunk

[<dai...@us...>]

Revision: 5890
          http://sourceforge.net/p/web-erp/reponame/5890
Author:   daintree
Date:     2013-05-03 10:17:59 +0000 (Fri, 03 May 2013)
Log Message:
-----------
Ricard: new script to change GL account codes Z_ChangeGLAccountCode.php and SQL to upgrade to varchar account codes

Modified Paths:
--------------
    trunk/doc/Change.log
    trunk/sql/mysql/upgrade4.10-4.11.sql

Modified: trunk/doc/Change.log
===================================================================
--- trunk/doc/Change.log	2013-05-02 14:57:03 UTC (rev 5889)
+++ trunk/doc/Change.log	2013-05-03 10:17:59 UTC (rev 5890)
@@ -1,4 +1,6 @@
 OwebERP Change Log
+
+3/5/13 Ricard: new script to change GL account codes Z_ChangeGLAccountCode.php and SQL to upgrade to varchar account codes
 2/5/2013 Exson: Fixed strpos error and make the smtp server name more generic when user not use a email address in function of SendmailBySmtp in MiscFunctions.php.
 2/5/13 Phil: Credit_Invoice.php was not setting the selected location to credit into as reported by Ricard
 2/5/13 Exson: Revise the account code to 20 reported by Tim in GLAccounts.php. 

Modified: trunk/sql/mysql/upgrade4.10-4.11.sql
===================================================================
--- trunk/sql/mysql/upgrade4.10-4.11.sql	2013-05-02 14:57:03 UTC (rev 5889)
+++ trunk/sql/mysql/upgrade4.10-4.11.sql	2013-05-03 10:17:59 UTC (rev 5890)
@@ -1 +1,16 @@
 INSERT INTO config VALUES('SmtpSetting',0);
+ALTER TABLE  `companies` CHANGE  `debtorsact`  `debtorsact` VARCHAR( 20 ) NOT NULL DEFAULT  '70000',
+CHANGE  `pytdiscountact`  `pytdiscountact` VARCHAR( 20 ) NOT NULL DEFAULT  '55000',
+CHANGE  `creditorsact`  `creditorsact` VARCHAR( 20 ) NOT NULL DEFAULT  '80000',
+CHANGE  `payrollact`  `payrollact` VARCHAR( 20 ) NOT NULL DEFAULT  '84000',
+CHANGE  `grnact`  `grnact` VARCHAR( 20 ) NOT NULL DEFAULT  '72000',
+CHANGE  `exchangediffact`  `exchangediffact` VARCHAR( 20 ) NOT NULL DEFAULT  '65000',
+CHANGE  `purchasesexchangediffact`  `purchasesexchangediffact` VARCHAR( 20 ) NOT NULL DEFAULT  '0',
+CHANGE  `retainedearnings`  `retainedearnings` VARCHAR( 20 ) NOT NULL DEFAULT  '90000',
+CHANGE  `freightact`  `freightact` VARCHAR( 20 ) NOT NULL DEFAULT  '0';
+
+ALTER TABLE  `lastcostrollup` CHANGE  `stockact`  `stockact` VARCHAR( 20 ) NOT NULL DEFAULT  '0',
+CHANGE  `adjglact`  `adjglact` VARCHAR( 20 ) NOT NULL DEFAULT  '0';
+
+INSERT INTO  `scripts` (`script` , `pagesecurity` , `description`)
+VALUES ('Z_ChangeGLAccountCode.php',  '15',  'Script to change a GL account code accross all tables necessary');