[Web-erp-svn] SF.net SVN: web-erp:[5725] trunk/CounterSales.php

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

Revision: 5725
          http://sourceforge.net/p/web-erp/reponame/5725
Author:   tim_schofield
Date:     2012-10-23 17:09:20 +0000 (Tue, 23 Oct 2012)
Log Message:
-----------
Fix typo errors in sql

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

Modified: trunk/CounterSales.php
===================================================================
--- trunk/CounterSales.php	2012-10-20 10:20:40 UTC (rev 5724)
+++ trunk/CounterSales.php	2012-10-23 17:09:20 UTC (rev 5725)
@@ -1111,7 +1111,7 @@
 
 				$SQL = "SELECT SUM(salesorderdetails.quantity - salesorderdetails.qtyinvoiced) AS qtydemand
 						FROM salesorderdetails INNER JOIN salesorders
-						ON saleorderdetails.orderno=salesorders.orderno
+						ON salesorderdetails.orderno=salesorders.orderno
 						WHERE salesorderdetails.stkcode = '" . $StockItem->StockID . "'
 						AND salesorderdetails.completed = 0
 						AND salesorders.quotation = 0";
@@ -1125,7 +1125,7 @@
 								INNER JOIN bom
 								ON salesorderdetails.stkcode=bom.parent
 								INNER JOIN stockmaster
-								stockmaster.stockid=bom.parent
+								ON stockmaster.stockid=bom.parent
 								WHERE salesorderdetails.quantity-salesorderdetails.qtyinvoiced > 0
 								AND bom.component='" . $StockItem->StockID . "'
 								AND salesorderdetails.completed=0