[Web-erp-svn] SF.net SVN: web-erp:[5557] trunk/SupplierInvoice.php

[<Ex...@us...>]

Revision: 5557
          http://web-erp.svn.sourceforge.net/web-erp/?rev=5557&view=rev
Author:   ExsonQu
Date:     2012-07-25 09:31:04 +0000 (Wed, 25 Jul 2012)
Log Message:
-----------
25/7/2012 Exson: Fix the typo to make the $TotalQuantityOnHand is correct in SupplierInvoice.php

Modified Paths:
--------------
    trunk/SupplierInvoice.php

Modified: trunk/SupplierInvoice.php
===================================================================
--- trunk/SupplierInvoice.php	2012-07-25 09:27:36 UTC (rev 5556)
+++ trunk/SupplierInvoice.php	2012-07-25 09:31:04 UTC (rev 5557)
@@ -1233,7 +1233,7 @@
 							 * The cost of these items = $ActualCost
 							*/
 
-							$sql ="SELECT quantity
+							$sql ="SELECT sum(quantity)
 									FROM locstock
 									WHERE stockid='" . $EnteredGRN->ItemCode . "'";
 							$ErrMsg =  _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The quantity on hand could not be retrieved from the database');

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