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

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

Revision: 4173
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4173&view=rev
Author:   tim_schofield
Date:     2010-11-28 17:56:41 +0000 (Sun, 28 Nov 2010)

Log Message:
-----------
Only show when the invoiced qty is less than the GRN qty

Modified Paths:
--------------
    trunk/OutstandingGRNs.php
    trunk/doc/Change.log.html

Modified: trunk/OutstandingGRNs.php
===================================================================
--- trunk/OutstandingGRNs.php	2010-11-28 07:09:57 UTC (rev 4172)
+++ trunk/OutstandingGRNs.php	2010-11-28 17:56:41 UTC (rev 4173)
@@ -39,7 +39,7 @@
 			suppliers
 		WHERE grns.supplierid=suppliers.supplierid
 		AND grns.podetailitem = purchorderdetails.podetailitem
-		AND qtyrecd-quantityinv <>0
+		AND qtyrecd-quantityinv>0
 		AND grns.supplierid >='" . $_POST['FromCriteria'] . "'
 		AND grns.supplierid <='" . $_POST['ToCriteria'] . "'
 		ORDER BY supplierid,

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-11-28 07:09:57 UTC (rev 4172)
+++ trunk/doc/Change.log.html	2010-11-28 17:56:41 UTC (rev 4173)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>28/11/10 Tim: OutstandingGRNs.php - Only show when the invoiced qty is less than the GRN qty</p>
 <p>28/11/10 Phil: All fixed asset scripts SupplierInvoice.php SupplierCredit.php SuppFixedAssetChgs.php - adding fixed assets directly from invoice charges - and reversing additions with credit notes. Also FixedAssetRegister.php report to print PDF or export CSV of fixed assets now includes date range depreciation and b/fwd cost b/fwd accum depn and c/fwd cost and accum depn - and NBV
 <p>28/11/10 James Murray: unset session in ConnectDB_mysqli.inc and ConnectDB_mysql.inc when the login fails
 <p>27/11/10 Phil install/index.php check for critical requirements before allowing install to proceed</p>


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