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

[<ex...@us...>]

Revision: 7357
          http://sourceforge.net/p/web-erp/reponame/7357
Author:   exsonqu
Date:     2015-09-23 13:51:07 +0000 (Wed, 23 Sep 2015)
Log Message:
-----------
23/09/2015 Tim: ADD invoice to grns mapping data in SupplierInvoice.php. 

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

Modified: trunk/SupplierInvoice.php
===================================================================
--- trunk/SupplierInvoice.php	2015-09-21 17:30:10 UTC (rev 7356)
+++ trunk/SupplierInvoice.php	2015-09-23 13:51:07 UTC (rev 7357)
@@ -1546,6 +1546,13 @@
 			$DbgMsg = _('The following SQL to update the GRN quantity invoiced was used');
 			$Result = DB_query($SQL, $ErrMsg, $DbgMsg, True);
 
+			$SQL = "INSERT INTO suppinvstogrn VALUES ('" . $InvoiceNo . "',
+                                                    			'" .$EnteredGRN->GRNNo . "')";
+			$ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The invoice could not be mapped to the
+					goods received record because');
+			$DbgMsg = _('The following SQL to map the invoice to the GRN was used');
+			$Result = DB_query($SQL, $ErrMsg, $DbgMsg, True);
+			
 			if (mb_strlen($EnteredGRN->ShiptRef)>0 AND $EnteredGRN->ShiptRef != '0'){
 				/* insert the shipment charge records */
 				$SQL = "INSERT INTO shipmentcharges (shiptref,