Revision: 7411
http://sourceforge.net/p/web-erp/reponame/7411
Author: exsonqu
Date: 2015-12-10 10:03:15 +0000 (Thu, 10 Dec 2015)
Log Message:
-----------
10/12/15 Exson: Add invoice no while reprint GRN in ReprintGRN.php.
Modified Paths:
--------------
trunk/ReprintGRN.php
Modified: trunk/ReprintGRN.php
===================================================================
--- trunk/ReprintGRN.php 2015-12-10 09:35:17 UTC (rev 7410)
+++ trunk/ReprintGRN.php 2015-12-10 10:03:15 UTC (rev 7411)
@@ -49,16 +49,18 @@
exit;
}
$sql="SELECT grnbatch,
- grnno,
+ grns.grnno,
grns.podetailitem,
grns.itemcode,
grns.itemdescription,
grns.deliverydate,
grns.qtyrecd,
+ suppinvstogrn.suppinv,
suppliers.suppname,
stockmaster.decimalplaces
FROM grns INNER JOIN suppliers
ON grns.supplierid=suppliers.supplierid
+ LEFT JOIN suppinvstogrn ON grns.grnno=suppinvstogrn.grnno
INNER JOIN purchorderdetails
ON grns.podetailitem=purchorderdetails.podetailitem
INNER JOIN purchorders on purchorders.orderno=purchorderdetails.orderno
@@ -87,6 +89,7 @@
<th>' . _('Item Description') . '</th>
<th>' . _('Delivery Date') . '</th>
<th>' . _('Quantity Received') . '</th>
+ <th>' . _('Invoice No') . '</th>
<th>' . _('Action') . '</th>
</tr>';
@@ -105,6 +108,7 @@
<td>' . $myrow['itemdescription'] . '</td>
<td>' . $myrow['deliverydate'] . '</td>
<td class="number">' . locale_number_format($myrow['qtyrecd'], $myrow['decimalplaces']) . '</td>
+ <td>' . $myrow['suppinv'] . '</td>
<td><a href="PDFGrn.php?GRNNo=' . $myrow['grnbatch'] .'&PONo=' . $_POST['PONumber'] . '">' . _('Reprint GRN ') . '</a>
<a href="PDFQALabel.php?GRNNo=' . $myrow['grnbatch'] .'&PONo=' . $_POST['PONumber'] . '">' . _('Reprint Labels') . '</a></td>
</tr>';
@@ -114,4 +118,4 @@
include('includes/footer.inc');
-?>
\ No newline at end of file
+?>
|
