error in ReverseGRN.php
Phil,
There is a SQL statement in ReverseGRN that fails to execute.
$SQL = "SELECT grns.podetailitem,
grns.grnbatch,
grns.itemcode,
grns.itemdescription,
grns.deliverydate,
purchorderdetails.glcode,
purchorderdetails.assetid,
grns.qtyrecd,
grns.quantityinv,
purchorderdetails.stdcostunit,
purchorders.intostocklocation,
purchorders.orderno
FROM grns INNER JOIN purchorderdetails
ON grns.podetailitem=purchorderdetails.podetailitem
INNER JOIN purchorders
ON purchorderdetails.orderno = purchorders.orderno
WHERE AND grnno='" . $_GET['GRNNo'] . "'";
Note the last line
WHERE AND grnno='" . $_GET['GRNNo'] . "'";
Should there be something before the 'AND'?
|