[Weberp-cvs] SF.net SVN: web-erp:[3540] trunk

[<tim...@us...>]

Revision: 3540
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3540&view=rev
Author:   tim_schofield
Date:     2010-07-02 13:34:13 +0000 (Fri, 02 Jul 2010)

Log Message:
-----------
Bulk transfers need to be able to have decimal places in the quantity.

Modified Paths:
--------------
    trunk/doc/Change.log.html
    trunk/sql/mysql/upgrade3.11.1-3.12.sql
    trunk/sql/mysql/weberp-demo.sql

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-07-01 17:10:32 UTC (rev 3539)
+++ trunk/doc/Change.log.html	2010-07-02 13:34:13 UTC (rev 3540)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>02/07/10 Tim: Bulk transfers need to be able to have decimal places in the quantity.</p>
 <p>01/07/10 Tim: PrintCustTransPortrait.php - Error in sql, nor picking up stkmoveno.</p>
 <p>01/07/10 Tim: Numerous problems with stock adjustments for batch controlled items.</p>
 <p>01/07/10 Tim: DateFunctions.inc - Correction to GetPeriod() for case when future period didn't exist.</p>

Modified: trunk/sql/mysql/upgrade3.11.1-3.12.sql
===================================================================
--- trunk/sql/mysql/upgrade3.11.1-3.12.sql	2010-07-01 17:10:32 UTC (rev 3539)
+++ trunk/sql/mysql/upgrade3.11.1-3.12.sql	2010-07-02 13:34:13 UTC (rev 3540)
@@ -276,4 +276,6 @@
 
 INSERT INTO `config` VALUES ('DefaultSupplierType', 1);
 INSERT INTO `suppliertype` VALUES(1, 'Default');
-ALTER TABLE `suppliers` ADD COLUMN `supptype` tinyint(4) NOT NULL DEFAULT 1 AFTER `address6`;
\ No newline at end of file
+ALTER TABLE `suppliers` ADD COLUMN `supptype` tinyint(4) NOT NULL DEFAULT 1 AFTER `address6`;
+
+ALTER TABLE `locatransfers` CHANGE COLUMN `shipqty` `shipqty` double NOT NULL DEFAULT 0.0;
\ No newline at end of file

Modified: trunk/sql/mysql/weberp-demo.sql
===================================================================
--- trunk/sql/mysql/weberp-demo.sql	2010-07-01 17:10:32 UTC (rev 3539)
+++ trunk/sql/mysql/weberp-demo.sql	2010-07-02 13:34:13 UTC (rev 3540)
@@ -1011,7 +1011,7 @@
 CREATE TABLE `loctransfers` (
   `reference` int(11) NOT NULL DEFAULT '0',
   `stockid` varchar(20) NOT NULL DEFAULT '',
-  `shipqty` int(11) NOT NULL DEFAULT '0',
+  `shipqty` double NOT NULL DEFAULT '0.0',
   `recqty` int(11) NOT NULL DEFAULT '0',
   `shipdate` date NOT NULL DEFAULT '0000-00-00',
   `recdate` date NOT NULL DEFAULT '0000-00-00',


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.