[Web-erp-svn] SF.net SVN: web-erp:[7813] trunk

[<tu...@us...>]

Revision: 7813
          http://sourceforge.net/p/web-erp/reponame/7813
Author:   turbopt
Date:     2017-08-11 00:57:38 +0000 (Fri, 11 Aug 2017)
Log Message:
-----------
CounterSales.php and StockAdjustments.php: Apply fixes posted by Tim in weberp forums.

Modified Paths:
--------------
    trunk/CounterSales.php
    trunk/StockAdjustments.php
    trunk/doc/Change.log

Modified: trunk/CounterSales.php
===================================================================
--- trunk/CounterSales.php	2017-07-27 03:54:05 UTC (rev 7812)
+++ trunk/CounterSales.php	2017-08-11 00:57:38 UTC (rev 7813)
@@ -1970,7 +1970,7 @@
 					VALUES (12,
 						'" . $ReceiptNumber . "',
 						'" . $_POST['BankAccount'] . "',
-						'" . $_SESSION['Items'.$identifier]->LocationName . ' ' . _('Counter Sale') . ' ' . $InvoiceNo . "',
+						'" . mb_substr($_SESSION['Items'.$identifier]->LocationName . ' ' . _('Counter Sale') . ' ' . $InvoiceNo, 0, 50) . "',
 						'" . $ExRate . "',
 						'" . $BankAccountExRate . "',
 						'" . $DefaultDispatchDate . "',

Modified: trunk/StockAdjustments.php
===================================================================
--- trunk/StockAdjustments.php	2017-07-27 03:54:05 UTC (rev 7812)
+++ trunk/StockAdjustments.php	2017-08-11 00:57:38 UTC (rev 7813)
@@ -220,7 +220,8 @@
 										reference,
 										qty,
 										newqoh,
-										standardcost)
+										standardcost,
+										narrative)
 									VALUES ('" . $_SESSION['Adjustment' . $identifier]->StockID . "',
 										17,
 										'" . $AdjustmentNumber . "',
@@ -231,7 +232,8 @@
 										'" . $_SESSION['Adjustment' . $identifier]->Narrative ."',
 										'" . $_SESSION['Adjustment' . $identifier]->Quantity . "',
 										'" . ($QtyOnHandPrior + $_SESSION['Adjustment' . $identifier]->Quantity) . "',
-										'" . $_SESSION['Adjustment' . $identifier]->StandardCost . "')";
+										'" . $_SESSION['Adjustment' . $identifier]->StandardCost . "',
+										'')";
 
 		$ErrMsg =  _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The stock movement record cannot be inserted because');
 		$DbgMsg =  _('The following SQL to insert the stock movement record was used');

Modified: trunk/doc/Change.log
===================================================================
--- trunk/doc/Change.log	2017-07-27 03:54:05 UTC (rev 7812)
+++ trunk/doc/Change.log	2017-08-11 00:57:38 UTC (rev 7813)
@@ -1,4 +1,5 @@
 webERP Change Log
+10/8/17 PaulT: CounterSales.php and StockAdjustments.php: Apply fixes posted by Tim in weberp forums.
 27/7/17 Exson: Fixed the search failure problem due to stock id code in SelectWorkOrder.php.
 18/7/17 Exson: Add QR code for item issue and fg collection for WO in PDFWOPrint.php
 17/07/17 RChacon: Fix call to image tick.svg.